[mrerotic]

How can I check to see if parentid = '1' for a product? I think my query below is wrong can someone please verify that this query should work?

PHP Code:

$test = func_query("SELECT productid FROM $sql_tbl[products] WHERE product = '$p[product]'");
// Get category parentid to find section for product
$pcatquery = "SELECT categoryid FROM $sql_tbl[products_categories] WHERE productid = '".$test."'";
$prodcatinfo = func_query($pcatquery);
 
if (!empty($prodcatinfo)){
foreach ($prodcatinfo as $pcat){
$getpquery = func_query("SELECT parentid, category FROM $sql_tbl[categories] WHERE categoryid = '".$pcat['categoryid']."'");
foreach ($getpquery as $getpcat){
if ($getpcat['parentid'] != '0'){
if ($getpcat['parentid'] == '1'){
$pcatsection = "dvds";
}
}
}
}
}