Проблем с Replace

[Mapu0]

Здравейте,можете ли да ми помогнете,че когато натисна бутона submit i не се replace-ва в базата данни

if ($_POST['name'] && $_POST['address'] && $_POST['city_id'] && $_POST['director'] && $_POST['phone'] && $_POST['email'])
mysql_query("REPLACE INTO test (name,address,city_id,director,phone,email)
VALUES(".$_POST['name'].",".$_POST['address'].",".$_POST['city_id'].",".$_POST['director'].",".$_POST['phone'].",".$_POST['email'].")");

$select = mysql_query("SELECT * FROM test WHERE id=".intval($_GET['id']))or die(mysql_error());
if (mysql_num_rows($select)) $red = mysql_fetch_array($select);

mysql_close();
?>

Ако има нужда и формата ще Ви я дам.

 

[echo123]

Ползвай UPDATE `table`

 

[Mapu0]

ами отново не ми го променя в базата

 

[SkyWarrioR]

Здравейте,можете ли да ми помогнете,че когато натисна бутона submit i не се replace-ва в базата данни

if ($_POST['name'] && $_POST['address'] && $_POST['city_id'] && $_POST['director'] && $_POST['phone'] && $_POST['email'])
mysql_query("REPLACE INTO test (name,address,city_id,director,phone,email)
VALUES(".$_POST['name'].",".$_POST['address'].",".$_POST['city_id'].",".$_POST['director'].",".$_POST['phone'].",".$_POST['email'].")");

$select = mysql_query("SELECT * FROM test WHERE id=".intval($_GET['id']))or die(mysql_error());
if (mysql_num_rows($select)) $red = mysql_fetch_array($select);

mysql_close();
?>

Ако има нужда и формата ще Ви я дам.

if ($_POST['name']  ||  $_POST['address']  ||  $_POST['city_id']  || $_POST['director']  ||  $_POST['phone']  ||  $_POST['email']){
mysql_query("REPLACE INTO test (name,address,city_id,director,phone,email)
VALUES("'.$_POST['name'].'","'.$_POST['address'].'","'.$_POST['city_id'].'","'.$_POST['director'].'","'.$_POST['phone'].'","'.$_POST['email'].'");
}
$select = mysql_query("SELECT * FROM test WHERE id=".intval($_GET['id']))or die(mysql_error());
if (mysql_num_rows($select)) $red = mysql_fetch_array($select);

mysql_close();