php errors

[manicleek]

Not sure which forum I should be posting this in but...

I have just started trying to code my first php site and I get this error:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in etc...

also happens if I use mysql_fetch_array() and mysql_result()

anyone have any ideas?

 

[nawlej]

Well, I would need to see your code, but at first glance, it appears that you are not connected to a database object, or you ran an invalid query.

___________________________________
[morse]--... ...--[/morse], Eric.

 

[ingresman]

Yes, you get this when the sql has failed or you didn't connect properly.

post your code and the line where you get the error

 

[manicleek]

This is the code I used, I know that the database connects ok etc..

//select db
mysql_select_db("marinas");

//Report connection status
if (!$db) {
echo "There was a problem connecting to the database";
exit;
}
//Get results
$marmonthquery = "SELECT * FROM marmonth";
$monthresult = mysql_query($marmonthquery);
$monthrow = mysql_fetch_object($monthresult);

the last line of the code I have posted is where the problem occurs

 

[LTeeple]

Try:
$connection = mysql_select_db("dbname","username","password");
$monthresult = mysql_query($marmonthquery,$connection);






Cheers!
Laura

 

[ingresman]

After the call to mysql_query add the following:
$e = mysql_error();
echo $e;

mysql_error takes a parametrer but should be ok to default it

 

[nawlej]

mysql_select_db() should only take the database name and the database object you are using, not username and password.
Try adding "die" to your code, and also explicitily specify the connection identifer.

For instance:

$cnx = mysql_connect(xxx,xxx,xxx) or die "Unable to connect to Database";
//select db
mysql_select_db("marinas",$cnx);

//Report connection status
if (!$db) {
    echo "There was a problem connecting to the database";
    exit;
}
//Get results
$marmonthquery = "SELECT * FROM marmonth";
$monthresult = mysql_query($marmonthquery,$cnx) or die "Problem!";

while($monthrow = mysql_fetch_array($monthresult)){

 echo $monthrow['columname'];

}

SHOULD WORK. Give that a shot.

___________________________________
[morse]--... ...--[/morse], Eric.

 

[ingresman]

Come on now, lets include error reporting here

 

[manicleek]

got it working

Thanks for that

 

[nawlej]

So what was the problem?

___________________________________
[morse]--... ...--[/morse], Eric.

 

[LTeeple]

Oops my bad! I made an error in my haste.
I meant to type in

$connection = mysql_connect("localhost","username","password")
    or die("Couldn't make connection.");
$db = mysql_select_db("databasename", $connection)
    or die("Couldn't select database.");
$results = mysql_query($sql,$connection);

Thanks for correcting me on that!


Cheers!
Laura