RE: [PHP-DB] changing sort order of fields in MySQL

That does not matter, how it is stored; With your select statement you can use any order you want. select name,sex,age.location,tel,fax from faketable order by <Field you want to order on> -----Original Message----- From: Irfan Uygur [mailto:irfan@pusulanet.com.tr] Sent: vrijdag 13 oktober 2000 9:34 To: php-db@lists.php.net Subject: [PHP-DB] changing sort order of fields in MySQL I know this sounds stupid, but i'm currently designing a MySQL dbase that's going to work mith my PHP code, and as the program gets more and more complex, i have to add new fields to MySQL. I'm using MyAdmin in order to speed up the db stuff and while listing the fields MyAdmin sorts the fields' creation date. For ex if i have name,sex, location, tel, fax fields and then if a later add a field "age" it lists the fields as name,sex, location, tel, fax , age but it would be more easier for me to follow-up if listed the fields as name, sex, age, location, tel, fax. So is there a way to change the order of appearance of fields ? I looked up the MySQL ref but couldn't find any relevant info about this. Thanks in advance. Irfan Uygur -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net