**solved** PHP Code WHERE cause dose not work
Posted 24 April 2006 - 07:11 PM
The problem I wanted to solve was to have all the information that containted the word Amature in the rank colom to only be displayed.
This part of the script.
$sql = 'SELECT * FROM `Cooking_guild` WHERE `rank`=Amateur ORDER BY `lvl_cap` ASC ';
For some resion it comes up with this error:
Unknown column 'Amateur' in 'where clause'
But if I replace the word with a number like 500 there is no error at all, but cause I wanted all the amaterur rank info displayed and since 500 is not even a rank it dose not work.
Where am I going wrong here?
Posted 24 April 2006 - 07:13 PM
$sql = "SELECT * FROM Cooking_guild WHERE rank='Amateur' ORDER BY lvl_cap ASC "; ect..
Posted 24 April 2006 - 07:15 PM
I've been out of php for a good year, so I'm kind of new again.
This has solved my headace.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users