Re: can't output sql query with php code.
| From: | Paul Goepfert | Date: | Mon, 06 Feb 2006 08:18:57 +0000 |
| Subject: | Re: can't output sql query with php code. | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-229929@lists.php.net to get a copy of this message | ||
Thanks everyone for your help. I should have seen the semi-colon at
the end of the while loop. I must have looked at the code 20 times
and I can't believe I missed it.
Paul
On 2/6/06, Brady Mitchell <bradym@ext.usu.edu> wrote:
> > <?php
> > echo '<select name="month" >\n';
> > $month_query = mysql_query("SELECT m_id, months FROM Month");
> > while ($r = mysql_fetch_array($month_query));
>
>
> Remove the semi-colon at the end of the above line and it works like a charm.
>
> > {
> > $v = $r["m_id"];
> > $out = $r["months"];
> > echo "<option value=$v>$out</option>\n";
> > }
> > echo '</select>\n';
> > ?>
>
>