Re: changing sort order of fields in MySQL

why don't you just add to your program a validation screen that shows you the information you just entered in the order you want to view it? you can program it to allow you to accept, delete, or edit the record. where the info is in the database is not relevant. it is up to you to write your php code to diplay the info the way you want to view it. you can do this yourself using a php page or you can type the query in the fields provided in myadmin. not everyone wants to view info in a database the same way. we query the database to get the data we want in the format we want to see it. --scott 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