[SOLVED] Selecting row with values

[dreamwest]

I need to select the last row from a column with a value, so  thought something like this:

 

$result = mysql_query("SELECT * FROM example WHERE cost !='' ORDER BY id DESC LIMIT 1") 
or die(mysql_error());  

But it doesnt work, Im guessing change to this but i need to make sure its right first before i try it

 

$result = mysql_query("SELECT * FROM example WHERE cost NOT NULL ORDER BY id DESC LIMIT 1") 
or die(mysql_error());  

 

 

[Mchl]

try IS NOT NULL

[dreamwest]

try IS NOT NULL

 

I dont know why this still isnt working:

 

$result = mysql_query("SELECT * FROM example WHERE total IS NOT NULL ORDER BY id DESC LIMIT 1") 
or die(mysql_error()); 

 

Throw 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 'WHERE total IS NOT NULL ORDER BY id DESC LIMIT 1' at line 1

[Mchl]

Try putting table name (example) in backticks ``

SELECT * FROM `example` WHERE total IS NOT NULL ORDER BY id DESC LIMIT 1

[dreamwest]

Thanks. Its working now.

[Mchl]

Congratulations. You have discovered undocumented reserved word.