List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 7 2001 3:34am
Subject:Re: Displaying Only Entrys Starting with A
View as plain text  
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
Thread
picture storing on a tableTexscene_Support6 Jan
  • Re: picture storing on a table(Jason Nugent)6 Jan
  • Displaying Only Entrys Starting with AChadd Nervig6 Jan
    • Re: Displaying Only Entrys Starting with ASiim Einfeldt aka Itpunk6 Jan
      • Re: Displaying Only Entrys Starting with AChadd Nervig6 Jan
      • Re: Displaying Only Entrys Starting with A(Jason Nugent)6 Jan
      • Re: Displaying Only Entrys Starting with AChadd Nervig6 Jan
        • Re: Displaying Only Entrys Starting with ABenjamin Pflugmann6 Jan
          • Re: Displaying Only Entrys Starting with APaul DuBois7 Jan
            • Re: Displaying Only Entrys Starting with ABenjamin Pflugmann7 Jan
      • Re: Displaying Only Entrys Starting with AGustavo Vieira Goncalves Coelho Rios6 Jan
      • Re: Displaying Only Entrys Starting with AGustavo Vieira Goncalves Coelho Rios6 Jan
  • ColdFusion, Mysql and odbc<LD>6 Jan
    • Re: ColdFusion, Mysql and odbcMiguel Angel Sol√≥rzano6 Jan
      • AW: ColdFusion, Mysql and odbcAeberli Reto6 Jan
    • AW: ColdFusion, Mysql and odbcAeberli Reto6 Jan
  • Re: picture storing on a tableDanny7 Jan