I've been having a bit of a problem with getting some information from the mysql database. 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?