problem with mysql_query

[bob2006]

can any see why i get an SQL syntax error on this code i know i have used it be for any it worked if you can it would me very helpful thank you

<?php
include'db.php';
$rand=rand(1,9);

$data = mysql_query("SELECT * FROM order ") 
or die(mysql_error()); 
while($info = mysql_fetch_array ( $data )) 
{ 

$rondom=$info[random];


}
if($rand==$rondom){
$rand=rand(1,9);
}else
echo"$rand";

?>

[paul2463]

order is a mysql reserved word so to mysql your query is rubbish, you havnt told it which table to get the data from and what column to order it on

 

have a look <A href="http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html"> HERE </a> for  alist of the reserved words

 

to help your immediate problem try this for the query

 

$data = mysql_query("SELECT * FROM `order` ") or die(mysql_error()); 
// note the ticks around the owrd order are back ticks not single quotes it tells mysql that the
// the word is just a word and not a command..hope that helps

[jitesh]

$data = mysql_query("SELECT * FROM order ")

or die(mysql_error();