<?mysql_query ("SETNAMESGBK");$sql=mysql_query("SELECT*FROMcharactersleftjoindepartmentsondepartments.departme...
mysql_query("SET NAMES GBK");
$sql = mysql_query("SELECT * FROM characters left join departments on departments.departmentid=characters.departmentid ORDER BY salary DESC LIMIT 0,20"); while ($data = mysql_fetch_array($sql)){ ?>
echo $data["rmbs"]; ?>
姓名: echo $data[name]; ?> 薪金: echo $data[salary]; ?> 年龄: echo $data[reborns]; ?> 部门: echo $data[departments.name]; ?>? }?>
----------------------------------------------------------------
有两个表,人物表characters和部门表departments,要求在网页中显示人物姓名、年龄、薪金和其所在的部门,并且以薪金从高到低显示出前20位的人物。
现在的问题是显示不出人物所在的部门名称
请高手指教,多谢!!!
展开