Re: mysql query error.
| From: | Thomas Goeminne | Date: | Sun, 15 Sep 2002 18:33:18 +0000 |
| Subject: | Re: mysql query error. | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-116459@lists.php.net to get a copy of this message | ||
And how do I close it then? I tried some things but it doesnt work.
"John Holmes" <holmes072000@charter.net> schreef in bericht
news:000501c25ce5$be1a5c60$b402a8c0@mango...
> An error on the last line of your file almost always means you are
> missing a closing brace. You are not closing your while() loop.
>
> ---John Holmes...
>
> > -----Original Message-----
> > From: Thomas Goeminne [mailto:dabomb_gent@hotmail.com]
> > Sent: Sunday, September 15, 2002 2:08 PM
> > To: php-general@lists.php.net
> > Subject: [PHP] mysql query error.
> >
> > <?php
> >
> > // Party module for PHP-NUKE 5.6
> > // Written by Thomas Goeminne, webmaster@hiphopstore.be
> > // Copyright (c) 2002, Thomas Goeminne
> > // Released under the GNU General Public License,
> > // www.gnu.org
> >
> >
> > // Set this to 0 if you want the right hand blocks to appear on-screen
> > // while this module is showing
> >
> > $index = 0;
> >
> > include("header.php");
> >
> > OpenTable();
> >
> > echo "<b><u>Party Agenda<u></b>";
> > echo "<BR>";
> >
> > $query = "SELECT * FROM nuke_party ORDER BY date, title";
> > $result_id = mysql_query($query);
> > ?>
> > <table>
> >
> > <?
> > while ($a=mysql_fetch_object($result_id)){
> > ?>
> > <table>
> > <tr><td>date</td>
> > <td> <? print "$a =>date"
> > ?></td></tr>
> > <tr><td>title</td>
> > <td> <? print "$a =>title"
> > ?></td></tr>
> > <tr><td>event</td>
> > <td> <? print "$a =>event"
> > ?></td></tr>
> > <tr><td>start</td>
> > <td> <? print "$a =>start"
> > ?></td></tr>
> > <tr><td>location</td>
> > <td> <? print "$a =>location"
> > ?></td></tr>
> > <tr><td>entrance</td>
> > <td> <? print "$a =>entrance"
> > ?></td></tr>
> > <tr><td>homepage</td>
> > <td> <a href="<? print "$a =>homepage"
> > ?>"
> > target="_blank"><? print "$a => site"
> > ?></a></td></tr>
> >
> > </table>
> >
> > <?
> > CloseTable();
> >
> > include("footer.php");
> > ?>
> >
> >
> > I get an error message that there is an erro on the last line off
> code.
> > Any
> > helpfull tips?
> >
> > Basicly what i want is to display the party information in a table.
> > --
> > Thomas Goeminne
> > Executive NV
> > Kortrijksepoortstraat 7
> > 9000 Gent Belgium
> > Tel/fax: + 32 9 223 0393
> > BTW: BE 455.676.207
> > URL: http://clik.to/bomb
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
>