mysql query issue

[Andy_GS]

hey guys,

right im trying to get a list of product id's and names from zen cart, with certain conditions.

$brand ="13";

$query = mysql_query ("SELECT products_descriptions.products_name, products.products_id ".
 "FROM products_descriptions, products ".
    "WHERE products.products_id = products_descriptions.products_id". "AND products.manufacturers_id == '$brand'"); 

yet its giving me a response of 'DatabaseQuery was empty' so clearly there is somthing wrong in my syntax.

what im after is:

i want all product names and ids, where the manufacturer id is = 13.

i've made 13 a variable because this will change depending on the manufacturer i select.

then ofc i would want it to detect which products are active from the products_status, but first things first getting the initally query right.

please help :)

Andy.