Function

[Daney11]

Hey guys,

 

Im trying to write a funtion to grab a members username based on the members ID

 

function member_username($get_username) {

if($get_username == '0') {
return "Not Used";
}

$getmemberQuery = "SELECT * FROM members WHERE member_id = $get_username";
$getmemberresult = mysql_query($getmemberQuery, $connect) or die(mysql_error());
$num_rows = mysql_num_rows($getmemberresult);
if ($num_rows > 0) {
	$member_username = mysql_fetch_array($getmemberresult);
	extract($member_username);
	return "$member_username";
} else {
	return "Error";
	}
}

 

That does nothing at the moment. Anyideas? Thanks

[paul2463]

when and where is $connect passed to the function?????

 

is probably dies inside the function

[Daney11]

i tried this one aswell

 

function member_username($get_username) {

if($get_username == '0') {
return "Not Used";
}

$getmemberQuery = "SELECT * FROM members WHERE member_id = $get_username";
$getmemberresult = mysql_query($getmemberQuery, $connect) or die(mysql_error());

while ($getmemberrow = mysql_fetch_array($getmemberresult))

{ // Start Member While Loop


$member_id = escape_data(htmlentities($getmemberrow['member_id']));
$member_teamid = escape_data(htmlentities($getmemberrow['member_teamid']));
$member_username = escape_data(htmlentities($getmemberrow['member_username']));

}
return "$member_username";
}

[Daney11]

At the top of the page i included settings.php which has my mysql connection inside it, using $connect.

[paul2463]

then use

function member_username($get_username, $connect) 
{
//function body
}

 

and pass it the $connect statement in your function call

[Daney11]

Fixed, thanks, i took $connect out of there.