Date index for Nov 2003
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [achievo] alphabetic
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
Junaid Mukhtar wrote:
| how can i make the phases and the projects etc so they are listed
| alphaphetically?
| A0: A14: A2: A3: A4: A5: A6: A7: A8:
The sort is done by the database, in this case MySQL. I've looked around
a bit, but there's no easy way to have it sort the way you want it to.
See for example:
http://list.azphp.org/pipermail/azphp/2002-August/001207.html
and http://forums.devshed.com/archive/4/2002/9/2/41899
In some cases, like in dropdowns with few items, we could 'manually'
sort the records in PHP, but in general that's not a solution.
The easiest way to have it sort the way you want is to lpad your
numbers. In other words, name them A04, A05 etc..
Greetings,
Ivo
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE/u2pE95NUnGFZm9cRAjKeAJ9J89wsFHLcqd3vJ7n3Gc/W0sQXIgCfdAoI
U/o88xPt1KMC/tNTmCpU3eo=
=o5VP
-----END PGP SIGNATURE-----