subject:"Re\: \[PHP\] Re\: SQL Query"

RE: [PHP] Re: sql query question

2004-02-12 Thread Hamid Hossain

Hi, It is better to use FullText. Convert the description field to FullText. You will gain a powerfull control in this case. For more information on how to use FullText read a little-bit in the MySql manual (MATCH AGAINST) commands. Regards, Hamid Hossain --- Check Amazon.co

RE: [PHP] Re: SQL Query

2003-02-15 Thread Willie G

ruary 15, 2003 11:01 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Re: SQL Query The result recived from that query is this ID SubID Interest Valid Edit Delete 4 3 Star Craft 1 But I want a Query that retrives "Star Craft", "Strategi", "Spel" and &qu

Re: [PHP] Re: SQL Query

2003-02-15 Thread Zydox

The result recived from that query is this ID SubID Interest Valid Edit Delete 4 3 Star Craft 1 But I want a Query that retrives "Star Craft", "Strategi", "Spel" and "Datorer"... :/ "Willie G" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >

RE: [PHP] Re: SQL Query

2003-02-15 Thread Willie G

Zydox, Please define 'sub-interest'. I've looked at what Uttam gave you, and it looks correct, assuming you want want it limited to the same user. If you result should be 'all with Interest = X and Valid = Y", just remove the userid from the second query. SELECT InterestsList.ID, InterestsList.