Re: [PHP] update mysql using radio button

2004-06-01 Thread Daniel Clark
Right. (oops) > From: "Daniel Clark" <[EMAIL PROTECTED]> > >> if($row->club_member >> ='N'){echo 'CHECKED';}?>> > > =='N', you mean. :) > > ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] update mysql using radio button

2004-06-01 Thread John W. Holmes
From: "Daniel Clark" <[EMAIL PROTECTED]> > club_member > ='N'){echo 'CHECKED';}?>> =='N', you mean. :) ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] update mysql using radio button

2004-06-01 Thread Matt Newell
al Message- From: Daniel Clark [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 1:14 PM To: Matt Newell Cc: [EMAIL PROTECTED] Subject: Re: [PHP] update mysql using radio button I think you need Values for the radio buttons. club_member ='N'){echo 'CHECKED';}?>&g

Re: [PHP] update mysql using radio button

2004-06-01 Thread Daniel Clark
I think you need Values for the radio buttons. club_member ='N'){echo 'CHECKED';}?>> > > hello all - > > i'm having a problem getting an UPDATE to work with radio buttons and > i'm not sure where it's gone wrong. the initial values are being grabbed > properly, but unfortunately they don't want

RE: [PHP] update mysql using radio button

2004-06-01 Thread Jay Blanchard
[snip] i'm having a problem getting an UPDATE to work with radio buttons and i'm not sure where it's gone wrong. the initial values are being grabbed properly, but unfortunately they don't want to get updated. the regular text form values update just fine. would appreciate some help. the html:

[PHP] update mysql using radio button

2004-06-01 Thread Matt Newell
hello all - i'm having a problem getting an UPDATE to work with radio buttons and i'm not sure where it's gone wrong. the initial values are being grabbed properly, but unfortunately they don't want to get updated. the regular text form values update just fine. would appreciate some help. the ht

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

Re: [PHP] UPDATE MySQL

2002-11-13 Thread Vernon Webb
I made some modifications to the code and I do not get ant error messages, but the database is still not updated. Here's the code: -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] UPDATE MySQL

2002-11-13 Thread Justin French
on 14/11/02 8:20 AM, vernon ([EMAIL PROTECTED]) wrote: > Can anyone tell me what's wrong with theis code. I don't get any errors but > the databse is never updated: > > $hostname_connPENPALS = "localhost"; > $database_connPENPALS = "phpenpals"; > $username_connPENPALS = "username"; > $password_c

Re: [PHP] UPDATE MySQL

2002-11-13 Thread Vernon Webb
s date and then redircts to the actual page they are going to. This however does not work I am getting a Parse error. -- Original Message --- From: Marco Tabini <[EMAIL PROTECTED]> To: vernon <[EMAIL PROTECTED]> Sent: 13 Nov 2002 17:18:18 -0500 Subject: Re: [PHP] UPDATE My

Re: [PHP] UPDATE MySQL

2002-11-13 Thread Marco Tabini
I can see two things that are not correct in the statement: First, the date you're setting is in UNIX format--but MySQL wont' like that. You need to use FROM_UNIXTIME. Second, the username is a string (I guess), but it's not within quotation marks. $myquery = "UPDATE penpals SET lastaccess=FROM_

[PHP] UPDATE MySQL

2002-11-13 Thread vernon
Can anyone tell me what's wrong with theis code. I don't get any errors but the databse is never updated: -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] UPDATE mysql

2002-06-22 Thread 1LT John W. Holmes
> $query = "UPDATE $table SET field1='$var1' WHERE id='$id'"; I really hope you don't have register_globals on, or you are validating the value of $table before you run this kind of query, otherwise your query is open up to an attack to update any table in the database... $table = "admin SET adm

Re[2]: [PHP] UPDATE mysql

2002-06-22 Thread Julie Meloni
CS> Actually, it looks to me like you're missing a semicolon terminating CS> your SQL statement. Try this: CS> $query="update $table set field1='$var1' where id='$id';"; Actually, that semicolon is not required (and I think it might even break it). The user should echo the query as suggested p

Re: [PHP] UPDATE mysql

2002-06-22 Thread Chris Shiflett
is actually >recieving. >- Original Message - >From: "Phil Schwarzmann" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Saturday, June 22, 2002 2:44 PM >Subject: [PHP] UPDATE mysql > >>I can't get UPDATE to work properly when querying M

Re: [PHP] UPDATE mysql

2002-06-22 Thread 1LT John W. Holmes
ysql_error()); ---John Holmes... - Original Message - From: "Phil Schwarzmann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, June 22, 2002 2:44 PM Subject: [PHP] UPDATE mysql > I can't get UPDATE to work properly when querying MySQL. > > $query

[PHP] UPDATE mysql

2002-06-22 Thread Phil Schwarzmann
I can't get UPDATE to work properly when querying MySQL. $query = "UPDATE $table SET field1='$var1' WHERE id='$id'"; I want to update one field of one row in a table. Is this syntax correct?

Re: [PHP] UPDATE - MySQL having some trouble

2002-01-23 Thread J.F.Kishor
hi, > I can't the UPDATE command in MySQL to work properly. Here is my > query > > $query = "update table set lastname=$lastname, firstname=$firstname ^ replace table with > where username=$username"; ($lastname,

[PHP] update mysql record

2001-12-08 Thread gee
Newbie is trying to edit a mysql record on my local machine using mysql 3.23.34 and PHP 4.04 and nothing gets updated after changes are made. I would be most grateful for any help Thank you Gee. "; ?> Latin Name: "; print "Common Name: "; print "Description: "; print "Height: "; print "Grow