Help!

Vinny_Wolf

I have a MYSQL database that I populated with some questions and answers. Kinda' a amatuer knowledge base. Anyhew, I created some php scripts to search the database for keywords inside the fields on the database. It was working fine last week, ONLY displaying fields where there was a match of the keyword.

Well, this morining, I ran upgraded from SuSe 7.3 Pro to SuSe 8.2 Pro. For some reason, I had to reinstall phpMyAdmin ( I think I downloaded ver 2.5.0 ?). Anyway, since the upgrade, my php scripts don't work. When I do a search of the database, it retrieves the ENTIRE DATABASE instead of only where it found a match of the search string ?????
When I was writing the php, I originally had something on the order of
"SELECT where <field> ='searchstring' in the script to search, but this would only return a result if the search string was the only word in the field. I then modified it using a wild card and the LIKE function
"SELECT WHERE <field> LIKE '%searchstring%'"

Why would upgrading the OS change anything having to do with my php not functioning correctly ???

Any help would be greatly appreciated.

Thanks,

Vinny

zmola

Hi. If you change the query back to "SELECT * where <field> ='searchstring'" does it still return the entire content?

Vinny_Wolf

yes, I changed back to my original code (SELECT * WHERE <field>='searchstring') and it pulls the entire database. Even if the search field is null and I click on the search button (Form Action="Retrieve.php METHOD=post) it returns the whole database where before if the search was done with an empty searchstring, it would return an empty table with just the table headers, which is what it SHOULD do. I am very confused as to why this would function differently since there was no change to the code. The only variable that changed since last Friday is the upgrade to SuSE 8.2. Is there a different version of php which overwrote my older version and caused my code not to work?

EXTREMELY confused....

Vinny

Vinny_Wolf

I'm wondering if my problem is related to the version of PHP? What version is included on SuSE 8.2? I'm assuming it is 4.0 or higher. I've been reading about issues with passing variables in the newer versions of php. This sounds like what I am experiencing. If I am unable to pass my search variable to my php script, then wouldn't it return the entire db? Just a thought. I am out of ideas here.
Also, is there some type of php config file where global variables are turned on or off? If so what is the name and where do I look for it?

Thanks Again,

Vince