works locally but not on upload

php and apache

[ukgimp]

I have a script that works fine on my local version of apache. When I upload it to another server, having altered the variables it gives the following error. Other scripts work fine using the same settings.

Warning: Supplied argument is not a valid MySQL result resource in blahblah/prototype/mysql.php3 on line 59.

Line 58-60 :
if( (!$results) or (empty($results)) ) {
mysql_free_result($results);
return false;

Is there an issue with versions of apache or something else.

Cheers and thanks in advance

[jatar_k]

If I remember correctly that error implies that you are making a call to sql that has something wrong with it.

Is the value for $results working properly? Are you worried about taking too much memory?

The comparison itself seems flawed. If there are no results, free the memory $results is using. That is backwards. I would be more likely to think that if there are results then free them.

It looks like you are generating a mysql error because you are trying to free an empty variable. I would look at the logic of that area of code.

[martin]

if( (!$results) or (empty($results)) ) {

the first check is redundant:

if(empty($results)) {

does the same.

Why do you want to free a result set if it does not exist anyway?
Shouldn't it be:

if(!empty($results)) {

[ergophobe]

A typical reason for this error is that you have a query that has a column in it that is not found in the database or something like that.

Use the "or die" command to have it output the query string. Then you can see what's happening and why the query is invalid. If it isn't immediately obvious, keep tweaking it and running it in the SQL client (shell, PhpMyAdmin, Mysql-Front or whatever you're using).

Tom

[ukgimp]

Cheers

I will look into those suggestions monday.

[ukgimp]

Commented out the two lines and re-tried. It did not fall down but there was no data. Also turns out there was an error in the schema I had used so that was masking the problem.

So two whole days spent on something that took two whole seconds to repair. :) FANTASTIC

Thanks