Posted by Aaron Gray on 01/02/08 01:04

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:y_WdnRKnboihf-fanZ2dnUVZ_sPinZ2d@comcast.com...
> Aaron Gray wrote:
>> 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
>>
>>
>>
>>
>
> Try comp.databases.mysql. This is a PHP newsgroup.

The problems I am having seem to be the PHP side of things not the SQL side.

Aaron

[Back to original message]