I am trying to update mysql database table with command :$query = "UPDATE tablename SET textbox = '$textbox1' WHERE textbox = '$textbox'"; $textbox1 and $textbox i am getting form form as follows :
<form method="post" action="UPDATE.php3">
</form>
Some how it is not updating. I will be thanking for help.
ads
[This message has been edited by ads (edited February 12, 2000).]
Using a long string of text as your conditional is asking for trouble. Don't you have an index for the row that you could use to identify it instead?
I tried with this also but still not working.
$query = "UPDATE $userstable SET textbox = '$textbox1' WHERE name = '$name'";
when i try this
$query = "UPDATE $userstable SET textbox = 'xyzabc' WHERE name = 'somename'";
it works.
All variable values '$textbox1', '$name'
are creating problems.
Waiting for reply.
Thanks
[This message has been edited by ads (edited February 14, 2000).]
print $query before sending it to make sure your variables are in there correctly.
Hi rod,
I have changed as per your suggestion and I got it with
$query = "UPDATE $userstable SET textbox = '$textbox1' WHERE name = '$name'";
Thanks for help