PHP update
Posted: Fri Aug 11, 2006 8:00 pm
feyd | Please use
feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
This is my code which won't work for some reason. It says record updated but it doesn't actually do it.Code: Select all
<?
$id=$_POST['id'];
$type=$_POST['type'];
$firstname=$_POST['firstname'];
$lastname=$_POST['lastname'];
$email=$_POST['email'];
$phone=$_POST['phone'];
$problem=$_POST['problem'];
$helped=$_POST['helped'];
$date=date(Y-m-d);
$username="root";
$password="1247133182";
$database="customers";
mysql_connect(localhost,$username,$password);
mysql_query ("UPDATE customerdata SET type='$type',firstname='$firstname',lastname='$lastname',email='$email',phone='$phone',problem='$problem',helped='$helped',date='$date' WHERE id='$id'");
echo "Record Updated";
mysql_close();
?>feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]