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;


Beceriler: PHP

Daha fazlasını görün: 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

İşveren Hakkında:
( 33 değerlendirme ) Newark, United States

Proje NO: #139110



I can do it in 15 mins!

0 gün içinde 30$ USD
(137 Değerlendirme)

3 freelancers are bidding on average $33 for this job


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

1 gün içinde 30$ USD
(95 Değerlendirme)

please check PMB for demo

in 0 gün içinde40$ USD
(25 Değerlendirme)