PDA

View Full Version : Mysql Help!!



мϊкэ
09-08-2005, 09:59 AM
right on my page which shows all of the affiliates, how do i show all of the affiliates after a certain id say i wanted to show only the affiliates after the id 5 how do i edit the mysql query so it does that?


$result = mysql_query("SELECT * FROM affiliates ORDER BY id LIMIT 5");

мϊкэ
09-08-2005, 01:22 PM
:'( Ignored yet again!! <(*_*<)

^ ^ ^ Bump!

Mentor
09-08-2005, 02:44 PM
you set it out like this

LIMIT 5 , 30

wich will show 30 results after the 5th one

so
$result = mysql_query("SELECT * FROM affiliates ORDER BY id LIMIT 5 , 10");

wich should show 5 results after the 10th one, just sort of follow on with that basis

Want to hide these adverts? Register an account for free!