Re: Re: HTTP Error 500 - IsapiModule

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



$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)
   if($results = mysql_num_rows($sql_query) != 0)


"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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux