limiting records..

Hi all,

I have searched this forum quite a bit and did find some resources but were not very helpfull..

Hope someone can help me out again..

I have a table with fields, sec_id, message1, message2 and message3.

I need to limit the number of messages to 10 per page and have a next link to display further 10 messages and so on..

Would be gratefull if anyone can furnish me a code..

TIA,
sandeep

<?php

if(!$start)
{
$start = 0;
}
//run your sql here
select sec_id, message1, message2,message3 FROM tableName LIMIT($start, 10);

//display results however you may here

//display a link that increases $start var
echo "<a href=\"$SCRIPT_NAME?start=$start+10\">Next 10 results<\a>";

-- bad hack --