Archief - PHP: Mysql: omslachtige methode

$result = mysql_query("SELECT raceid,racename FROM race WHERE raceid = '$race'");
$rowrace = mysql_fetch_row($result);
$result = mysql_query("SELECT serverid,servername FROM server WHERE serverid = '$serverid'");
$rowserver = mysql_fetch_row($result);
$result = mysql_query("SELECT classid,classname FROM class WHERE classid = '$class'");
$rowclass = mysql_fetch_row($result);

echo "$charname (Level $level ".$rowrace[1]." ".$rowclass[1].") toegevoegd op server '".$rowserver[1]."'.";

$sql = "
SELECT r.racename, s.servername, c.classname 
FROM race AS r
LEFT JOIN server AS s ON (s.serverid = '$serverid')
LEFT JOIN class AS c ON (c.classid = '$class')
WHERE r.raceid = '$race'
";