Repeating regions

[luckyblackcat]

Hi,

I have a property db with fields refno, country ,area, town, description, pic1 etc.

You get the pic ... course you do ...

I want to show 3 properties on a page each in nested html tables for layout reasons.

I've used .. $row = mysql_fetch_assoc($result);

The only idea I have is to use a varable to count which $row in the array $result has been displayed.
I want to use << < > >> to navigate.
Are there any features of MySQL/PHP to make this easier than my php counter idea (it doesn't seem very elegant)

Please don't say this a PHP problem, it may be but it is intertwined with MySQL ...


Thanks

LuckyBlackCat

 

[sleipnir214]

I strongly recommend that you read up on MySQL's LIMIT clause in SELECT statements. Read

http://www.mysql.com/doc/en/SELECT.html,

about 1/2-way down the page.


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!