Re: mysql query error.

OK i found how to close the while loop. Obviously I am newbie. I got this while loop as a lesson from a friend off mine. I think he gave me a wrong script cuz all this puts in the browser is: Party Agenda date Object=>date title Object=>title event Object=>event start Object=>start location Object=>location entrance Object=>entrance homepage Object =>site where did it go wrong? "Thomas Goeminne" <dabomb_gent@hotmail.com> schreef in bericht news:20020915183522.70047.qmail@pb1.pair.com... > 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 > > > >