Can I run a MYSQL query from inside a function when MYSQL_CONNECT was outside?

[physaux]

Ok so, can I run an SQL query inside of a function? For example, look at my code below. Can I do that?

 

 

function dosomething(){
$sqlquery = "SELECT * FROM $table WHERE ip_address = '$ip' LIMIT 1;";
$results = mysql_query($sqlquery);

	$rowoutput = mysql_fetch_assoc($results);
	$chosenurl = $rowoutput['url'];

return $chosenurl;
}

mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName");

//...	

$url = dosomething();

//...

 

I know that for variables, I have to say 'global'. Do I need to do something like that for this mysql query as well?

 

[JAY6390]

Yes you can