Reply to thread

Message: <blockquote data-quote="sri_lion" data-source="post: 6835999" data-attributes="member: 4103">It doesn't matter bro... for this first of all you need a good form validation if the user input the data... make sure the data string passed by the form is always standard creating a date drop down is your best option!Ok lets look at the picture below think that this is your table.. with data..[ATTACH]13860[/ATTACH]Whenever the user trying to create a new record (fill the form and hit submit) your script must look through the database whether the date format together with his ID exist or not, in the example above user_id = 123 already has a row for the date 25022010So when he wants to create another one for the same date, in the form he enters Feb 25, 2010 (will be converted to the string 25022010) now you look through the database for a row that's user_id = 123 and for a string in the date column = 25022010 (which is the date he just entered)if this is found in a single row, then a row exist, then you only allow UPDATE command in SQL.. not CREATE..If the row found.. throw a message with Yes and No asking "Record already exist would you like to edit?" if "Yes" you take the user to an editing form but hide the date (or show the date as a label not as a input)That's all... BTW what language you using for this?</blockquote>

Top Bottom