Warning: Mysql_fetch_object(): Supplied Argument Is Not A Valid Mysql Result Resource

Hell there when i try and connect to pull thing out of the database i get the following error: Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource

Solution 1:

That's because your query is wrong.

$sql = "GET * FROM matt";

must probably become

$sql = "SELECT * FROM matt";

the basic measure to get warned about this is

if (!$result)
 die("mySQL error: ". mysql_error());  

after issuing a query.

Solution 2:

Perhaps try using 'SELECT' instead of 'GET'?

Solution 3:

$sql = "GET * FROM matt";

is wrong. Correct SQL syntax is

$sql = "SELECT * FROM matt";

That error is passed into

$result = mysql_query($sql,$con);

which then is invalid and can't be used in while($row = mysql_fetch_object($result)).

You should check for mysql_error() after mysql_query() to catch these.

Solution 4:

Want to use SELECT *

You can also use

mysql_query($sql, $con) ordie("Error in $sql:" . mysql_error($con));

If you don't want to use die() then you can use echo to see what the error was and help debug the application at least.