Errors in Uploading Website to a Webserver

[Bobsmall]

Hi,
PHP, MySQL, (using the adodb wrapper for multiple database compatibility)

I did a job recruitment Website which is running fine on the localhost but when i uploaded it to a webserver i am getting errors in executing functions on sql statements.

The error is occurring when a FetchRow is done i.e. pulling the value in the column after an sql is executed.

Does anyone have any thoughts?


Thanks...

 

[Foamcow]

What is the error?
It would be helpful to know

<honk>*:O)</honk>

Tyres: Mine's a pint of the black stuff.
Mike: You can't drink a pint of Bovril.

 

[Bobsmall]

ooops....

sorry about that,

Fatal error: Call to a member function on a non-object in /home/

http://www/jobsmart.awardspace.com/jseekappliedexp.php

on line 51


the function was adodb FetchRow

 

[jpadie]

your adodb object (i.e. the statement) was not correctly formed. likely as not, you're not doing proper error handling on the various function or method calls.

 

[Bobsmall]

But its running fine off the localhost... any idea why its generating errors on a webserver?

 

[jpadie]

is adodb installed on the webserver? is the user name and password for the mysql connection the same on the server?

 

[Bobsmall]

The adodb directories are copied on the server and i am using the correct username and password in the connection php file because i am able to login as a user.

Upon trouble shooting I have determined that the there was a problem with the FetchRow...

However, i also noticed that where i use a foreach loop to echo data from the result of quering a table it results in echoing '&' sign and single characters with only one instance a record being displayed from the database even though there are multiple records...

eg.

$sqlwk = $conn->Execute("SELECT F_NAME, EMPLOYER, POSITION, FROM_MONTH, FROM_YR, TO_MONTH, TO_YR, GEN_INFO, JOB_ID FROM `jobseeker`, `work_experience` WHERE jobseeker.USER_ID = work_experience.USER_ID AND work_experience.USER_ID = \"".$usr_id."\"");


foreach ($sqlwk as $value=>$row){

echo $row['EMPLOYER'];
}

Results on localhost : Test1 Test2 Test3
(where each instance of Test is in the employer field on the database)

Results on webserver: n Test1 S & & m

i am clueless as to what is causing this...


could it be because of the versions PHP and MySQL i'm using on the localhost may be different from the samme on the web server?