can some show me with a working example of looping thru a SQL database with PHP.
Display only the first 10 Items then have a next10 and prev10
This is what i have but it displays all items
$command="SELECT * FROM $table_name WHERE active<>'N' order by sort_order";
$display="This is the Header"."<p>";
while($block = mysql_fetch_array($result))
$display.= $block['title'] ."<p>";
$display.="The is the footer";