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

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