$lname = $_POST[leaguename];
$day=$_POST[day];
$row1= mysql_fetch_row(mysql_query(“SELECT League_Id FROM leagues WHERE League_Name = ‘$lname’”));
$sql=“SELECT * FROM matches WHERE League_Id= ‘$row1[0]’ AND Day=$day”;
$result=mysql_query($sql);
if (!$result){
echo 'Could not run query: ’ . mysql_error();
}
while ($row=mysql_fetch_row($result)) {
$homeplayers=mysql_query("SELECT Player_Name FROM players as p INNER JOIN teams as t INNER JOIN matches as m WHERE p.Team_Id = '$row[4]' AND t.Team_Id = '$row[4]' AND m.Match_Id = '$row[1]'");
$awayplayers=mysql_query("SELECT Player_Name FROM players as p INNER JOIN teams as t INNER JOIN matches as m WHERE p.Team_Id = '$row[5]' AND t.Team_Id = '$row[5]' AND m.Match_Id = '$row[1]'");
echo "<form name=form method=post>";
.
.
.
//HERE IS THE PROBLEM
for ($h=1; $h<=$row[6]; $h++) { //for example $row[6] = 2
echo $h;
echo “<select name=hscorer” . $h . " value=" . $h . “>”;
while ($row2=mysql_fetch_row($homeplayers)) {
echo “$row2[Player_Name]”;
}
echo “”;
echo “”;
}
/* As you can understand, there will be 2 ($row[6]) drop down lists. Always the first dropdown is shown correctly with the players names, but the following drop down lists are empty. What is wrong??
Thanks in advance.
K.M.
*/