RE: [PHP-DB] Browser-Trouble with Query

2003-09-03 Thread Peter Lovatt
Hi

Can we see the code + a few lines either side?

Peter

-Original Message-
From: Sebastian Haag [mailto:[EMAIL PROTECTED]
Sent: 03 September 2003 21:12
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Browser-Trouble with Query


Hi everyone,

I have trouble with a PHP-script querying a MySQL-database. Actually my
Opera-Browser has trouble (version 7.11 on a Win2000 machine). It outputs
a parse error when i enter that page.

  Parse error: parse error in /var/www/mypage.php on line 156

After checking all parenthesis over and over, I decided to enter that page
with the InternetExplorer (version 5.50). And it worked.

What gives me a headache is that I tried commenting out that specific part
of the script. Still parse error on the same line. I inserted a bunch of
empty lines around line # 156 and I still got the same error at the same
line.

I don't have any more ideas. I hope you may have a hint.

Thank you very much. I appreciate your help!

Greetings, Sebastian

P.S. PHP version 4.1.2


-- 

Once a problem is defined - it is half way solved. (Henry Ford)

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] Browser-Trouble with Query

2003-09-03 Thread Hutchins, Richard
Two things:

First, a copy of your code would help, with line 156 clearly identified.

Second, usually there's more information with the parse error. Something
like "expected ',' or ';'" that will give you more of a hint. Although, I'm
not sure if the PHP.INI file has a setting for displaying that information.

At the very least, the code though.
> -Original Message-
> From: Sebastian Haag [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 03, 2003 4:12 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Browser-Trouble with Query
> 
> 
> Hi everyone,
> 
> I have trouble with a PHP-script querying a MySQL-database. 
> Actually my
> Opera-Browser has trouble (version 7.11 on a Win2000 
> machine). It outputs
> a parse error when i enter that page.
> 
>   Parse error: parse error in /var/www/mypage.php on line 156
> 
> After checking all parenthesis over and over, I decided to 
> enter that page
> with the InternetExplorer (version 5.50). And it worked.
> 
> What gives me a headache is that I tried commenting out that 
> specific part
> of the script. Still parse error on the same line. I inserted 
> a bunch of
> empty lines around line # 156 and I still got the same error 
> at the same
> line.
> 
> I don't have any more ideas. I hope you may have a hint.
> 
> Thank you very much. I appreciate your help!
> 
> Greetings, Sebastian
> 
> P.S. PHP version 4.1.2
> 
> 
> -- 
> 
> Once a problem is defined - it is half way solved. (Henry Ford)
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] Browser-Trouble with Query

2003-09-03 Thread Sebastian Haag
Hi guys,

Hutchins, Richard said:
> Two things:
>
> First, a copy of your code would help, with line 156 clearly identified.
>

Sure,

[...more code goes here...]

$query .= $and;

$result = @mysql_query($query)
or die("Game ID: " . mysql_error());
$i = 0;
while($row = @mysql_fetch_row($result))
{
$game_id[$i] = $row[0];
$i++;
}

if($game_id && $def_id)
#156--> {
if($choice == 1)
 frontsDnDst($script, $game_id, $def_id);  /*user defined 
functions
are included in an include file at the beginning of the script*/
elseif($choice == 2)
 coversDnDst($script, $game_id, $def_id);
elseif($choice == 3)
 frontCoverDnDst($script, $game_id, $def_id);
}
else
{
 echo "Sorry, no matching results found.";
 echo "[Zurück]";
 exit;
}

[more code goes here...]


> Second, usually there's more information with the parse error. Something
> like "expected ',' or ';'" that will give you more of a hint. Although,
> I'm

That's all there is. And I have had the ones you are talking about. But
not this time.

