RE: [PHP] Re: sql query question

n_id=zawraqclassif-20 Download Ready-Made Templates for your site: http://www.aplustemplates.com/cgi/affiliates/c1.cgi/zawraq_ad Original Message Follows From: Ben Ramsey <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], tony <[EMAIL PROTECTED]> Subject: [PHP] Re: sql query question D

[PHP] Re: sql query question

select * from table where locate("new",descript)>0 or locate("car",descript)>0; "Tony" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] hi if i have new car and i want to search each word in description can i do SELECT * FROM table WHERE descript = "new" OR descript ="car"?? any hel

[PHP] Re: sql query question

This is a SQL question, rather than a PHP question, so I would suggest doing a google search on SQL tutorials, but I think what you are trying to do would work like this: SELECT * FROM table WHERE descript LIKE '%new%' OR descript LIKE '%car%' Tony wrote: hi if i have new car and i want t

[PHP] Re: SQL Query Question

You could simply execute a second query where score > $score and return the number of rows in the result + 1. For instance: $return = mysql_query("select ID, Name, Score, COUNT(Name) as total from members where ID = '$ID'"); $row = mysql_fetch_assoc($return); extract ($row); $return = mysql_quer