$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
