Check Column exists

[kpowning]

I have the following script:

$DB_site->query("
         ALTER TABLE " . TABLE_PREFIX . "user 
         ADD `totalreferrals` INT( 10 ) DEFAULT '0' NOT NULL");

Is there any way to check and see if this column already exists? Basically try to make this an if exists do this else do that...

HELP IS APPRECIATED...

[ShadowMetis]

You could just do a SELECT * query and if it returns true, then it exists, if not then it doesn't.

[devinemke]

or do a SHOW COLUMNS or DESCRIBE query