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? Link to comment https://forums.phpfreaks.com/topic/252100-unique-question/ 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. Link to comment https://forums.phpfreaks.com/topic/252100-unique-question/#findComment-1292504 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.