Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
mysql_query breaks on remote server
11/07/2012
20:14
Avatar
dancombs
North Brookfield, MA
Member
Members
Forum Posts: 3
Member Since:
23/05/2012
sp_UserOfflineSmall Offline

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.Cry

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
47 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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information