Echoing multiple options from a database should work right?

Asked Feb 15 '15 at 02:31

Active Feb 15 '15 at 03:10

Viewed 28 times

I don't think this question falls under that "white page" category, I mean yes that is an end result but I turned off MYSQLI_REPORT since I have been having problems with Indexes

This is what I tried to do, I know that echoing div elements works so why should echoing multiple <option> not work? By not work I mean a white page.

This is what I mean

while ($row = $result->fetch_row()) {

       echo '<option value="'.$row[1].'">'.$row[1].'</option>';
}

I realize that the problem is probably the value="" part.

Problem:

while ($row = $result->fetch_row()) {
        if($row[0]==0){
        echo "<option value="">none found</option>";
        }else {
        $query2 = "SELECT something,something2 FROM somethings where something='$somethingelse' ORDER by Id DESC";
if (($result = $link->query($query2))) {
    /* fetch object array */
    while ($row = $result->fetch_row()) {

       echo '<option value="test">'.
       "$row[1]".
       '</option>';

edited Feb 15 '15 at 03:10

asked Feb 15 '15 at 02:31

pearlescentcrescent

please provice more information – Mr Jerry Feb 15 '15 at 02:41
Have you checked `error_log`? I bet you can see the issue in that file. – MattSizzle Feb 15 '15 at 02:43
For debugging purposes `//` comment the echo line and add `echo print_r($row,1);`. See if `$row` array isn't empty. – DeDee Feb 15 '15 at 02:50
So weird, the problem was when I echoed a blank option when no rows are found eg. $row[0]==0; anyway thank you – pearlescentcrescent Feb 15 '15 at 03:08

Echoing multiple options from a database should work right?

0 Answers0