Welcome to WebmasterWorld Guest from 54.147.10.12

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

publishing the entire database on multiple pages

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

New User

10+ Year Member

joined:July 10, 2002
posts:40
votes: 0


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)

Administrator

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

joined:July 24, 2001
posts:15755
votes: 0


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)

New User

10+ Year Member

joined:July 10, 2002
posts:40
votes: 0


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?