SELECT * FROM `movie_database`.`movie_list`WHERE `Title` LIKE '3'
SELECT * FROM `movie_database`.`movie_list`WHERE `Title` LIKE '^3'
SELECT * FROM `movie_database`.`movie_list`WHERE `Title` LIKE '^(3)'
Cheeers mate, i've tried running this query directly on my DB, and works perfectly, but no so when tryin 2 run it through my PHP scripts.
And now i get the error message; 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 'DESC' at line 1
$query [color=#0000FF]=[/color] [color=#FF0000]"SELECT * FROM movie_list WHERE Title LIKE '"[/color][color=#0000FF].[/color]$letter[color=#0000FF].[/color][color=#FF0000]"%' DESC"[/color];