SQL表:
user=ID、姓名、电子邮件
hero=ID,名称,等级
owner=userid,英勇的
我有两个问题:
$result = mysql_query("SELECT heroid FROM owner WHERE userid='$id'");
$heroid=mysql_fetch_row($result);
$result2 = mysql_query("SELECT name FROM hero WHERE ID = 'heroid[0]'");
$heroname = mysql_fetch_row($result2);
echo "User $id has a character named $heroname[0]";
$heroname = mysql_fetch_row($result2);
echo "User $id has a character named $heroname[0]";
..
这可以用一个查询完成吗?
是。你可以做:
SELECT h.name
FROM hero h
INNER JOIN owner o ON o.heroid = h.id
WHERE o.userid = $id