I have this query that requires me to pull data from two tables as follows:
$getclients = "SELECT * FROM users, usertutors WHERE users.username = usertutors.clientusername AND users.type='client'";
When I try to pull data from the result of $getclients using:
$clientrow = mysql_fetch_object($getclients); <-- PROBLEM HERE
I get an error stating:
Warning: Supplied argument is not a valid MySQL result resource
I know I have data because I fetch the number of rows from $getclient but I can't the data using the normal $clientrow->column_name_here approach.
Can someone help me out?
KABOOM!