checking for existence and modyfying database entries

[rupertbj]

I have the following code:

<?php
$db = "register";
$link = mysql_connect( "localhost:/users/rupertbj/domains/rupstar.co.uk/sql/mysql.sock", "root" );
if ( !$link ) die( "Couldn't connect to MySQL" );
mysql_select_db( $db, $link ) or die( "Couldn't open $db: ".mysql_error() );		 
$sql = "INSERT INTO userTable VALUES ( '$user', now() )";
mysql_query( $sql, $link );
mysql_close( $link );
}
?>

however - I need to check for the existence of an entry ($user) and if it exists update the datetime; and if it doesn't exist add a new entry.

how do i need to modify my code?

many thanks in advance

[diego25]

It'll look something like this:

$result = mysql_query("SELECT * FROM tbl WHERE user = '$user'";

if (mysql_num_rows($result) != 0) {
mysql_query("UPDATE ...");
} else {
mysql_query("INSERT ...");
}

Diego

[Jayson]

Read the mysql document about the REPLACE command.