$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]

Reply via email to