Re: php isn't displaying mysql query correctly
| From: | Shawn McKenzie | Date: | Fri, 17 Apr 2009 16:23:03 +0000 |
| Subject: | Re: php isn't displaying mysql query correctly | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-291642@lists.php.net to get a copy of this message | ||
Adam Williams wrote:
> Shawn McKenzie wrote:
>>
>> No. How about:
>>
>> while ($row = mysqli_fetch_array($mysqli_get_support_types_result))
>> {
>> echo "<option>".$row['types'];
>> }
>>
>>
>
> thanks, now that you provided that, I see that I left out the $row
> variable!
>
And for the explanation, you set $mysqli_get_support_types = "Select
types from support_types order by types";
So when you echoed $mysqli_get_support_types[types], and it wasn't an
array and PHP didn't know what types was, it gave you the
0 index of the string which is S.
--
Thanks!
-Shawn
http://www.spidean.com