|
|
||||||
|
||||||
| Index Link To US Private Messages Archive FAQ RSS | ||||||
| Graphics & Design Discussion Forum Post your graphics design questions/comments/ideas in here. Ask questions, post tutorials, discuss trends and best practices. Sub-forum for website accessibility and usability. |
Share Thread: & Tags
|
||||
|
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|||
|
I've a web site based on php and mysql database.
I create a web page for each record of the database and an "index" page for all records, sorted by country ann name. You can see records divided by country or by name. I'd like to add in every web page bottons like "next" and "previous" for visitng pages without come back to the "index" page every time. How can I do this? |
|
|||
|
Something along this line would work:
Next record: SELECT * FROM table WHERE record_id > $current_id ORDER BY record_id LIMIT 1 Previous record: SELECT * FROM table WHERE record_id < $current_id ORDER BY record_id LIMIT 1 Of course, sub your nomenclature for table, record_id, etc. We use a product called CodeCharge to do a bunch of our PHP coding. Take a look: http://www.codecharge.com Need very few programming skills to create very useable stuff in about 8 languages (PHP, .NET, ASP, etc.)
__________________
:not_the_usual1 [you decide] ________________ All in my opinion, which, when combined carefully with a $1 bill, gets you a cup of coffee at the corner store. |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
WebProWorld |
Advertise |
Contact Us |
About |
Forum Rules |
MVP's |
Archive |
Newsletter Archive |
Top |
WebProNews
WebProWorld is an iEntry, Inc. ® site - © 2009 All Rights Reserved Privacy Policy and Legal iEntry, Inc. 2549 Richmond Rd. Lexington KY, 40509 |