[RESOLVED] FULLTEXT search on varchar data type

[Pikachu2000]

I have a MySQL db set up locally that I've been testing with, and a somewhat complex search query I use runs fine, and produces the expected results.

I uploaded everything to a live hosting server, and the query produces different results. The db and tables were created from a dump of my local db. I've printed the table structures and compared them line-by-line; they're identical. I've checked the output of phpinfo() on both servers, and they're identical.

The only differences I find anywhere are locally I have mySQL version 5.0.41 and PHP 5.2.5, and the hosting company is using mySQL 5.0.45 and PHP 5.2.8.

I don't know why the query would work fine locally, but not on the hosted site, and i don't know what else to check . . .

[Pikachu2000]

UPDATE: I just upgraded PHP locally to 5.2.11 and it now exhibits the same undesired behavior locally, so it's obviously a coding problem. Anyone know where can I find a list of what, if anything, was deprecated between 5.2.5 and 5.2.8? I looked through the change logs, but don't find anything useful there.

The queries all return the expected results when pasted into phpMyAdmin, so I'm really baffled. If anyone wants to see the code, I can paste it in, but it's rather long.

[Pikachu2000]

I got this issue figured out. I was searching against the wrong field in the table. It should never have worked at all, but it did until I upgraded PHP. Go figure.