UNION and fetch_assoc

[klik]

Hi,

I have the following

$result =   mysql_query("SELECT * FROM cms_links WHERE link_activated = '0'
		UNION
		SELECT user_level FROM cms_users WHERE user_level = '1'");


echo ' <i>Submitted Links</i><br><br> ';
while ($row = mysql_fetch_assoc($result))
{
    echo
    'Link Name : ' . $row['link_name'] . '<br>' . 
    'Link Address : ' . $row['link_url'] . '<br>' . 
    'Link Description : ' . $row['link_description'] . '<br>' . 
    'Number Of Visits : ' . $row['link_click_count'] . '<br>' . 
    'Submitted : ' . $row['link_date_added'] . '<br>' . 
    'Last Modified : ' . $row['link_last_modified'] . '<br>' . 
    'Added By : ' . $row['link_member'] . '<br><br><br>
    ';
}

Error message I get is

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource.......

[Roger_Ramjet]

For a UNION to work, the two queiries must both return the same number of columns and each matching pair must be the same type. Yours does not. So the query fails and returns false instead of a dataset. This is where php generates the error message. When you try to access the resultset it finds that there is no valid result set. Hence the message
supplied argument is not a valid MySQL result resource.......