Mysql(+PHP) Database Insert?
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.
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')");
}
$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')");
}
REPLACE INTO dbname etc
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')");
}
$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')");
}