Re: php isn't displaying mysql query correctly

On Fri, Apr 17, 2009 at 11:41 AM, Adam Williams <awilliam@mdah.state.ms.us>wrote: > 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 > > shoulnd't this echo "<option>".$mysqli_get_support_types[types]; be echo "<option>".$mysqli_get_support_types_result[types]; -- Bastien Cat, the other other white meat