Mysql(+PHP) database Insert?

Answers

1. Bruno

   On 2006-08-19 03:19:04

   
   
   REPLACE INTO dbname etc

2. Michael T

   On 2006-08-19 20:40:58

   
   
   Try something like this: $sql_result = MYSQL($dbName, "SELECT field_id, field_name FROM $dbTable where field_name='$var' LIMIT 1"); $num_rows = mysql_num_rows($sql_result); if ($num_rows == 1) { while ($row = mysql_fetch_array($sql_result)) { $field_id = $row["field_id"]; $sql_modify = MYSQL($dbName, "UPDATE $dbTable SET field_name='$new_var' WHERE field_id='$field_id'"); } } else { $sql_insert = MYSQL($dbName, "INSERT INTO $dbTable ( field_name ) VALUES ('$new_var')"); }