RE: [PHP] mysql query error.

You need to go back to the basics... You started your $enter string with a double quote, but never finished it. How is PHP supposed to know where the string ends? ---John Holmes... > -----Original Message----- > From: Thomas Goeminne [mailto:dabomb_gent@hotmail.com] > Sent: Sunday, September 15, 2002 5:04 PM > To: php-general@lists.php.net > Subject: Re: [PHP] mysql query error. > > I got another problem with the submit scrript off the agenda > > > <?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(); > > if(!IsSet($stage)) > { > ?> > <form method="post" action="<? print("$PHP_SELF"); > ?>"> > <table width="500" border="0"> > <tr> > <td width="82">Title</td> > <td width="408"> > <input type="text" name="title"> > </td> > </tr> > <tr> > <td width="82">Event</td> > <td width="408"> > <textarea name="event"></textarea> > </td> > </tr> > <tr> > <td width="82">date</td> > <td width="408"> > <input type="text" name="date"> > </td> > </tr> > <tr> > <td width="82">Startime</td> > <td width="408"> > <input type="text" name="start"> > </td> > </tr> > <tr> > <td width="82">Location</td> > <td width="408"> > <input type="text" name="location"> > </td> > </tr> > <tr> > <td width="82">Entrance</td> > <td width="408"> > <input type="text" name="entrance" value="0.00"> > euro </td> > </tr> > <tr> > <td width="82">homepage</td> > <td width="408"> > <input type="text" name="homepage" > value="http://"> > </td> > </tr> > <tr> > <td width="82">sitename</td> > <td width="408"> > <input type="text" name="site"> > </td> > </tr> > <tr> > <td width="82">email</td> > <td width="408"> > <input type="text" name="email"> > </td> > </tr> > <tr> > <td width="82">Free Tickets</td> > <td width="408"> > <input type="text" name="tickets"> > (number from 1 till ...)</td> > </tr> > </table> > <br> > <INPUT TYPE=HIDDEN NAME="stage" VALUE=1> > <INPUT TYPE=SUBMIT> > </form> > <? > } > else > { > $enter = "INSERT INTO nuke_party (title, event, date, start, location, > entrance, homepage, site, email, tickets) VALUES ('$title', '$event', > '$date', '$start', '$location', '$entrance', > '$homepage', '$site', > '$email', > '$tickets'); > $tester = mysql_query($enter); > if($tester == 0) > echo "There has been a problem"; > else > echo "Your information has been recorded"; > } > > CloseTable(); > > include("footer.php"); > ?> > > I get an error on line 96 which is: echo "There has been a problem"; > > I don't know why this goes wrong > > "John Holmes" <holmes072000@charter.net> schreef in bericht > news:000701c25ce8$69e33060$b402a8c0@mango... > > You are missing a closing brace. The syntax of a while is: > > > > While( [condition] ) > > { > > [do something] > > } > > > > You are missing the closing brace, the }, that tells the while loop > > where to end. > > > > It depends on your code where you put it. What do you want executed > > within the while() loop? > > > > ---John Holmes... > > > > > -----Original Message----- > > > From: Thomas Goeminne [mailto:dabomb_gent@hotmail.com] > > > Sent: Sunday, September 15, 2002 2:33 PM > > > To: php-general@lists.php.net > > > Subject: Re: [PHP] mysql query error. > > > > > > 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���Y�q > > > > > �]���2��� > > > > > > > > > > > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php