Posted by Jerry Stuckle on 01/02/08 00:59

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.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]