$end should be 15.
ie:
LIMIT 50, 10
will display 10 rows starting from 51.
so, it will show rows 51-60 (included)
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
-----Original Message-----
From: McShen [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 22, 2001 3:00 PM
To: [EMAIL PROTECTED]
Subject: [PHP] what's wrong with this?
this is something related to my last post.
$start is passed by the url. like http://mydomain.com/links.ph?start=0;
$end =$start+15;
$query = "SELECT * FROM refer ORDER BY hits desc LIMIT $start,$end";
it didn't work. Please help.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]