Looping SQL

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";

echo $display;


Habilidades: PHP

Veja mais: looping sql, p sql, sql, sql c, database sql, C# SQL, show block, php include header footer, sql select select, sql select order, sql select, pinkcrow, sql sql, footer php, order items database php, sql order, php display sql, order items php, include header php, include header, header footer php, display sql php, order active, block footer, php database result display

Acerca do Empregador:
( 33 comentários ) Newark, United States

ID do Projeto: #139110

Concedido a:


I can do it in 15 mins!

$30 USD em 0 dias
(137 Comentários)

3 freelancers estão ofertando em média $33 para esse trabalho


hello we are exp. and can help u in 2 hr. Looking forward to hear from you thanks

$30 USD em 1 dia
(95 Comentários)

please check PMB for demo

$40 USD in 0 dias
(25 Comentários)