MY PHP doesn't update data. Here is my code:
<html>
<body>
<meta charset="utf-8">
<title>სატელეფონო ცნობარი</title>
<?php
include('connection.php');
if(isset($_GET['id'])) {
$id=$_GET['id'];
if(isset($_POST['submit'])) {
$tarigi=$_POST['addedon'];
$teleponi2=$_POST['tel2'];
$teleponi3=$_POST['tel3'];
$departamenti2=$_POST['department2'];
$departamenti3=$_POST['department3'];
$web=$_POST ['url'];
$email=$_POST['email'];
$address=$_POST['address'];
$comment=$_POST['comment'];
$query3=mysql_query("update phonebook set addedon='$tarigi', tel2='$teleponi2',tel3='$teleponi3', department2='$departamenti2' , department3='$departamenti3' url='$web', email='$email', address='$address', comment='$comment' where id=$id");
if($query3) {
header('location:listcnobari.php');
}
}
$query1=mysql_query("select * from phonebook where id='$id'");
$query2=mysql_fetch_array($query1);
?>
<fieldset style="width:325px;">
<form method="post" action="">
დამატების თარიღი:<input type="text" name="addedon" value="<?php echo $query2['addedon']; ?>" /><br />
ტელეფონი2:<input type="text" name="tel2" value="<?php echo $query2['tel2']; ?>" /><br />
ტელეფონი3:<input type="text" name="tel3" value="<?php echo $query2['tel3']; ?>" /><br>
დეპარტამენტი2:<input type="text" name="department2" value="<?php echo $query2['department2']; ?>" /><br />
დეპარტამენტი3:<input type="text" name="department3" value="<?php echo $query2['department3']; ?>" /><br />
ვებ.გვერდი:<input type="text" name="url" value="<?php echo $query2['url']; ?>" /><br />
ელ.ფოსტა:<input type="text" name="email" value="<?php echo $query2['email']; ?>" /><br />
მისამართი:<input type="text" name="address" value="<?php echo $query2['address']; ?>" /><br />
კომენტარი:<input type="text" name="comment" value="<?php echo $query2['comment']; ?>" /><br />
<input type="submit" name="submit" value="Update" />
</form>
<?php
}
?>
</body>
</html>
Change your query to
$query3=mysql_query("update phonebook set addedon='$tarigi', tel2='$teleponi2',
tel3='$teleponi3', department2='$departamenti2' , department3='$departamenti3', url='$web', email='$email',
address='$address', comment='$comment' where id=$id");
You missed a comma
department3='$departamenti3' url='$web'
You missed a comma.
change
department3='$departamenti3' url='$web'
to
department3='$departamenti3', url='$web'