too long

Question

I never did such PHP/MYSQL tricks to join multitables. Please who has experience in this field Help:

$qry=mysql_query("select {$table_prefix}user_cv.*, {$table_prefix}advertising.* from {$table_prefix}user_cv, {$table_prefix}advertising where {$table_prefix}user_cv.publish='yes' and {$table_prefix}advertising.publish='Y'");

mysql query return 0 results .

Answer 1

$qry = "SELECT {$table_prefix}user_cv.*, {$table_prefix}advertising.*
        FROM {$table_prefix}user_cv
        LEFT JOIN {$table_prefix}advertising ON {$table_prefix}advertising.publish='Y'
        WHERE {$table_prefix}user_cv.publish='yes'";
mysql_query($qry);

I did not test this! I could be wrong but it might be a step in the right direction. (Still new myself)