0

Basically, Im trying to get a list of groups that a member is part of in an array (excluding a few), and limiting it to certain status in that group. I want all the values returned from the query to go into an array. The problem is, when I do...

$row = $ClubGDC(54);
echo $row[0];

...for example, it returns blank, and when printf-ing it, it is completely empty. So even though the SQL command DOES return values in a database query, this array is empty.

I have no idea if this is even the proper way to do what im trying to do. If someone could please help, it would be much appreciated. The full function is below:

function ClubGDC($userid)
{
	$gdcarray = array();
	$query = "SELECT * FROM members WHERE access < 300 AND status='Active'";
	$query .= "AND group!= 1 AND group!= 234 AND group!= 99999999999 AND group!= 199 AND group!= 228 ";
	$query .= "AND id = $userid";
	$q = mysql_query($query);
	$i2 = 0;
	while($row = mysql_fetch_array($q))
	{
		$gdcarray[0] = $row["group"];
		$i2++;
	}
	return $gdcarray;
	
}
2
Contributors
6
Replies
7
Views
6 Years
Discussion Span
Last Post by vibhaJ
0
while($row = mysql_fetch_array($q))
	{
		$gdcarray[] = $row["group"];
		$i2++;
	}

Try to replace while loop with above code.

0

The array is still empty. Maybe there is something wrong with my display code?

$gdcarray1 = ClubGDC(54);
print_r($gdcarray1);
0

Lets debug code.

<?
	function ClubGDC($userid)
	{
		$gdcarray = array();
		$query = "SELECT * FROM members WHERE access < 300 AND status='Active'";
		$query .= "AND group!= 1 AND group!= 234 AND group!= 99999999999 AND group!= 199 AND group!= 228 ";
		$query .= "AND id = $userid";
		$q = mysql_query($query);	
		echo '<br />Query:'.	$query;
		while($row = mysql_fetch_array($q))
		{
			$gdcarray[] = $row["group"];	
			echo '<br />group:'.$row["group"];		
		}
		return $gdcarray;		
	}
	
	$gdcarray1 = ClubGDC(54);
	//print_r($gdcarray1);
?>

Check this code and test if $query is returning proper output.
post your printed output.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.