Web Hosting Talk







View Full Version : mySql SELECT help please.. [LIMIT]


dpny
11-05-2003, 06:01 PM
this is what i have right now:

$sql_text = ("SELECT * from $usertable ORDER BY quoteID DESC");

what i want to do is... pull out result from the database only those that have the number "2" on them on the row name "cat", like put a limit where it only pull out info if there is "2" in the "cat" and ORDER BY quoteID DESC

Burhan
11-05-2003, 06:36 PM
$sql_text = "SELECT * from $usertable WHERE cat = '2' ORDER BY quoteID DESC";

dpny
11-05-2003, 06:52 PM
thank you sho mush...
:D