I am trying to create a list box of the contents of a field in a MySQL database using the code below:

<td width="70%"><select name="QuizType">
<?php

    $link_id = mysql_connect("localhost","phpuser","phppass");
    $recordset = mysql_query("SELECT * FROM jpquiz.QuizTypes ORDER BY TypeIndex");

    While($query_data = mysql_fetch_row($recordset))
        {
        $QuizType = $query_data["QuizType"];
        echo "<option value=\"";
        echo $QuizType;
        echo "\">";
        echo $QuizType;
        echo "</option>\n";
        }
        echo "</select>\n";

The form displays OK and does not return any errors. The list box has four rows as it should but they are all blank. After messing around with it for a little while it seems that the value is not being assigned correctly to $QuizType.

Can anyone tell me what I am doing wrong?

Thanks in advance,

Glen

Well, you're using mysql_fetch_row() which returns a numerically indexed array, but you're accessing a string index of that result array. You need to use mysql_fetch_array() or mysql_fetch_assoc().

mysql_fetch_array() returns both numeric and string indexes, or you can pass a second param that specifies one or the other.

Read the manual for these functions:
 http://www.php.net/mysql_fetch_row
 http://www.php.net/mysql_fetch_assoc
 http://www.php.net/mysql_fetch_array



Take care,

Nik
http://www.bigaction.org/

That fixed it, Thank you.

Glen