Em Andamento

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

<?php

include("db_connect.php");

$command="SELECT * FROM $table_name WHERE active<>'N' order by sort_order";

$result=mysql_query($command);

$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

Ver 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

Premiar a:

PinkCrow

I can do it in 15 mins!

$30 USD em 0 dias
(137 Avaliações)
6.6

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

omsoftware

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)
8.6
oscguy

please check PMB for demo

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