Re: [PHP-DB] changing sort order of fields in MySQL From: Michael T. Babcock (mbabcock <email protected>)
Date: 10/13/00

If you want to do that, you must add a timestamp field and sort by it instead.

create table (
Name varchar(25),
Email varchar(50),
Timestamp timestamp);

select * from mytable order by timestamp;

Irfan Uygur wrote:

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

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