MYSQL ordered table

	Home Register Search Help Login

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

MYSQL ordered table

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> MYSQL ordered table

Page: [1]


komrad Posts: 4 Joined: 7/24/2008 Status: offline	MYSQL ordered table - 1/6/2009 6:47:02 Hello all, I'd like to know if there is a way to insert into a MYSQL table data in an ordered way? Right now as a workaround I've literally made a table of questions with questionID as primary key, nextQuestion and prevQuestion pointing to other questionIDs. Basically I've made a two way linked list from scratch. Is there anything built into MYSQL that implements this? Thanks in advance.


bobby Posts: 11828 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: MYSQL ordered table - 1/7/2009 16:51:54 Are you pulling data from somwhere in the database via query? If so, you can arrange that query by ascending or descending order based on one of the DB fields (like questionIDs) _____________________________ Talk to your kittens about catnip, or someone else will. (in reply to komrad)