bschultz Posted November 30, 2011 Share Posted November 30, 2011 I need to set up a DB so that only one entry can be made per time period (period's are set each half hour...) for each corporate entity. So, for 1:00am, I can only have 1 entry in the DB for Business A, one entry for Business B, and one entry for Business C The DB structure is as such: row_number (primary key, auto increment) date (varchar) - - - by the way, this isn't really a date, but a name (eve for Christmas eve, day for Christmas day) time (varchar) - - - entries will be from a form select of each half hour...12:00am, 12:30, 1:00am...etc) station (varchar) - - - this is where I need a unique field...I can only have have one match for station...for each TIME How can I set up these unique columns? Quote Link to comment Share on other sites More sharing options...
bschultz Posted November 30, 2011 Author Share Posted November 30, 2011 nevermind...don't like my CPANEL's phpmyadmin new skin...can't find anything on it. I found it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.