I have built a forum, and it works well apart from a couple of things. I want to be able to display how many replies have been submitted, and when they were submitted. Because I am only displaying the initial thread post on the results page (just as this forum does), I need to be able to update the original records date so that it then appears at the top of the results page with the amount of replies displayed... a bit of user friendliness really. I can't use timestamp because I already have a counter in place that increments by 1 each time the page is viewed. As a result, auto updating a timestamp would falsely reorder the results page.
The original thread and its replies all come from one table and I am relating them by a thread ID linking to the original post ID
So, that's my reason for the insert and update from the same form post and only needing to update those two columns.
I did try a recordset (rs_replyID) to give me the record that I want to update, but it returned an ID of '0' in the URL rather than the correct ID and caused an error when inserting and updating. I chose to use $_SESSION['USES_threadID'] which actually updated the correct record, but only with 0's. So I assumed I had done something wrong in the Update Single Record wizard. I didn't actually think that I'd need to use a recordset for this as they only retrieve content from the DB don't they?
Is update and insert from one form post possible with MySQL? I am told it's possible with SQLServer by a .NET expert I know, and he can't see why it should be in MySQL, but, I know there's differences between SQLServer and MySQL.
Does the order have an effect on locking the table? I have it in update first, then insert... should it be insert then update?
OR... have I simply entered the wrong code into the wizards Binding Panel value? Is NOW() valid code to enter there?