Welcome to WebmasterWorld Guest from 23.23.46.20

Forum Moderators: coopster & jatar k

publishing the entire database on multiple pages

   
11:02 pm on May 13, 2003 (gmt 0)

10+ Year Member



I'm learning php and mysql using DreamweaverMX. Have had success on simple things. But I want to publish an entire database online similar to a small phone book - three columns per .php page, and 30 or 40 pages total on the site.

Is there any way to connect the three cells (columns) on each .php page so the data from mySQL will string out through all three cells, and then at the end of the last cell go on to the first cell on the next page?

The ability to do that would simply be wonderful...

11:09 pm on May 13, 2003 (gmt 0)

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



I don't completely understand what you want to do.

<guess>You want to select from mysql a certain number of records, write display them on the page and then have the whole next/previous thing?

11:24 pm on May 13, 2003 (gmt 0)

10+ Year Member



An example would be if I have 500 records in the mySQL database and I want to publish all of them. But I can only reasonably get 20 records per .php page.

Right now I can easily draw up the first 20 records on the first page. But if I filter to bring up all 500 records from the database, how do I bring up records 20-40 on page 2?

As a side note, if I have two tables on page 1, I can easily get recordes 1-10 in table 1, but how do I get records 11-20 in table 2?

 

Featured Threads

Hot Threads This Week

Hot Threads This Month