> Von: Caleb Walker [mailto:[EMAIL PROTECTED]]
> 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.


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to