not a valid MySQL result resource ??

Anon

Hi,
the following which I copied from an article to try and learn php is giving me problems.
php returns the following error:
"Warning: Supplied argument is not a valid MySQL result resource in /home/www/devzone/content.php on line 16"
* line 16 in my script is >$joke = mysql_fetch_array($joke); <
<?
include("settings.php");
$connection = mysql_connect($DB_HOST, $DB_USERNAME, $DB_PASSWORD) or die ("Unable to
connect!");
$joke = mysql_query("SELECT text FROM Jokes ". "WHERE ID=$id");
$joke = mysql_fetch_array($joke);
$joketext = $joke["text"];
?>

Can anybody help me along?... I'm sure I'm just missing something small..

thanks,

Mike

Anon

"Supplied argument is not a valid MySQL result resource"

means your query failed.

change your code to this:

if ($joke = mysql_query("SELECT text FROM Jokes ". "WHERE ID=$id"))
{
$joke = mysql_fetch_array($joke);
$joketext = $joke["text"];
}
else
{
echo mysql_error();
exit;
};

Anon

hi all!

i was just dealing with this "not a valid MySQL result" thing for 8 hours now. i did everything... recompiling mysql and php and so on.

most of you are running a linuxserver, right?
but most of you have worked with windows before and maybe even developped their homepages there... well, listen what happened to me!

i found a nice string here:

echo mysql_error();

which told me that no database connection existed... and guess what turned out...

unix systems are carse-sensitive, windows isn't. guess what? have a look if the name of your database in your code is written with the same characters as the ones in your system!