Select *

[Pico_Train]

I'm about to start a new site.

I would like to just select content using select * .

Is that an issue security wise?

The site will have a user's area where they can submit content after logging, I will use CHAP auth if that has anything to do with the above...

Thanks!

[bkeep]

As long as you are sanitizing your user input used for queries it shouldn't be a problem.

If you only need one column worth of data though you shouldn't use *
So if I only wanted shoe size for anyone wearing Nikes
SELECT size FROM table WHERE brand = 'nike'

[Pico_Train]

Yeah cool. Am sanitizing user input yes.