sivanvega Posted August 7, 2010 Share Posted August 7, 2010 Hi, I have a simple mySQL database and I would like to update using a simple html form. One of the field is "accepted" and is type "boolean". I have a texbox where I will write the record id and another button which will change the "accepted" value from 0 to 1 for that record id. The problem is that I don't know how to start.... Thanks in advance Sergio [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/210066-update-a-record/ Share on other sites More sharing options...
Ruzzas Posted August 7, 2010 Share Posted August 7, 2010 $loadLast100JokesSQL = 'SELECT * from jokes_en ORDER BY joke_posting_date LIMIT 1,100 DESC'; That should load you're last 100 jokes inside the mysql server plus, I'm sure you need capitals for SELECT, ORDER BY, LIMIT and DESC Link to comment https://forums.phpfreaks.com/topic/210066-update-a-record/#findComment-1096318 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.