mysql query error.
| From: | Thomas Goeminne | Date: | Sun, 15 Sep 2002 18:07:48 +0000 |
| Subject: | mysql query error. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-116454@lists.php.net to get a copy of this message | ||
<?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