2008/12/19 Gary Maddock-Greene <gmg@xxxxxxxxxxxxxxxxxxxx>:
> $sql_query = mysql_query("SELECT * FROM products WHERE
> MATCH(product_name,product_image) AGAINST('$search_term')");
>
> // This is line 20 where I am getting the parse error
>
> many mathces (too many matches cause returning of 0 results)
That line is not valid code. I'm guessing it's part of a comment that
has mistakenly been broken across 2 lines.
-Stuart
--
http://stut.net/
> "Stuart" <stuttle@xxxxxxxxx> wrote in message
> news:a5f019de0812190516r3cdcdacana356320f39a8d79d@xxxxxxxxxxxxxxxxx
>>
>> 2008/12/19 Gary Maddock-Greene <gmg@xxxxxxxxxxxxxxxxxxxx>:
>>>
>>> Thanks Stuart,
>>>
>>> Logs are no enabled and I generate this line:
>>>
>>> #Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port
>>> cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status
>>> time-taken
>>>
>>> Sorry this is only my 2nd day with php/MySQL and I really need to get
>>> this
>>> working so I appreciate the help.
>>
>> That's the IIS log not the PHP log. See here for details:
>> http://uk.php.net/errorfunc.configuration
>>
>> Look for log_errors and error_log. They work together to give you a
>> PHP error log file.
>>
>> Did you try using php -l on the file?
>>
>> -Stuart
>>
>> --
>> http://stut.net/
>>
>>> "Stut" <stuttle@xxxxxxxxx> wrote in message
>>> news:a5f019de0812190459w486205a4n5fe8fea317890b86@xxxxxxxxxxxxxxxxx
>>>>
>>>> Please include the list when replying.
>>>>
>>>> 2008/12/19 G. Maddock-Greene <gmg@xxxxxxxxxxxxxxxxxxxx>:
>>>>>
>>>>> You may be right Stuart ... I am thinking this too. I can access my
>>>>> database
>>>>> with an auto generated call using say Dreamweaver, but my hand code is
>>>>> throwing the error ... though I cannot see why!! It's really
>>>>> frustrating
>>>>
>>>> Look in your php.ini and make sure log_errors is on and the filename
>>>> it's directed at is writable by IIS. Restart IIS and PHP errors should
>>>> then appear in that file.
>>>>
>>>> Alternatively use the PHP command line executable with the -l (lint)
>>>> argument to check the syntax of a file.
>>>>
>>>> -Stuart
>>>>
>>>> --
>>>> http://stut.net/
>>>>
>>>>> ----- Original Message ----- From: "Stut" <stuttle@xxxxxxxxx>
>>>>> Newsgroups: php.general
>>>>> To: <robleyd@xxxxxxxxxxx>
>>>>> Cc: <php-general@xxxxxxxxxxxxx>
>>>>> Sent: Friday, December 19, 2008 11:58 AM
>>>>> Subject: Re: Re: HTTP Error 500 - IsapiModule
>>>>>
>>>>>
>>>>>> 2008/12/19 David Robley <robleyd@xxxxxxxxxxx>:
>>>>>>>
>>>>>>> Gary Maddock-Greene wrote:
>>>>>>>
>>>>>>>> Hi, Don't know if this is the right group but I am having real
>>>>>>>> problems
>>>>>>>> trying to connect to my MySQL db with php. I am trying to create a
>>>>>>>> search
>>>>>>>> form. I can connect and display in my browser a simple call to a db
>>>>>>>> record
>>>>>>>> but when I try to execute my search script I get a 500 Internal
>>>>>>>> Server
>>>>>>>> error: IsapiModule / ExecuterequestHandler. I'm stumped! Any help
>>>>>>>> please
>>>>>>>> or pointers. Thanks Gary
>>>>>>>
>>>>>>> The first thing when you get a 500 error, which is a server error not
>>>>>>> php,
>>>>>>> is to check the server error log.
>>>>>>
>>>>>> I might be wrong but I think syntax errors can cause a 500 status when
>>>>>> using ISAPI.
>>>>>>
>>>>>> -Stuart
>>>>>>
>>>>>> --
>>>>>> http://stut.net/
>>>>>
>>>>>
>>>
>>>
>>> --
>>> 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
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
