Select statements not working

227adriani

Hi. I had to move my php code from an apache run server to a Windows 2003 server with IIS and I've run into a problem with one of my select statements. It isn't returning a value. See code below.

$NotWorking = "SELECT MIN(ZIPCode) FROM zips where CityName like '".$city."' and StateCode='".$state."' limit 1";

$Working = "SELECT MIN(ZIPCode) FROM zips where CityName like 'ALBERTVILLE' and StateCode='AL' limit 1";

When I do an echo statement on $NotWorking I get the exact same select statement as $working but my result value is blank whereas the $Working select statement gives me the correct zip code.

Any Ideas?

chads2k2

I have an idea.

What about register globals on? You might have had them on in your php.ini file on the Apache machine but not on in Windows 2003. That will then make the .$city and .$state kinda not working. I would read through the config files between the machines carefully. And see if there is anything different. Your SQL statements look fine. It usually comes down to the actual config of the W2k3 box. I had that problem many months ago now, but as so we work in an Intranet enviroment so having register globals on isn't a big issue.

Lata,

Chad

robert_w_ark


$NotWorking = "SELECT MIN(ZIPCode) FROM zips WHERE CityName LIKE ".$city." AND StateCode = ".$state." LIMIT 1";

chads2k2

OH damn!

I missed that. I read over it too quickly. Good work man. Glad there are other eyes who read this. Good job!

Chad

Weedpacket

Originally posted by chads2k2
I missed that.

Missed what? All it is is the original with quotes taken off of the string field values. Which is a mistake.

$NotWorking = "SELECT MIN(ZIPCode) FROM zips where CityName like '".$city."' and StateCode='".$state."' limit 1";

I'd still go with the register_globals idea.