|
|
Posted by Marcus Bointon on 10/04/73 11:23
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@synchromedia.co.uk | http://www.synchromedia.co.uk
Navigation:
[Reply to this message]
|