Hi All,
there is not-so-used format of SQL format that is
INSERT INTO table SET col1=data1, col2=data2... ON DUPLICATE KEY UPDATE
col1=data1, col2=data2...;
you have to define a primary or unique key in the table and all will
work well. for more info
http://dev.mysql.com/doc/refman/4.1/en/insert-on-duplicate.html
Cheers
/V
Brian Dunning wrote:
I have a table where I want to update each record with today's date as
it's hit, or add the record if it's not in there:
+------+-----------------+------------+
| id | creation_date | last_hit |
+------+-----------------+------------+
I'm trying to do this with a minimum of hits to the db, so rather than
first searching to see if a matching record is in there, I thought I'd
just go ahead and update the matching record, check to see if it failed,
and if it failed then add a new one, like this:
$id = $_GET['id'];
// Update
$query = "update table set last_hit=NOW() where id='$id'";
$result = mysql_query($query);
// Add
if(the update failed) {
$query = "insert into table (id,creation_date,last_hit) values
('$id',NOW(),NOW())";
$result = mysql_query($query);
}
What's the fastest way to check if the update failed?
--PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
