mysql query fejl
jeg har lidt kode:function listen()
{
echo "<table style=\"border: 0px; border-collapse: collapse; width: 100%;\" cellpadding=\"5\">
<tr height=\"30\">
<td><b>Id</b></td>
<td><b>Mærke</b></td>
<td><b>Model</b></td>
<td><b>køn</b></td>
<td><b>Forhandler</b></td>
<td colspan=\"2\" align=\"center\"><b>Ændringer</b></td>
</tr>";
$query = mysql_query("SELECT * FROM cykler");
while($row = mysql_fetch_array($query))
{
$i++;
if($i%2 == '0')
{
$bg = "#BFD3A5";
}
else
{
$bg = "#FFFFFF";
}
$q =
mysql_query("
SELECT
model.navn as model,
cykelhandlere.navn as forhandler,
koen.navn as koen,
maerke.navn as maerke
FROM
model,
maerke,
koen,
cykelhandlere
WHERE
koen.id=". $row['koen'] ."
AND model.id=". $row['modelid'] ."
AND maerke.id=model.maerkeid
AND cykelhandlere.id=". $row['forhandlerid'] ."
ORDER BY model.navn ASC")
or die(mysql_error());
$r = mysql_fetch_array($q);
echo
"<tr height=\"20\" bgcolor=\"". $bg ."\">
<td>". $row['id'] ."</td>
<td>". $r['maerke'] ."</td>
<td>". $r['model'] ."</td>
<td>". $r['koen'] ."</td>
<td>". $r['forhandler'] ."</td>
<td><a href=\"?id=". $_GET['id'] ."&sid=". $row['id'] ."\">". Rediger ."</a></td>
<td><a href=\"?id=". $_GET['id'] ."&func=slet&sid=". $row['id'] ."\">slet</a></td>
</tr>";
}
echo "<tr height=\"30\"><td style=\"text-align: center;\" colspan=\"6\"><a href=\"?id=". $_GET['id'] ."&sid=0\">Tilføj en ny cykel</a></td></tr></table>";
}
og den siger:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND model.id=1 AND maerke.id=model.maerkeid AND cykelhandle
kan i sige hvad der er galt?
