> 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.
Thomas
--
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]
