Select Order

BEFOR

I have six seperate drop menus to update up-to six maximum values per user, out of a many-to-many table.

Beleive this can be done with the SELECT ORDER BY DESC

But how can the first value be SELECTED, the second value be selected, etc, so I can simply apply this six times for the six drop menus? Is this a very reliable way to go? I hessitate, since six one-to-many seperate col's would be very reliable but that route would involve OR six times in the select statement for a large directory structure -- high processing required for table scans?

bpat1434

WHy not SELECT * FROM table_name ORDER BY id DESC.

Then, call a while loop, create a counter, then if the counter = 1, put in first dropdown, 2, second and so on and so forth?

~Brett

Roger_Ramjet

Not sure I follow you. out of a many-to-many table 😕 What exactly is that?

One thing I can tell is that you do not understand relational databases properly.

high processing required for table scans?

You do not need to scan a whole table, you create an index. Read these articles database indexing and database design, and the mysql manual on indexing . Then rethink your approach.

six one-to-many seperate col's would be very reliable

Reliable is what you want. Once you understand how a relational database works then you will not worry about the other stuff.