Posted by Aaron Gray on 01/02/08 00:50

I have a MySQL table of pages each with a 'title' and 'page' fields.

How do I do either an UPDATE if the pages 'title' exists or an INSERT if it
does not ?

The code I have written does not seem to do the job correctly.

$result = mysql_query( "SELECT page FROM pages WHERE title = '" . $title
.. "';");

$row = mysql_fetch_array( $result, MYSQL_ASSOC);

if ( isset( $row["title"]) && $row[title] == $title)
{
$result = mysql_query( "UPDATE pages SET page = '". $page . "' WHERE
title = '" .$title . "';");
if ($result)
mysql_query( "COMMIT;");
}
else
{
$result = mysql_query( "INSERT INTO pages SET title ='" . $title .
"', page = '" . $page . "';");
if ($result)
mysql_query( "COMMIT;");
};

This code is buggy and doing an insert rather than an update. How would you
approach this task ?

Many thanks in advance,

Aaron

[Back to original message]