UPDATE if ... else INSERT (mysql)

[Anon]

Hopefully a pretty simple question... but since I´m a total newbie at this I can´t figure it out :9

This is what I want to do:
Check if column X contains a certain number.
If the number exists (the ID for the row) I want to Update the row.
Else, if this number (the row) doesn´t exists I want to create it.

I use INSERT INTO ... and it works the first time, but when I do it a second time it doesn´t work since the row already exists.

I guess the code could look like this:

if (???????) {
mysql_query("UPDATE.....
} else {
mysql_query("INSERT INTO...
}

So, what should the term (????) be...?

How can I solve this little problem?
Is there perhaps a better way to do it...?

//Vasse

[Anon]

Assuming that the variable carrying the value of number is numb.

Number is a field in your table

$q = "Select * from table where Number = $numb";
$r = mysql_query($q);
$row = mxysql_num_rows($r);

// now you can check for the existenceof this number

if($row > 0){ // it exists
try updating, I think the command is easy
}
else {
insert the values;
}

Solomon

[bastien]

result = mysql_query("select rowID from table where...")
$rowID = result["ID"]
if ($rowID)
{
mysql_query("UPDATE.....
} elseif (!$rowID) {
mysql_query("INSERT INTO...
}

hth
Bastien

[Anon]

Thanks!
It works perfectly now! 🙂

//Vasse

[[deleted]]

Not that without transactions, this method is not multi-user safe!