I have a mySQL table set up with three columns: "id" (autoincrement), "addy" (email address), and "zip" (zip code). The problem I am having is that for every legitimate new row I get, I also get a couple rows with a blank addy and zip. Is there something I can change in the structure of those columns, for example, make "addy" required so that if it is blank, the row is not added? I have it required on the Flash and PHP end, but I was hoping the mySQL structure itself would deny a row if "addy" was blank. Thanks in advance for your help.

I don't believe that MySQL supports CHECK constraints, so there probably isn't any declarative way to do what you've requested. If you can presume that email addresses are unique, then you could use a unique index on the address column and "salt" the table with a predefined row with a blank addy.

-PatP

NOT NULL might help you out here