GetAFreelancer.com - Looping SQL

Looping SQL

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

Status: Closed (Selected Service Provider)

Selected Providers: selected service provider PinkCrow

Budget: $30-100

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

Bidding Ends: 04/17/2007 at 14:06 EDT

Project Creator: skibumjim
Buyer Rating:
(20 reviews)

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

Database: MySQL

Operating system: Linux

Bid count: 3

Average bid: $ 33

Related project

Nonpublic project #329111 ^Featured ^Nonpublic

Messages Posted: 0

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

Service Providers

PMB

Bid

Delivery Within

Time of Bid

Provider Rating

omsoftware

$ 30

1 day

04-16-2007 14:12 EDT

(70 reviews)

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

oscguy

$ 40

0 days

04-16-2007 14:15 EDT

(28 reviews)

please check PMB for demo

PinkCrow

$ 30

0 days

04-16-2007 14:22 EDT

(123 reviews)

I can do it in 15 mins!

[ Web Development ] [ EU Freelance ] [ Post Project Free ]

What is GetAFreelancer.com? ( Read about the company )

Bookmark our homepage to make sure you don't forget about our website next time you need to develop an IT project for yourself or your company. Outsourcing is hiring an outside organization to perform services such as information processing and applications development. Find freelance programmers, web designers, copywriters and translators. Companies of any size have used our web services. Outsourcing is the process of subcontracting network operations and support to an organization outside your own company. Try it free today!

Would you like to outsource your next project? Would you like to make money as a freelancer? Click Sign Up to start! Our mission is to find the best possible freelance workers at the best possible price. Our escrow feature is developed to protect both buyers and sellers.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.