Strange Query Issue PHP, Mysql

DoctorWho

Mysql 4.0.24 PHP 4.3.8 Apache 2.0.50

I have a basic Search Form with a drop down box containing State Names, it's an option list thus the state names are abbreviated and abbreviated in the Database.

e.g. Ohio = OH.

Out of all the state abbreviations I have about 10 or so that will not pull the data from the Database when using a PHP form.

So if I choose PA I will get a listing of PA records.

But if I choose OH, I get no results on this particular form.
And about 10 other states also get no results.

But when I use Mysql Front, and run the same query on the Database as found in my PHP page, I get the results. The data is there in the database but the PHP form and associtated PHP Page with the Sql Statement and results refuses to grab this data.

I have other queries on subsequent pages that do grab OH data. For instance I have a section where a Flat Text File can be created and if I choose OH, I get results.

I have test to see if the variable is being passed and it is, and I also have a "YOu serached for the following: State: OH", to ensure the state variable has been passed.

I rebuilt the an INDEX I have for this field.
I have run all the MySql Optimize, Check and Repair Tools.
Yet to no avail.

Has anyone ever experienced anything like this???

lucasrd

Can you echo out your queries...paste one in that works, and one that doesn't.

DoctorWho

fixed

I have another field that is a number field to look up a number.

My select query from the form is filled with a lot of 'like' requests, well the whole statement is 'like' requests.

e.g. select from table where State like '$stateVar%' and firstname like '$firstname%' etc etc.

Well, at the end of my Sql statement I had a Number Search field, all from the same form. But in my SQL statement is was number = '$number'. It was my only '=' request in the whole Sql Statement.

I changed that to "number like '%$number'" and now everything works fine. I had recently added this as of last week. So I should have looked there first.

So here's why.

In the number field above, not every state fills that Number Field In. The only states that were failing were states that send the number field in. Be it '0' (zero), or any other number at all.

Thus '=' statement was throwing the whole thing off.

I hope this may be a benefit to someone out there in the future.
But as I look at it, it's a very simple mistake. And if I posted the code, I am sure some of you would have noticed it right away!!!

So be careful when doing 'like' and '='.