Reply to thread

Message: <blockquote data-quote="sri_lion" data-source="post: 6834833" data-attributes="member: 4103">Ok I think I know your problem... you've set primary keys for "date" and "user_id" this doesn't work that way because "user A" and "user B" maybe getting only single row per day in the database.. right?But the next day they are going to get another row... so having those fields as PK won't do it... because it needs to repeat.. you need a separate PK for this say for example "daily_id" or something...You need to control your input in your script... in the script you make your own primary key by checking "user_id+today's date" when you want to put the record in.. you need to check today's date(string) and user_id combination.. I'll try to give you the pseudo here..[code]variable my_id = Avariable today = 25022010variable count = count rows in db where user_id= my_id and todays_date =  todayif (variable count > 1){    allow edit only and pop-up msg "you cannot create a new row, would you like to edit the existing one?"}else {    add a new row}[/code]</blockquote>

Top Bottom