> not sure if the PHP.INI file has a setting for displaying that
> information.
>
> At the very least, the code though.
>> -Original Message-
>> From: Sebastian Haag [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, September 03, 2003 4:12 PM
>> To: [EMAIL PROTECTED]
>> Subject: [PHP-DB] Browser-Trouble with Query
>>
>>
>> Hi everyone,
>>
>> I have trouble with a PHP-script querying a MySQL-database.
>> Actually my
>> Opera-Browser has trouble (version 7.11 on a Win2000
>> machine). It outputs
>> a parse error when i enter that page.
>>
>>   Parse error: parse error in /var/www/mypage.php on line 156
>>
>> After checking all parenthesis over and over, I decided to
>> enter that page
>> with the InternetExplorer (version 5.50). And it worked.
>>
>> What gives me a headache is that I tried commenting out that
>> specific part
>> of the script. Still parse error on the same line. I inserted
>> a bunch of
>> empty lines around line # 156 and I still got the same error
>> at the same
>> line.
>>
>> I don't have any more ideas. I hope you may have a hint.
>>
>> Thank you very much. I appreciate your help!
>>
>> Greetings, Sebastian
>>
>> P.S. PHP version 4.1.2
>>
>>
>> --
>>
>> Once a problem is defined - it is half way solved. (Henry Ford)
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 

Once a problem is defined - it is half way solved. (Henry Ford)

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] Browser-Trouble with Query

2003-09-03 Thread Sebastian Haag
Hi,

the problem is solved ... but the solution is searched.

I renamed the file to mypage2.php and the script works fine. Puzzles me
quite a bit. So, if anyone has an idea... I'm thankful for any comments.

Thanks to you guys who replied.

Sebastian Haag said:
> Hi guys,
>
> Hutchins, Richard said:
>> Two things:
>>
>> First, a copy of your code would help, with line 156 clearly identified.
>>
>
> Sure,
>
> [...more code goes here...]
>
> $query .= $and;
>
>   $result = @mysql_query($query)
>   or die("Game ID: " . mysql_error());
>   $i = 0;
>   while($row = @mysql_fetch_row($result))
>   {
>   $game_id[$i] = $row[0];
>   $i++;
>   }
>
>   if($game_id && $def_id)
> #156-->   {
>   if($choice == 1)
>frontsDnDst($script, $game_id, $def_id);  /*user defined 
> functions
> are included in an include file at the beginning of the script*/
>   elseif($choice == 2)
>coversDnDst($script, $game_id, $def_id);
>   elseif($choice == 3)
>frontCoverDnDst($script, $game_id, $def_id);
>   }
>   else
>   {
>echo "Sorry, no matching results found.";
>echo "[Zurück]";
>exit;
> }
>
> [more code goes here...]
>
>
>> Second, usually there's more information with the parse error. Something
>> like "expected ',' or ';'" that will give you more of a hint. Although,
>> I'm
>
> That's all there is. And I have had the ones you are talking about. But
> not this time.
>
>> not sure if the PHP.INI file has a setting for displaying that
>> information.
>>
>> At the very least, the code though.
>>> -Original Message-
>>> From: Sebastian Haag [mailto:[EMAIL PROTECTED]
>>> Sent: Wednesday, September 03, 2003 4:12 PM
>>> To: [EMAIL PROTECTED]
>>> Subject: [PHP-DB] Browser-Trouble with Query
>>>
>>>
>>> Hi everyone,
>>>
>>> I have trouble with a PHP-script querying a MySQL-database.
>>> Actually my
>>> Opera-Browser has trouble (version 7.11 on a Win2000
>>> machine). It outputs
>>> a parse error when i enter that page.
>>>
>>>   Parse error: parse error in /var/www/mypage.php on line 156
>>>
>>> After checking all parenthesis over and over, I decided to
>>> enter that page
>>> with the InternetExplorer (version 5.50). And it worked.
>>>
>>> What gives me a headache is that I tried commenting out that
>>> specific part
>>> of the script. Still parse error on the same line. I inserted
>>> a bunch of
>>> empty lines around line # 156 and I still got the same error
>>> at the same
>>> line.
>>>
>>> I don't have any more ideas. I hope you may have a hint.
>>>
>>> Thank you very much. I appreciate your help!
>>>
>>> Greetings, Sebastian
>>>
>>> P.S. PHP version 4.1.2
>>>
>>>
>>> --
>>>
>>> Once a problem is defined - it is half way solved. (Henry Ford)
>>>
>>> --
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
>
> --
>
> Once a problem is defined - it is half way solved. (Henry Ford)
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 

Once a problem is defined - it is half way solved. (Henry Ford)

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] Browser-Trouble with Query

