At 8:11 PM +0100 1/6/01, Benjamin Pflugmann wrote:
>Hi.
>
>Btw, you don't want to use '*' as column specification in a SELECT
>except for testing purposes (or an advanced dynamic engine which can
>handle every input).
>
>There are several reasons, one of the most obvious: If you ever add a
>column to the table used, you have to change the PHP code which
>handles the result *whether or not* your code makes use of that
>column.
Not really. This is true only if you're referring to your column by
numeric indexes. It's not true if you get your row with mysql_fetch_object()
or with mysql_fetch_array() and reference column values by name rather
than column number.
>
>In other words: only ask for the columns you need. Then you can change
>the table down under and only have to change such PHP code which
>really makes usee of the new column.
--
Paul DuBois, paul@stripped
