Where is the mistake

[brauchi]

I am running into a problem and I have no idea why I get the following error

Parse error: parse error, unexpected '{' in /home/bparis/public_html/wintertravel.php on line 30

Here is the code that will go to that error message

<?php

$dbh=mysql_connect ("localhost", "", "*") or die ('I cannot connect to the database because: ' .
mysql_error());
mysql_select_db ("bparis_website");

$WinterTravel = mysql_query("select aFeatureTitle from website_bparis.tbl_Features while website_bparis.aFeatureCategory = Winter Travel");
while($WinterTravelArray =mysql_fetch_array($WinterTravel)
{
echo $WinterTravelArray;

}
?>

I made sure that there is information in the database as I added it right into the database without using a web form.

Any help would be appreciated.

Andrea

[cgraz]

Only mistake I notice at first glance is that you're missing a closing parenthesis here:

while($WinterTravelArray =mysql_fetch_array($WinterTravel)

change to

while($WinterTravelArray =mysql_fetch_array($WinterTravel))

Cgraz

[brauchi]

Thank you for finding this mistake. But there must be something else wrong as i am still getting the same error message. here is my corrected code

<?php

$dbh=mysql_connect ("localhost", "", "") or die ('I cannot connect to the database because: ' .
mysql_error());
mysql_select_db ("bparis_website");

$WinterTravel = mysql_query("SELECT aFeatureTitle FROM website_bparis.tbl_Features WHERE website_bparis.aFeatureCategory = Winter Travel");
while($WinterTravelArray = mysql_fetch_array($WinterTravel))
{
echo $WinterTravelArray;

}
?>

Do you have any more ideas what could be wrong here?

Andrea

[cgraz]

It says the error is on line 30, but you don't have 30 lines there. Could you post more code?

Cgraz

[pdlp]

Only thing I can see is an extra period after the single quote. Can't figure out much else.

From

$dbh=mysql_connect ("localhost", "***", "****") or 
die ('I cannot connect to the database because: ' . 

To

$dbh=mysql_connect ("localhost", "***", "****") or 
die ('I cannot connect to the database because: '  

[brauchi]

I took the working part from my code out. so now we only have the two include files plus the code that gives me this error message:

<?php include_once(realpath("templates/top.php")); ?>

<?php

$WinterTravel = @("SELECT aFeatureTitle FROM tbl_Features WHERE bparis_website.aFeatureCatefory = Winter Travel");
while($WinterTravelArray = mysql_fetch_array($WinterTravel))
{
echo "$WinterTravelArray";

}
?>

<?php include_once(realpath("templates/bottom.php")); ?>

[pdlp]

Is the word CateFory a typo or is that the correct spelling?

[brauchi]

this was just a typo when i wrote this to the message boards

[cgraz]

this was just a typo when i wrote this to the message boards

Are you retyping your code or copying and pasting?

Anyways, what's in top.php? I don't see any syntax errors in the code you've posted. My guess is it's in top.php

Cgraz

[brauchi]

The code there is working. it sets my links on the left side of the page and the logo on top and things like that. this code is working as i can see the whole content i want to see.

i just had a thought. I heard one time that certain things can be done when the global settings are turned on. do you think i have the problem when the hosting provider has this turned off?

thank you for your help

andrea

[cgraz]

if the problem was with register globals, you'd most likely get a different error.

The code you have above looks syntatically (if that's a word) correct. Is top.php more than 30 lines? if so, your error is there.

Cgraz

[brauchi]

that code is maybe 50 lines long and that file is linked to another file that is maybe 250 lines long,