2003-09-03 Thread Jim Hunter
Sounds like you had a cache problem going on. I wanted to suggest that but
got tied up on something else. Whenever you see the same results, even
though you are changing the code, try and delete the cache files in the
browser, exit the browser, then come back in and try it again. Usually this
clears the problem. 

Jim
 
---Original Message---
 
From: [EMAIL PROTECTED]
Date: Wednesday, September 03, 2003 03:10:06 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Browser-Trouble with Query
 
Hi,

the problem is solved ... but the solution is searched.

I renamed the file to mypage2.php and the script works fine. Puzzles me
quite a bit. So, if anyone has an idea... I'm thankful for any comments.

Thanks to you guys who replied.

Sebastian Haag said:
> Hi guys,
>
> Hutchins, Richard said:
>> Two things:
>>
>> First, a copy of your code would help, with line 156 clearly identified.
>>
>
> Sure,
>
> [...more code goes here...]
>
> $query .= $and;
>
> $result = @mysql_query($query)
> or die("Game ID: " . mysql_error());
> $i = 0;
> while($row = @mysql_fetch_row($result))
> {
> $game_id[$i] = $row[0];
> $i++;
> }
>
> if($game_id && $def_id)
> #156--> {
> if($choice == 1)
> frontsDnDst($script, $game_id, $def_id); /*user defined functions
> are included in an include file at the beginning of the script*/
> elseif($choice == 2)
> coversDnDst($script, $game_id, $def_id);
> elseif($choice == 3)
> frontCoverDnDst($script, $game_id, $def_id);
> }
> else
> {
> echo "Sorry, no matching results found.";
> echo "[Zurück]";
> exit;
> }
>
> [more code goes here...]
>
>
>> Second, usually there's more information with the parse error. Something
>> like "expected ',' or ';'" that will give you more of a hint. Although,
>> I'm
>
> That's all there is. And I have had the ones you are talking about. But
> not this time.
>
>> not sure if the PHP.INI file has a setting for displaying that
>> information.
>>
>> At the very least, the code though.
>>> -Original Message-
>>> From: Sebastian Haag [mailto:[EMAIL PROTECTED]
>>> Sent: Wednesday, September 03, 2003 4:12 PM
>>> To: [EMAIL PROTECTED]
>>> Subject: [PHP-DB] Browser-Trouble with Query
>>>
>>>
>>> Hi everyone,
>>>
>>> I have trouble with a PHP-script querying a MySQL-database.
>>> Actually my
>>> Opera-Browser has trouble (version 7.11 on a Win2000
>>> machine). It outputs
>>> a parse error when i enter that page.
>>>
>>> Parse error: parse error in /var/www/mypage.php on line 156
>>>
>>> After checking all parenthesis over and over, I decided to
>>> enter that page
>>> with the InternetExplorer (version 5.50). And it worked.
>>>
>>> What gives me a headache is that I tried commenting out that
>>> specific part
>>> of the script. Still parse error on the same line. I inserted
>>> a bunch of
>>> empty lines around line # 156 and I still got the same error
>>> at the same
>>> line.
>>>
>>> I don't have any more ideas. I hope you may have a hint.
>>>
>>> Thank you very much. I appreciate your help!
>>>
>>> Greetings, Sebastian
>>>
>>> P.S. PHP version 4.1.2
>>>
>>>
>>> --
>>>
>>> Once a problem is defined - it is half way solved. (Henry Ford)
>>>
>>> --
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
>
> --
>
> Once a problem is defined - it is half way solved. (Henry Ford)
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 

Once a problem is defined - it is half way solved. (Henry Ford)

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

.