At 8:11 PM +0100 1/6/01, Benjamin Pflugmann wrote:
>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
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