Error: Supplied argument is not a valid MySQL result resource

[rmpuk]

I'm getting this error when I upload the script to my webserver. However, it runs fine on my local installation. Am I right in thinking it's something to do with the way the remote server is configured, and if so, any ideas what I can do about it?

In my PHP script, I use the following line of code to select the data:

$result = mysql_query("SELECT * FROM tab1 WHERE catno=$formitem",$db);

then display the data as follows:

<?php printf(mysql_result($result,0,&quot;text1&quot;)) ?>

When the script runs, it says the error was caused by the second line of code.

Any ideas much appreciated!

Cheers,
RMP

 

[BigBadDave]

Like this :

<?php
$link = mysql_connect(&quot;my_server&quot;, &quot;username&quot;, &quot;password&quot;
mysql_select_db(&quot;my_db&quot;
$result = mysql_query(&quot;SELECT * FROM tab1 WHERE catno='$formitem'&quot;
printf(mysql_result($result,0,&quot;text1&quot);
mysql_close($link);
?> Regards

Big Bad Dave

davidbyng@hotmail.com

 

[rmpuk]

Thanks, but that's the code I'm using already!

The strange thing is that it runs fine on my test box, but not on the remote one, so I think it might be to do with the config of the remote system. What though - I haven't a clue!

RMP

 

[rmpuk]

OK, fixed it.

Using <?php printf(mysql_error()); ?> found out that no database was selected as the server had prefixed my database name with my login name. Changed the select db to the right name and all was fine.

RMP