query problem, pls. help

[icd_lx]

The results of 2 queries in a FOR loop don't return, and I know what the queries select DO exist. I am talking about both the queries in this FOR loop. What is wrong with them?

 for($count=$first; $count<=$last; $count++)
{	
	echo "<TR>";
	$sql=mysql_query("SELECT * FROM users WHERE username='$post[$count][user]'", $connect);
	$user=mysql_fetch_array($sql);
	$sql2=mysql_query("SELECT number FROM posts WHERE user='$post[$count][user]'", $connect);
	$totalposts=mysql_num_rows($sql2);
	echo "<TD WIDTH='30%'>".$post[$count][user]."<BR>".$user[status]."<BR>".$totalposts."<BR>".dconvert($post[$count][date]);
	echo "</TD><TD WIDTH='70%'>".$post[$count][post]."</TD></TR><BR>";
	if($count == $last)
	{
		echo "</TABLE>";
	}
}

[brandonschnell]

whats the result of the array $post[$count][user]? unless user has been already been defined the array index is invalid. maybe you want:

$post[$count][$user]

but mysql_fetch_array($sql) already returns variable $user.