$query="select aa.*,bb.* from aa,bb where aa.userid=bb.userid and bb.xingbie='男'";
$result=mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_array($result))
{
echo $row[username];
}
$result=mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_array($result))
{
echo $row[username];
}
=〉
$query="select bb.* from aa inner join bb on aa.userid=bb.userid where bb.xingbie='男'";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
echo $row[username];
}或者:$query = "select bb.* from aa inner join bb where aa.userid=bb.userid and bb.xingbie='男'";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
echo $row[username];
}