Forum



20:14

23/05/2012

I have 3 jqGrids on a php page that are interacting with one another. I am using WAMPServer to provide the apache, php, and mySQL for testing the php on localhost.
In localhost, my php pages work perfectly, all 3 jqGrids are populated. When I put my php files on my website, the jqGrids remain empty. Using Firebug on Firefox, I have narrowed down the problem to here:
$isic = $_GET['isic']; //This is the value being passed to this php page, it works
$result = mysql_query('SELECT COUNT(*) AS count FROM command WHERE ISIC = ' . $isic); // $result remains empty
$row = mysql_fetch_array($result,MYSQL_ASSOC); // $row remains empty
$count = $row['count']; //$count remains empty
My webhost is using PHP 5.2.11 and MySQL 5.0.91. I've set WAMPServer to reflect PHP 5.2.9-2 and MySQL 5.0.88. Like I said earlier, this works for locahost. If I paste the select statement into mysqladmin like:
SELECT COUNT( * ) AS count FROM command WHERE ISIC = '39791';
I get a count of 5 which is as it should be. I'm thinking the problem might be with my isp but am not sure.
Most Users Ever Online: 715
Currently Online:
44 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66