homepage Welcome to WebmasterWorld Guest from 54.197.183.230
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
publishing the entire database on multiple pages
astounded

10+ Year Member



 
Msg#: 202 posted 11:02 pm on May 13, 2003 (gmt 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...

 

jatar_k

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



 
Msg#: 202 posted 11:09 pm on May 13, 2003 (gmt 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?

astounded

10+ Year Member



 
Msg#: 202 posted 11:24 pm on May 13, 2003 (gmt 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?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved