select question

[eMonk]

One of my tables has 28 columns.

 

I'm going to be echoing 9 of the columns in my index file.

 

Which of the following queries would be better to do this as they both work:

 

$query = "SELECT * FROM model";

 

$query = "SELECT column1, column2, column3, column4, .... FROM model";

 

[eMonk]

Guess I'll go with

 

$query = "SELECT column1, column2, column3, column4, .... FROM model";

 

because it makes more sense and just fetches the data I'll be using.

 

The first query is just smaller code so I was wondering which would be better but after some thought I think the second one would be better unless someone else says otherwise.

[Pikachu2000]

As a general rule, it's always better to name the fields explicitly rather than use a wildcard *, so yes, the second one IMO.

[ManiacDan]

As an aside: If your column names are actually "column1" "column2" etc, you're doing it wrong.

 

-Dan