RE: [PHP-DB] changing sort order of fields in MySQL From: Irfan Uygur (irfan <email protected>)
Date: 10/13/00

Thanks but for sure i know that the way MySQL stores field names doesn't
affect anything. Maybe i wasn't able to express
myself clearly, when i run my php code and enter data, i look at the mySQL
dbase and see if my program stored the values correctly in-place
While looking at the dbase by MyAdmin, the field values are shown the order
of creation date so i can't follow my entered-values easily by logical
order.

Irfan Uygur

> -----Original Message-----
> From: Jeroen ten Berge [mailto:j.ten.berge <email protected>]
> Sent: Friday, October 13, 2000 10:36 AM
> To: php-db <email protected>
> Subject: 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 <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> 

-- 
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>