sql troubles

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
psychotomus
Forum Contributor
Posts: 487
Joined: Fri Jul 11, 2003 1:59 am

sql troubles

Post by psychotomus »

what seems to be wrong with this?

Code: Select all

SELECT * FROM Test WHERE The_Title LIKE % dog %
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\websites\admin\animemid\www\advance_search.php on line 106
LIKE % dog %
nyy2000
Forum Newbie
Posts: 15
Joined: Tue Jul 12, 2005 12:40 am

Post by nyy2000 »

What's the exact code?
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

http://dev.mysql.com/doc/mysql/en/strin ... tions.html

Code: Select all

SELECT foo
FROM bar
WHERE col LIKE '%bar%'
Post Reply