help me its wierdo

[webtuto]

hey whhy this code douesnt succeed

$sql="select * from slayer.photo order by id desc where `group`='$cat'" or die(mysql_error());
$res=mysql_query($sql)or die(mysql_error());

 

the error =>

 

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 'where `group`='maroc'' at line 1

[adam291086]

the sql commands should be capital

 

SELECT

FROM

ORDER

WHERE

[rajivgonsalves]

your syntax is wrong your putting the order by before the where also there are php syntax errors your code should be

 

 

$sql="select * from slayer.photo where `group`='$cat' order by id desc";
$res=mysql_query($sql)or die(mysql_error());