Project Detail

Looping SQL  

Looping SQL is project number 139110
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: PinkCrow

Budget: $30-100

Created: 04/16/2007 at 14:06 UTC

Bid Count: 3

Average Bid:
$ 33

04/17/2007 at 14:06 UTC

Project Creator: skibumjim
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (26 reviews)

Bid On This Project
 

Description

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

Job Type

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

30

0 days

04-16-2007 14:22 UTC

I can do it in 15 mins!

help

 

30

1 day

04-16-2007 14:12 UTC

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

help

 

40

0 days

04-16-2007 14:15 UTC

please check PMB for demo

help


    Bid on this Project