Sql syntax error

[jargen]

Whenever i try this code i get a syntax error. Any help?

 

SELECT * FROM wp_newsoptions WHERE option='often'

[sader]

u can see error by

mysql_query(blabla bla);
echo mysql_error();

 

since query look fine u must double check table name, field name

[jargen]

All i get is a syntax error.

#1064 - 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 'option="often" LIMIT 0, 30' at line 1

[sader]

can u show your code please?

[jargen]

My code is: SELECT * FROM wp_newsoptions WHERE option='often'

I am running it via the sql query in phpmyadmin.

 

[sader]

It's not code but query string.

Ok would u get eneythink from this query

SELECT * FROM wp_newsoptions

[jargen]

yes.

[PFMaBiSmAd]

option is a reserved mysql keyword. Either rename your column to something else or enclose option in back-ticks `option` in every query.