[RESOLVED] Populating Drop Down

[Static_Cling]

I'm trying to use the following code to populate 2 drop down boxes on my page...first dropdown box populates no problem, however I am not getting any data in the second, and I don't see why...what am I doing wrong? thanks

<?php
include("db_connect.php");
session_start();
session_register();
if (isset($_SESSION["uid"]))

$query = mysql_query("SELECT * FROM users where companyid = '$company'");

echo "<form action=\"assigncourse.php\" method=\"POST\"><select name=\"users\">
<option value=\"\" \"selected\">Select a User</option>";

while ($row = mysql_fetch_array($query))

{

echo "<option value=\"{$row['userid']}\">{$row['name']}</option>";

}
echo "</select>";

$query2 = mysql_query("SELECT * FROM Courses");

echo "<select name=\"courses\">
<option value=\"\" \"selected\">Select a Course</option>";

while ($row2 = mysql_fetch_array($query2))

{

echo "<option value=\"{$row2['courseid']}\">{$row['coursename']}</option>";

}
echo "</select>";

echo "<input type=\"submit\" value=\"Assign Course\"></form>";
?>

[superwormy]

Are you sure your query is executing successfully and returning some rows?

It looks like you have some extra qoutes here too: <option value=\"\" \"selected\">Select a Course</option>";

Did you look at the HTML source, is nothign being shown in the HTML source as well?

[Static_Cling]

yes, within the first section, ie:

$query = mysql_query("SELECT * FROM users where companyid = '$company'");

echo "<form action=\"assigncourse.php\" method=\"POST\"><select name=\"users\">
<option value= \"selected\">Select a User</option>";

while ($row = mysql_fetch_array($query))

{

echo "<option value=\"{$row['userid']}\">{$row['name']}</option>";

}
echo "</select>";

However, for the next section, which needs to pull from a different table, nothing is being returned:

$query2 = mysql_query("SELECT * FROM Courses");

echo "<select name=\"courses\">
<option value=\"selected\">Select a Course</option>";

while ($row2 = mysql_fetch_array($query2))

{

echo "<option value=\"{$row2['courseid']}\">{$row['coursename']}</option>";

}
echo "</select>";

[superwormy]

YOu should try mysql_query("your query here") or die(mysql_error()); and make sure MySQL isn't choking on your query.

Ah, also, you know you're using $row['coursename'] instead of $row2['coursename'] in the last while() loop right?

[Static_Cling]

that was it, row2 was missing thanks, glad to have the extra pair of eyes...