Resource Boolean?

[unemployment]

How can I fix this error?

 

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given

 

function fetch_most_recent_fans($ctag)
{
$sql = "SELECT
			`company_fans`.`company_id`,
			`company_fans`.`user_id`,
			`company_fans`.`fan_date`,
			`companies`.`companytag`,
			`users`.`firstname`,
			`users`.`lastname`,
			`users`.`username`
		FROM `company_fans`
		LEFT JOIN `companies`
		ON `companies`.`companyid` = `company_fans`.`company_id`
		LEFT JOIN `users`
		ON `users`.`id` = `company_fans`.`user_id`
		WHERE `companies`.`companytag` = {ctag}
		ORDER BY `company_fans`.`fan_date` DESC
		LIMIT 10";

$query = mysql_query($sql);

$return = array();

while (($row = mysql_fetch_assoc($query)) !== false)
{
	$return[] = $row;
}

return $return;
}

[dcro2]

The query's obviously failing, so $query is false.

 

Shouldn't this:

WHERE `companies`.`companytag` = {ctag}

be:

WHERE `companies`.`companytag` = '{$ctag}'

?

[unemployment]

that solves the boolean error but my array is empty