Help with PHP script

[ameer71]

i have the following code... it works well in it's current position...

 

$profile_sql="SELECT * FROM $tbl_12";

$profile_query = mysql_query($profile_sql);

while($rs_profile = mysql_fetch_array($profile_query)){

$profile_ph = $rs_profile["ph"];

$profile_pm = $rs_profile["pm"];

}

 

but if i put it in a function it gives me an error... like this...

 

function get_profile() {

$profile_sql="SELECT * FROM $tbl_12";

$profile_query = mysql_query($profile_sql);

while($rs_profile = mysql_fetch_array($profile_query)){

$profile_ph = $rs_profile["ph"];

$profile_pm = $rs_profile["pm"];

echo $profile_pm;

}

}

 

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in...

[Pikachu2000]

Most likely culprit: Variable Scope