[SOLVED] error in this

[chocopi]

When i try to use this code:

 

<?php	
$query = @mysql_query("SELECT id,name,desc,hp,item FROM enemies WHERE id>0 ORDER BY rand() LIMIT 1");
$row = @mysql_fetch_assoc($query) or die(mysql_error());
$enemy_id = $row['id'];
$enemy_name = $row['name'];
$enemy_desc = $row['desc'];
$enemy_hp = $row['hp'];
$enemy_item = $row['item'];
?>

 

I get this 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 'desc,hp,item FROM enemies WHERE id>0 ORDER BY rand() LIMIT 1' a 

[MadTechie]

try

@mysql_query("SELECT id,name,`desc`,hp,item FROM enemies WHERE `id`>0 ORDER BY rand() LIMIT 1");

 

desc isn't a valid field name

[chocopi]

Cheers thats sorted it,

 

just for future reference, by using the ' ' what has it done ?

 

~ Chocopi

[MadTechie]

the `` (backticks) allow you to use "illegal" words, its not recommended you should really change the name of the field!

[chocopi]

oh ok, Cheers