mySQL Searches

[Alan <Alan@PerfGauge.com>]

I'm having a great deal of difficulty isolating a problem I'm having when
trying to run searches with a mySQL database. The result is different
depending on what I search for. Examples follow:



single word search. Example: "wash" (short for washington)
Result: HTTP 500 error

two word search. Example: "2c Wash"
Result: search works properly

one word search with a space after it. Example "wash "
Result: search works properly

one word serarch with a space before it. Example: " wash"
Result: HTTP 500 error


You can see for yourself at:
http://www.perfgauge.com/cgi-bin/us/srchform
NOTE: Site is under construction. Prices may not be accurate yet.



One more funny thing; This worked perfectly all the time on my home
computer, but when I put it on our web server, All the sudden it got wierd.
operating environments follow:

Home Computer:
	Red Hat 6.0
	Minivend 3.14
	MySQL 3.21
	perl 5.005_03-2

Web server:
	bsdi 3.1
	Minivend 3.14
	MySQL 3.22.20a
	perl 5.004_04


I have searched through the archive and through the manual with no luck. I
would greatly appreaciate any help I could get with this.

Thanks,

Alan