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
-----------------------------

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to