Re: Retrieving Rows - Can I Change The Order?

> Von: Caleb Walker [mailto:cwalker@cwalk.org] > Gesendet: Samstag, 28. Juli 2001 08:26 > An: Dave Watkinson; PHP-MySQL List > Betreff: Re: [PHP-DB] Retrieving Rows - Can I Change The Order? > > > > > Now then, I have changed a column in the table, and the > only way I found to > > change a data type is to delete the offending column and > then add it again. > > > > When I do the select now the new column, which was at > $row[3] is now always > > $row[39]. I don't mind this, because I know where it is, > but is there any > > way I can make it appear at $row[3] again? I'm sure you can > imagine when > > there are quite a few pages using this code it's easier to > reorder the > > columns in the select than to change all my if() codes! > You should use mysql_fetch_array() instead of mysql_fetch_row(), so you can refer to your columns by name, as in: $q = mysql_query("select id,name from address;"); $a = mysql_fetch_array ($q); ==> now you can use $a['id'] and $a['name'] to get the field's values. I found it always good practice to name all affected columns in a query, so you have no pain if your columns get mixed by db alters. Thomas