[Resolved] Very Simple Select not working?

[lambrite]

I'm feeling pretty dumb at the moment, but I have the following code:

   	$query_rsProduct = "SELECT products_id FROM products WHERE manufacturers_id = '$productID'";
	debug($query_rsProduct);
	$rsProduct = mysql_query($query_rsProduct, $connHH) or die(mysql_error());
	$row_rsProduct = mysql_fetch_assoc($query_rsProduct);
	$totalRows_rsProduct = mysql_num_rows($rsProduct);

Which produces the following error: (the first line is printed from the debug statement)

SELECT products_id FROM products WHERE manufacturers_id = 'IMHHSS115'
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in [filepath line#]

Can someone please tell me what I am missing here? I don't know what this error message means, and am having no luck with it on Google. Thank you -
Sarah

[Drakla]

It means $conHH hasn't been created as a successful link to the database.

Also the line

$row_rsProduct = mysql_fetch_assoc($query_rsProduct); 

should be

$row_rsProduct = mysql_fetch_assoc($rsProduct); 

as fetch takes a result handle from a query.

[lambrite]

Thanks, that's what it was. I didn't see it b/c my connection was working above that piece of code, so I just knew it wasn't that... but it was set as conHH (with one N instead of two).

I appreciate it.
Sarah