 | |
Re: mysql table order and php sort() ?
comp.databases.mysql comp.databases.mysql
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: mysql table order and php sort() ? -
05-23-2011
, 03:04 AM
|
Hello Using the code, echo "Order: $key, Number: $value <br />"; I see $value as 11 to 20 followed by 51 to 60 but when the data goes into the mysql table I see 59 down to 51 followed by 20 down to 11 followed by 60. Why not in ascending numeric order in the table? |
specify it with the order by clause in your select statement.
/Lennart
[...]
#2
| |||
| |||
|
|
On 2011-05-23 09:19, geoff (AT) invalid (DOT) invalid wrote: Hello Using the code, echo "Order: $key, Number: $value <br />"; I see $value as 11 to 20 followed by 51 to 60 but when the data goes into the mysql table I see 59 down to 51 followed by 20 down to 11 followed by 60. Why not in ascending numeric order in the table? A table has no order. If you want to order retrieved data you have to specify it with the order by clause in your select statement. /Lennart [...] |
Thanks for your reply.
I do currently use 'order by' the date/time and wish to keep that
order - is it possible to keep this order but also order by the
question number field (an integer)?
Cheers
Geoff
#3
| |||
| |||
|
|
On 2011-05-23 09:19, geoff (AT) invalid (DOT) invalid wrote: Hello Using the code, echo "Order: $key, Number: $value <br />"; I see $value as 11 to 20 followed by 51 to 60 but when the data goes into the mysql table I see 59 down to 51 followed by 20 down to 11 followed by 60. Why not in ascending numeric order in the table? A table has no order. If you want to order retrieved data you have to specify it with the order by clause in your select statement. /Lennart [...] |
got it! order by field1, field2 ...
Cheers
Geoff
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.