Jump to content

need help with ordering mysql query results.


newb

Recommended Posts

the results in my query are showign up like this:

 

DP2

DP1

SL2

SL1

1

2

3

..

10

11

12

 

 

how can i get them to show up like this instead:

DP1

DP2

SL1

SL2

1

2

3

..

10

11

12

 

here's my query:

SELECT varname
FROM table
WHERE cat_id =8
ORDER BY varname+0 ASC

 

any help is appreciated, thanks.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.