★ wanayoo — archive 1999 http://www.devshed.com/Server_Side/PHP/Introduction/comments.html/c596/Nouvelle recherche | Portail wanayoo

Developer Shed
Thursday, 08.17.2000  
Introduction to PHP and web database interfacing with MySQL. PHP3 is an HTML-embedded scripting language allowing web developers to create dynamic, database-driven websites.

HOME > SERVER SIDE > PHP > ARTICLE > COMMENTS    PHP SOURCE

Power Search
Free Newsletter:


Client Side
DHTML
Flash
Graphics
JavaScript
XML

Server Side
Administration
JServ
MySQL
Perl
PHP
Python
Roxen
Zend
Zope

Tools
HTML Editors
Graphic Editors
FTP Programs

Dev Talk
Forums
Mailing List
Book Samples
Brain Dump
Developer News
Feedback

ClipScripts
Add script
Edit script

Other Stuff
DevShed RDF
Propaganda!


Advertise
on DevShed
.
PHP3 Introduction
Introduction to PHP and web database interfacing with MySQL. PHP3 is an HTML-embedded scripting language allowing web developers to create dynamic, database-driven websites.

Name: Yu-Gin Ng
Subject: Re: Breaking result sets into multiple pages in PHP3
Date: 05-31-1999 02:34AM

If you are using mySQL, use the 'limit' keyword in your SQL statement. e.g. "SELECT name, age FROM employees LIMIT 9,5" will return 5 rows starting from the 10th row. For the next page you can use "LIMIT 14,5" to return the next 5 rows.


Other posts in this thread:
 Top
 • Breaking result sets into multiple pages in PHP3  Nat P.  05-28-1999 12:56AM 
       • Re: Breaking result sets into multiple pages in PHP3  Yu-Gin Ng  05-31-1999 02:34AM 


Reply to this post:
Name:

Preview Comment.
Notify me of replies to this message.
Email:
Subject:
Tip: Put any source code between [code][/code] tags to increase readability


Visit the PHP Forum!

New On DevShed:
• MySQL Developer Contests PostgreSQL Benchmarks
• PHP 101 (part 3) - Chocolate Fudge And Time Machines
• MaxSQL Announced
•  PHP 101 (Part 2) - Shakespeare's Rose
• PHP 101 (Part 1) - Secret Agent Man
• The Search For The Perfect Web Host
• Perl 101 (Part 5) - Sub-Zero Code
•  Submit Your News..

Hot Forum Topics:
• Credit Cards


Adsmart Network ad
Copyright © 1997-2000 ngenuity. All rights reserved. Privacy Policy.