RE: [PHP] Re: Retrieving Data To Edit
| From: | Jay Blanchard | Date: | Fri, 09 Jul 2004 14:53:35 +0000 |
| Subject: | RE: [PHP] Re: Retrieving Data To Edit | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-190069@lists.php.net to get a copy of this message | ||
[snip]
$sql = "SELECT UserFirstName FROM RegisteredMembers WHERE
UserID='$_POST[TXT_UserID]'";
[/snip]
please change
$sql = "SELECT UserFirstName FROM RegisteredMembers WHERE
UserID='$_POST[TXT_UserID]'";
to the proper syntax of
$sql = "SELECT UserFirstName FROM RegisteredMembers WHERE
UserID='" . $_POST['TXT_UserID'] . "' ";
[snip]
echo "<tr>";
echo "<td>a little about me:</td>";
echo "<td><input type = 'text' name = 'TXT_FurtherComments'
value='FurtherComments field should appear here'></td>";
echo "<td>20 characters max</td>";
echo "</tr>";
[/snip]
echo "<td><input type = 'text' name = 'TXT_FurtherComments'
value='FurtherComments field should appear here'></td>";
should be
echo "<td><input type = \"text\" name =
\"TXT_FurtherComments\"
value=\" $UserFurtherComments\"></td>";