RE: [PHP-DB] changing sort order of fields in MySQL From: Jeroen ten Berge (j.ten.berge <email protected>)
Date: 10/13/00

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 <email protected>]
Sent: vrijdag 13 oktober 2000 9:34
To: php-db <email protected>
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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>