[PHP] php isn't displaying mysql query correctly

[Adam Williams]

I have the code:

$mysqli_get_support_types = "Select types from support_types order by 
types";
$mysqli_get_support_types_result = 
mysqli_query($mysqli,$mysqli_get_support_types) or 
die(mysqli_error($mysqli));

while (mysqli_fetch_array($mysqli_get_support_types_result))
       {
       echo "<option>".$mysqli_get_support_types[types];
       }
echo "</select>

but when I go to the web page source it displays:

<select><option>S<option>S<option>S<option>S<option>S<option>S<option>S<option>S<option>S<option>S</select>

but the query runs correctly in MySQL.  So why is php just printing S's?

mysql> Select types from support_types order by types;
+---------------------+
| types               |
+---------------------+
| Change User         |
| Computer Hardware   |
| Computer Peripheral |
| Computer Software   |
| Delete User         |
| Networking          |
| New Project         |
| New User            |
| Server              |
| Telephone           |
+---------------------+
10 rows in set (0.00 sec)



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php