Home » questions » Mysql(+PHP) database Insert?

Mysql(+PHP) database Insert?

2006-08-19 03:15:03, Category: Programming & Design
How can I insert data to my database, ONLY IF there isnt any similar data already in it. And If it exists, then updates it.

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')"); }