$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, 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 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's not working properly... >> >> Thanks for your help >> >> Ben >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php > > - - - - - - - - - - - - - - - - - - - - - > Fourth Realm Solutions > [EMAIL PROTECTED] > http://www.fourthrealm.com > Tel: 519-739-1652 > - - - - - - - - - - - - - - - - - - - - - > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > $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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
