DB Select Limits

From: Date: Fri, 12 Jan 2001 15:58:58 +0000
Subject: DB Select Limits
Groups: php.windows 
Request: Send a blank email to php-windows+get-4950@lists.php.net to get a copy of this message
I have a web board script that I need to impose a limit on the database select. I tried using: SELECT * FROM posts where of_forum='$forum_num' AND POST_ID <= '$upper' AND POST_ID >= '$lower' and SELECT * FROM posts where of_forum='$forum_num' ORDER BY POST_ID desc LIMIT '$lower','$upper' $lower and $upper are defined from the url. But that doesn't seem to work. Any ideas? -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: BenC@intasept.com Web: http://www.intasept.com "MAKING sense of the INFORMATION TECHNOLOGY age @ WORK......"

« previous php.windows (#4950) next »