i do not know how to do it, and id is correct one, shall i show the screenshot of phpmyadmin?
In phpmyadmin select the database, click on the SQL tab and paste the query (displayed by the die statement) into the textarea. Click the Go button and the query will execute on your database. If there are errors in the query phpmyadmin will tell you.
OK, you were too fast for me. Next thing we can do is you post the last version of the scripts and the tables in question (structure and data). I can try to recreate the problem here in my environment. If you post the table do it in a SQL form. Make sure confidental data is anonymized.
Query executed successfully:UPDATE db_purchase_form SET db_product_name = 'Video Message 1', db_actor = 'bride', db_user_name = 'ghfghfg', db_user_email = 'email@example.com', db_vdo_script = ' fg gg fg fg f fgh g f', db_hrt_msg = '', db_port_approval = 'yes', db_delivery = 'express', db_price = '41.94', db_date_time = NOW() WHERE id = '57'
but this is not the data i changed on the page. This is the earlier data in the DB. This means, somehow newer data is not sustained, or is being lost, but where?
this data is generated using your code, i removed mine.
Also the lines you wrote above
"Next thing we can do is you post the last version of the scripts and the tables in question (structure and data). I can try to recreate the problem here in my environment. If you post the table do it in a SQL form. Make sure confidental data is anonymized."
can you explain in simple english? what am i supposed to do?
Post the latest version of the scripts that are involved and the structure of the tables and data in a SQL format (export from phpmyadmin) for all the tables that are mentioned in queries. I will import the tables and data into my test database and try to run scripts on my local server. This is the only thing that comes to my mind to help you find the solution to the problem.
To export the tables structure and data in SQL format select the table in phpmyadmin, click on the export tab, leave all options default and click Go. You will be able to save the SQL statement (describing table structure and data) on your local machine. Do this for all tables in question and send everything as an attachment. I will do import (in phpmyadmin) and test the scripts in my environment.
If you are uncomfortable doing this you do not have to. Also if you prefer you can send all this as a personal message to me here on DW.
If the other issue is not related then please mark this thread as solved and start a new one.
The nature of the forum is such that all memebers see the topic and the ones that have time try to help. Everyone gains by learnig solutions to various problems. This is why I would prefer that we carry on through the forum not on skype. I do not have much time to offer you a full time assistance and also am on a 3G connection most of the time (limited bandwith and traffic) so Skype is not my favourite way of communication.
So try to describe the problem as clearly as possible, post the relevant code and help will come sooner or later.