Cita:
Iniciado por pateketrueke 
mmm....
Código PHP:
$foo = mysql_query('SELECT * FROM bar WHERE candy=9');
if (mysql_num_rows($foo) > 0)
{
// ya existe el registro...
}
else
{
// NO existe!!
}
Thanks.
Código PHP:
$query = mysql_query("SELECT * FROM `$it` WHERE `file_name` = '$path_base_name' AND `directory` = '$dir_http'");
$result = mysql_fetch_assoc($query);
$num = mysql_num_rows($query);
if($num) // if the record exist, update it
{
mysql_query("UPDATE `$it` SET `file_name` = '$path_base_name', `directory` = '$dir_http' WHERE `id` = '" . $result['id'] . "'");
}
else // else insert new record
{ // else began
mysql_query("INSERT INTO `$it` (file_name, directory) VALUES ('$path_base_name','$dir_http')");
} // else end