Update or Add

[v00d00]

Hi,
I have a table, and I need to be able to modify records, and if the record doesn't exist add a new record. What is the easiest way to do this? Can to do..

$sql="SELECT * FROM table WHERE value2='$value2'";
$result=db_query($sql);
if (!$result || db_numrows($result) > 1) {
$sql="UPDATE table SET value1='$value1' WHERE value2='$value2'";
$result=db_query($sql);
return true;
} else {
$sql="INSERT INTO table(value1,value2) ".
"VALUES ('$value1','value2')"; $result=db_query($sql);
return true;
}

This way you enter a value, if it exists it is updated, if not it is added.

I have also been thinking about having a checkbox, so if its checked the record is updated, if not you get an error returned, asking if you want to update, and if so check the box.
Cheers
/voodoo

[bjblackmore]

This is my current code...

function add_date($sUserID,$sRoomcode,$sday,$smonth,$syear,$eday,$emonth,$eyear) {
global $feedback;
//all vars present?
if ($sUserID && $sRoomcode && $sday && $smonth && $syear && $eday && $emonth && $eyear) {
$sql="INSERT INTO availability (user_id,room_code,start_date,end_date) ".
"VALUES ('$sUserID','$sRoomcode','$sday$smonth$syear','$eday$emonth$eyear')";
$result=db_query($sql);
if (!$result) {
$feedback .= ' ERROR - '.db_error();
return false;
} else {
$feedback .= ' Successfully Added Availability. You Will Receive a Confirmation Email Soon ';
return true;
}
} else {
$feedback .= ' ERROR - Must Fill In All Required Fields ';
return false;
}
}
Which just adds a new record, I'd like to be able to search for existing record, and update it, using something like..

$sql="SELECT * FROM availability WHERE user_id='$sUserID' AND room_code='$roomcode' AND start_date='$sday$smonth$syear'";
$result=db_query($sql);
if (!$result || db_numrows($result) > 1) {
$sql2="UPDATE availability SET start_date='$sday$smonth$syear' WHERE user_id='$sUserID'";
$result=db_query($sql2);
if (!$result) {
$feedback .= ' Record Updated ';
return true;

I've tried adding this codes together, but its returing parse errors, and I'm not sure why!
/voodoo

[bjblackmore]

Solved
Cheers
/voodoo