[Solved] mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtua15/public_html/main/1515/dafreg.php on line 9 [duplicate]

Question

Something is wrong with query check with print mysql_error();

Check query. quote properly values assigned in query.

$query = mysql_query("SELECT jos_comprofiler.firstname, jos_comprofiler.lastname,
         jos_users.username, jos_comprofiler.cb_country, jos_users.email 
         FROM jos_users LEFT JOIN jos_comprofiler ON jos_users.id=jos_comprofiler.id 
         WHERE jos_users.id ='".mysql_real_escape_string($id)."'");

Accepted Answer

Something is wrong with query check with print mysql_error();

Check query. quote properly values assigned in query.

$query = mysql_query("SELECT jos_comprofiler.firstname, jos_comprofiler.lastname,
         jos_users.username, jos_comprofiler.cb_country, jos_users.email 
         FROM jos_users LEFT JOIN jos_comprofiler ON jos_users.id=jos_comprofiler.id 
         WHERE jos_users.id ='".mysql_real_escape_string($id)."'");