Valid MySQL result 1

[jahjah]

I am recieving this error message from a php script - any ideas where I might be going wrong??

Warning: Supplied argument is not a valid MySQL result resource in /w/

http://www/intranet/apache/htdocs/it/stu/results.php

on line 30

 

[Dogers]

sound slke the sql is wrong to me - know way of knowing without the script!

 

[youradds]

Try adding this after the mysql_query() part...

$error = mysql_error();
if ($error) { echo "Error: $error"; exit; }

Cheers

Andy

 

[jahjah]

This is the error I get now Andy:

Error: No Database Selected

Any ideas thanks for the replies

Jahjah

 

[jahjah]

Have now solved the problem, I was connecting to mySQL with a user that wasnt able to run php - now have it working fine

Thanks anyway

Jahjah

 

[Dogers]

in which case, theres the problem!

when using mysql, not only do you connect to the server, you have to tell it which database to use before you can start firing sql commands at it

above your sql code, put in
mysql_select_db("dbname"

you should have the dbname from when you or whoever setup mysql initially

 

[DRJ478]

Also:

Save yourself some time and aggravation by adding error checking for each mysql command:

$cp = mysql_connect($host,$user,$pass) OR die(mysql_error());
mysql_select_db($dbname, $cp) OR die(mysql_error());
etc.

When you catch the actual error right where it happens you will not have to start searching back from an effect that is caused way before it happens.

 

[freenut]

Thanks DRJ478
I will use that in future

JahJah