RE: [PHP] Show only user that variable "music"contain "pop"

2002-11-27 Thread John W. Holmes
> $req = MYSQL_QUERY("SELECT id FROM $TBL_NEWS ORDER BY nom LIMIT 0, > $limit_news"); > $res = MYSQL_NUM_ROWS($req); > > This is my lines... It's not working... :-( Use mysql_error() to find out why. Odds are one of your variables aren't set when you think they are. $req = mysql_query(" ... ") o

Re: [PHP] Show only user that variable "music"contain "pop"

2002-11-27 Thread Benjamin Trépanier
$req = MYSQL_QUERY("SELECT id FROM $TBL_NEWS ORDER BY nom LIMIT 0, $limit_news"); $res = MYSQL_NUM_ROWS($req); This is my lines... It's not working... :-( Thanks for your help Le 27/11/02 15:23, « Support @ Fourthrealm.com » <[EMAIL PROTECTED]> a écrit : > > If you only have one condition, t

Re: [PHP] Show only user that variable "music"contain "pop"

2002-11-27 Thread Support @ Fourthrealm.com
If you only have one condition, then get rid of the AND in the where statement; Select only the fields that you need, instead of * Like this: SELECT id FROM $TBL_NEWS WHERE music LIKE '%pop%' ORDER BY name Peter At 03:16 PM 11/27/2002 -0500, Benjamin Trépanier wrote: Hi, I need information

[PHP] Show only user that variable "music"contain "pop"

2002-11-27 Thread Benjamin Trépanier
Hi, I need information about a simple command... I have a DB (of course...) and I need to show only "ID" that variable "music"contain "pop" I found this example that is suppose to do a similar thing in a msql query... SELECT * FROM $TBL_NEWS WHERE music LIKE '%pop%' AND ORDER BY name So it'