Re: changing sort order of fields in MySQL

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@getexo.nl] > > Sent: Friday, October 13, 2000 10:36 AM > > To: php-db@lists.php.net > > 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@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 > > > > > > -- > > 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 > > -- > 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