Sorry dudes, i am quite new to mysql ... can somebody tell me where is my mysql syntax error?! mysql> select * from `drink` where `id`=`99999`; ERROR 1054 (42S22): Unknown column '99999' in 'where clause' mysql> My table is looking like: mysql> describe drink; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | id | int(5) | | PRI | NULL | auto_increment | | title | varchar(64) | | MUL | | | | keywords | varchar(255) | | | | | | content | varchar(255) | | | | | | cat | varchar(64) | | | | | | subcat | varchar(64) | | | | | | ingredients | text | | | | | | method | text | | | | | | serve | varchar(64) | | | | | | nutriinfo | text | | | | | | visible | int(1) | | | 0 | | +-------------+--------------+------+-----+---------+----------------+ 11 rows in set (0.00 sec)
SELECT * FROM drink WHERE id='99999'; (you were using ` for the value id equals, ` can be used for table name and column names, SELECT * FROM `drink` WHERE `id`='99999'; would work fine too.) should really define the column names you want selected, instead of using *.