On 8 Aug 2005, at 16:07, Martin van den Berg wrote:
$query = "SELECT id FROM mytable WHERE bla LIKE " . $x .";
$rows = execute( $query )
if ( $rows == 0 )
{
/* some more processing */
$query = "INSERT INTO mytable ...... etc etc
execute( $query )
}
I have lots of places where I used to do this. Since MySQL 4.1 I've
changed it to something like:
"INSERT INTO mytable SET id = 123, bla = '$x' ON DUPLICATE KEY UPDATE
bla='$x'"
This saves you a query, and makes it easier to isolate the insert/
update as it will play nicely with autocommit.
Marcus
--
Marcus Bointon
Synchromedia Limited: Putting you in the picture
marcus@xxxxxxxxxxxxxxxxxx | http://www.synchromedia.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
