hey all i got a question where i am not sure that it will be possible.
i already have my table in my data base which has values in it ex: first_property. and i made a little script which helps me grab all the names in the form that i will be posting to the DB and puts it into a sql query.
ex:
ALTER TABLE `properties` ADD `first_property` TEXT NULL ,
ADD `second_property` TEXT NULL ,
etc
;
but i do have duplicates on different pages and i run into the error
#1060 - Duplicate column name 'first_property'
now the question: is there a syntax for sql to skip that name if it exist
thanks for any help.