MySQL Forums
Forum List  »  Newbie

trying to make php/mysql search system
Posted by: Chris Ashton
Date: April 05, 2006 04:00PM

got everything working but the only problem i have is my actual sql query, it never returns any results

$sql = "SELECT * FROM objects WHERE Object_Name OR Description OR Keywords ORDER BY ObjectID DESC" ;

basically i want to search eith the object_name, description or keywords field for whatever the user has inputted into the search box

any ideas on why it doesnt work?

cheers for any help

Options: ReplyQuote

Written By
trying to make php/mysql search system
April 05, 2006 04:00PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.