Re: [PHP] limit contral

[Jono Bacon]

James Shergold wrote:

Hi, all

I'm quite new to php and still finding my way round and came
across a problem.

I'm making a script that pulls property (house) from a mysql
database in categories e.g. there cat1, cat2 ect and in each
category I only want to show 10 properties a time then click
next to show the next 10 properties in that catorgy.

here is the main part of the script
http://www.smoothdesign.com/green/

if anyone can help that would be great.

James
[EMAIL PROTECTED]

Hi James,

You can limit the number of results using SQL:

SELECT foo FROM bar ORDER by blah LIMIT 10

As for showing a page at a time - I have not done this before in PHP, but it is referred to as paging. Have a search on google and I am sure you will find a solution.

Jono




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php