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
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
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
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
[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:
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
"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
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
"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
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
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
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
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
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
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_
> $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
Actually, it looks to me like you're missing a semicolon terminating
your SQL statement. Try this:
$query="update $table set field1='$var1' where id='$id';";
1LT John W. Holmes wrote:
>It's correct for PHP, but there's no telling what MySQL is actually
>recieving.
>- Original Message -
It's correct for PHP, but there's no telling what MySQL is actually
recieving. Are you sure all of those variables have values?? Yeah? Are you
really sure??
Use mysql_error() with your query.
$result = mysql_query("UPDATE ...") or die("Error in update: " .
mysql_error());
---John Holmes...
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,
19 matches
Mail list logo
