Question 1: HOw can I avoid adding duplicate entries. I was reading something about a unique constraint but found out that mySQL does not support that. I already have another column as my primary key. If I make the "Business Name" the primary key, will this avoid duplicate entries with the same business name? How can I add or change the primary key on existing columns?
Question 2: I am trying to insert the expiration date when the business listing is submitted from my PHP3 pages. I was trying the current date function + an INTERVAL. But nothing was being inserted into my mySQL database column....
This is what I was inserting into my PHP 3 page:
"Expiration_Date=CURDATE(), INTERVAL 6 MONTH)";
I also tried many variations, and nothing worked...I know you can do this for Select queries, but can you use this method for INSERT?