kinlane
8/29/2013 - 6:50 PM

SELECT INSERT

SELECT INSERT

  	$LinkQuery = "SELECT * FROM url WHERE URL = '" . $url . "'";
		//echo $LinkQuery . "<br />";
		$LinkResult = mysql_query($LinkQuery) or die('Query failed: ' . mysql_error());
		
		if($LinkResult && mysql_num_rows($LinkResult))
			{	
			$Link = mysql_fetch_assoc($LinkResult);	
			}
		else 
			{
			$query = "INSERT INTO url(URL,Domain) VALUES('" . mysql_real_escape_string($url) . "','" . mysql_real_escape_string($domain) . "')";
			//echo $query . "<br />";
			mysql_query($query) or die('Query failed: ' . mysql_error());			
			}