[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

[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 help is

RE: [PHP] Re: sql query question

=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 Date: Thu, 12 Feb 2004 16

[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 =