I am trying to make a PHP/HTML update script for MySQL.
I prompt the user to enter the ID# of the record they wish to update into a form which then uses the passed ID# to select the associated record from the database:
Expand|Select|Wrap|Line Numbers
- $id = @$_GET['q'] ;
Expand|Select|Wrap|Line Numbers
- $query = "SELECT FROM Hcffres WHERE residentid = $id";
- mysql_query($query);
Expand|Select|Wrap|Line Numbers
- Last Name: </font></td><td><input type="text" name="lastname" value="<?php echo $lastname; ?>" size="40"</td></tr>
-- thanks for any help --