Check if coulumn exists 1

[smashing]

Quering a MySQL database with PHP, is it possible to find out if a particular column exists in a table, without outputing an error if in fact there is no column by such name?

 

[DRJ478]

You can always inspect the table structure with a query, e.g. "SHOW COLUMNS FROM `myTable`".

Also:
The very broad query "SELECT * FROM `myTable`" returns all columns. You could then inspect the returned data for existence of that column.