[RESOLVED] order of navagation menu

cspgsl

I have a db "ques" with 2 fields, "id_ques" (primary) and "title_ques".
I have a nav menu that takes its contents from "title_ques" in the db. I want the menu to sort by "id_ques" and show "title_ques" but no amount of changing the paramaters seems to do this.
Being new I suspect that I am missing a basic step but I can't locate any info about displaying the order of a field based on another field in a record set
Thanks

bradgrafelman

Have you tried adding this to your query?

SELECT ... ORDER BY `id_ques` ASC

The 'ASC' means ascending, so it'll be in increasing order (1, 2, 3...). If you'd rather have DESCending, then simply change that keyword.

cspgsl

Yes, this is the recordset SQL

SELECT title_ques
FROM ques
ORDER BY id_ques ASC

bradgrafelman

And you're saying that does not order them the way they should?

cspgsl

No, it doesn't. It's a mystery to me too.

bradgrafelman

What column type is id_ques ?

Also, have you tried copying and pasting that query into a GUI such as phpMyAdmin?

cspgsl

int(11)

cspgsl

Thanks Brad, gotta go for the evening. I'll be back aroud 6am in the morning if you think of anything

Houdini

Your query would produce the titles in ascending order from the oldes (or first to last) as just the title. I am assuming the ques_id is an int data type of some sort that is auto incrementing and if you altered the query just a little you would see something like the below.

id_que title_que
1 Where is the beef?
2 Florida Vacation
3 War in Iraq,
4 Pot Roast Recipe
5 Using Chemicals Safely

SELECT id_ques, title_ques
FROM ques
ORDER BY id_ques ASC 
LIMIT 0 , 5

Would produce the above and conversly if you used DESC instead of ACS it would show the fake titles above in order of the newest to the oldest. I mean you only have two columns and there really are only so many ways to order them so what is it that you really want them to do?

cspgsl

I got it... I was only selecting the id_ques and not both values from the recordset... It's amazing how much time I can fritter away when inexperience reigns.

I think that I am possibly crossing purposes here although in my mind it makes sense.

I am working in Dreamweaver MX. I want the menu to be dynamic in case I need to add or subtract items but each item needs to point to a different page. Right now all of the links are pionting to the same page which is set up in the template. I cannot see where I would set the url for each resulting entry in the menu. Maybe I cannot and this is the wrong method?

Thanks

cspgsl

Houdini:
Have you got any thoughts re: my last post?
If not, thanks and I shall close this one and start again.