Problem with updating MySQL table
| From: | Jason Pruim | Date: | Wed, 27 Aug 2008 16:06:12 +0000 |
| Subject: | Problem with updating MySQL table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-45255@lists.php.net to get a copy of this message | ||
Hi Everyone,
So I'm working on a project (Same one I sent the question about regarding the user access rights on monday) And now I am attempting to update the record... Here is some of my code:
index.php
<?PHP
<form method="post" action="purlprocess.php">
First Name/Last Name<input type="text" name="txtFName" value="{$row['FName']}" $edit> <input type="text" name="txtLName" value="{$row['LName']}" $edit><br>
Email Address <input type="text" name="txtEmail" value="{$row['email']}" $edit><br>
Company name <input type="text" name="txtBusiness" value="{$row['Business']}" $edit><br>
Company Address <input type="text" name="txtAddress1" value="{$row['Address1']}" $edit><br>
City/State/Zip <input type="text" name="txtCity" value="{$row['City']}" $edit> <input type="text" name="txtState" value="{$row['State']}" $edit> <input type="text" name="txtZip" value="{$row['Zip']}" $edit><br>
Phone <input type="text" name="txtPhone" value="{$row['phone']}" $edit><br>
Your Favorite Type of coffee: <input type="radio" name="rdoCoffee" value="Starbucks"> <img src="../media/starbucks.jpeg" width="10%"> <input type="radio" name="rdoCoffee" value="Folgers"> <img src="../media/folgers.jpeg" width="10%"> <input type="radio" name="rdoCoffee" value="Other"> Other: <input type="text" name="txtCoffee" size="20"><br>
When would a good time to bring it over be? <input type="text" name="txtMeeting"><br>
<input type="submit" value="Yes! Give me the caffeine!">
<input type="hidden" name="Record" value="{$row['record']}">
</p>
</form>
?>
purlprocessing.php
<?PHP
$FName= $_POST['txtFName'];
$LName= $_POST['txtLName'];
$Email= $_POST['txtEmail'];
$Business = $_POST['txtBusiness'];
$Address1 = $_POST['txtAddress1'];
$City = $_POST['txtCity'];
$State = $_POST['txtState'];
$Zip = $_POST['txtZip'];
$CoffeeChoicetest = $_POST['rdoCoffee'];
//$Coffee = $_POST['txtCoffee'];
$Phone = $_POST['txtPhone'];
$Record = $_POST['Record'];
$Meeting = $_POST['txtMeeting'];
$date = time();
$IPAddress = $_SERVER['REMOTE_ADDR'];
if ($CoffeeChoicetest == "Other"){
$Coffee = $_POST['txtCoffee'];
}else{
$Coffee = $_POST['rdoCoffee'];
}
$sql = "UPDATE
schreur set FName='{$FName}', LName='{$LName}', email='{$Email}', Business='{$Business}', Address1='{$Address1}', City='{$City}', State='{$State}', Zip='{$Zip}', Coffee='{$Coffee}', subscribed='0', date='{$date}', IPAddress='{$IPAddress}', Meeting='{$Meeting}' WHERE record='{$Record}'";
mysqli_query($link, $sql) or die("Could not update..." . mysqli_error($link));
?>
mysql> describe schreur;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |+------------+-------------+------+-----+---------+-------+
| FName | varchar(20) | YES | | NULL | | | LName | varchar(20) | YES | | NULL | | | email | varchar(50) | YES | | NULL | | | phone | varchar(12) | YES | | NULL | | | url | int(12) | YES | | NULL | | | record | int(7) | YES | | NULL | | | subscribed | int(1) | NO | | | | | date | varchar(12) | YES | | NULL | | | IPAddress | varchar(19) | YES | | NULL | | | Business | varchar(20) | YES | | NULL | | | Address1 | varchar(50) | YES | | NULL | | | City | varchar(20) | YES | | NULL | | | State | varchar(2) | YES | | NULL | | | Zip | varchar(10) | YES | | NULL | | | Coffee | varchar(20) | YES | | NULL | | | Meeting | text | YES | | NULL | |+------------+-------------+------+-----+---------+-------+ The problem is when I am attempting to update some of the info, it erases the info in the field. Anyone got a clue as to what is going on? :) Thanks for looking! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com japruim@raoset.com