UPDATE...
| From: | Harlequin | Date: | Sun, 11 Jul 2004 00:20:35 +0000 |
| Subject: | UPDATE... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-190153@lists.php.net to get a copy of this message | ||
Hi again. I know I should be in bed but if I leave this I'll just go mad...!
I have a page that successfully calls data from the database based on userID
& Password combo. No Problems there eh... I display the information in a
form, the user is supposed to be updating this information and then hitting
submit to update their particular record. But guess what...? No Juice...!
On the 1st page I have this:
$UserID=$row["UserID"];
--->> the UserID should be limited to one single row by this stage in the
code as the user has been validated.
Later on the page I have this:
echo "<input type=\"hidden\" name=\"TXT_UserID\"
value=\"$UserID\" />";
--->> The variable "$UserID" is sent to page 2 no...?
On the 2nd page I have this:
$UserID= $_POST['TXT_UserID'];
$Comments= $_POST['TXT_Comments'];
$FurtherComments= $_POST['TXT_FurtherComments'];
$UserMail= $_POST['TXT_UserMail'];
$CV= $_POST['TXT_CV'];
$sql = "UPDATE RegisteredMembers SET Comments=$Comments,
FurtherComments=$FurtherComments, $UserMail=UserMail, DocumentData=$CV
WHERE UserID=$UserID";
I'd really appreciate any help as I feel like this is the penultimate hurdle
for me. Data in - data out.....!
--
-----------------------------
Michael Mason
Arras People
www.arraspeople.co.uk
-----------------------------