simple mysql query problem
Posted: Tue May 19, 2009 4:01 pm
Code: Select all
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$sql = 'UPDATE appt
SET fname = "$fname", lname = "$lname", street = "$street", zip = "$zip", phone = "$phone", problem = "$problem", booked = "Y"
WHERE id="$id"';
mysql_select_db("robbroa1_fox", $con);
$retval = mysql_query( $sql, $con );
if(! $retval )
{
die('Could not update data: ' . mysql_error());
}
echo "Updated data successfully\n";
mysql_close($con);