Order By

[stebut05]

Hi all,

Thanks for taking a look at this thread. I have a database query that retuens the results correctly, but i need to do an order by clause. When i do this it displays numbers before letters, whereas i need to display letters then number e.g

Jobcard No Page No.
PRE001 page 1
PRE002 page 1
POS001 page 1
POS001 page 2
POS002 page 1
455101 page 1
455101 page 2
455101 page 3
567070 page 1 etc, etc, etc,

the field Jobcard No. is a Varchar i think i need to changed to asci and Order By that way. I'm not sure though, any ideas??? Thanks for any help, advice, thoughts in advance.

Kind Regards,

Steven

[laserlight]

That's problematic. Your database system might allow for some natural ordering mechanism, if not, you have to use [man]natsort/man or [man]natcasesort/man in PHP.

[stebut05]

Hi,

Thanks for your reply. Can you give me some more infor on natsort() and natcasesort(), also where would i put either of them?

Regards,

Steven

[laserlight]

Information on the functions can be found in the PHP Manual. You would need to place the result set retrieved from the database into an array.