RE: [PHP] mysql query error.
| From: | John Holmes | 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