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: 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!

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(137 Değerlendirme)

Bu iş için 3 freelancer ortalamada $33 teklif veriyor


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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(95 Değerlendirme)

please check PMB for demo

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(25 Değerlendirme)