Code: Select all
function get_name($url, $name)
{
db_connect();
$query = sprintf( "SELECT
list.id,
list.url,
list.name
FROM
list
WHERE
list.url = '%s' ",
mysql_real_escape_string($url)
);
$result = mysql_query($query);
if (!mysql_fetch_array($result))
{
$new_query = "INSERT INTO list (url, name) VALUES
('$url', $name)
";
mysql_query($new_query);
return 0;
}
else
{
$row = mysql_fetch_array($result);
$var = $row['url'];
return $var;
}
}