RE: [PHP] mysql query error.

From: Date: Sun, 15 Sep 2002 18:28:52 +0000
Subject: RE: [PHP] mysql query error.
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-116455@lists.php.net to get a copy of this message
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

« previous php.general (#116455) next »