Re: [PHP] update mysql from php web page

2004-04-07 Thread Daniel Clark
Something I like to do during troubleshooting is to have the page display the SQL statement I'm processing. Something like: print sql_query ; That was I can verify all the parameters are correct. Do you have autocommit ON? Or need to pass a commit statement? Daniel Clark > Of course, I d

Re: [PHP] update mysql from php web page

2004-04-07 Thread Chip Wiegand
"Daniel Clark" <[EMAIL PROTECTED]> wrote on 04/07/2004 10:17:36 AM: > For the submit button to work it has to be in a form. > > > > > > Hope this helps. > > Daniel Clark Of course, I didn't notice I left that line out of my code, although I did remember to put in the closing form tag. B

Re: [PHP] update mysql from php web page

2004-04-07 Thread Daniel Clark
For the submit button to work it has to be in a form. Hope this helps. Daniel Clark > > ... more code ... > > endif; > ?> > > > - > > I don't see any reason for the submit button to not work at all. What > should I look for now? > Thank

Re: [PHP] update mysql from php web page

2004-04-07 Thread Chip Wiegand
"Daniel Clark" <[EMAIL PROTECTED]> wrote on 04/06/2004 03:27:34 PM: > I think you need a WHERE clause for the UPDATE, otherwise it will update > ALL the records. > > e.g. WHERE OwnerName='$result' > > Then perhaps a redirect to another page. Thanks for the reminder. I set that, and found the p

Re: [PHP] update mysql from php web page

2004-04-06 Thread John Nichel
Chip Wiegand wrote: I have an existing web page that pulls some data and displays it in form input fields. I would like to add the ability to edit those fields and submit the changes to the server, but have been unsuccessful. What bit of code do I need to add to the existing code? This is the ex

Re: [PHP] update mysql from php web page

2004-04-06 Thread Daniel Clark
I think you need a WHERE clause for the UPDATE, otherwise it will update ALL the records. e.g. WHERE OwnerName='$result' Then perhaps a redirect to another page. > I probably need to use if(isset($submit)): and an update statement, but my > attempt just causes the web page to display completel

[PHP] update mysql from php web page

2004-04-06 Thread Chip Wiegand
I have an existing web page that pulls some data and displays it in form input fields. I would like to add the ability to edit those fields and submit the changes to the server, but have been unsuccessful. What bit of code do I need to add to the existing code? This is the existing code to displ