'0' and p.status = 'Active' and p.userId = m.member_id and m.status = 'Active' "; $result=mysql_query($query) or die(mysql_error()); $numRows = mysql_num_rows($result); if($numRows > 0) { while($row=mysql_fetch_array($result)) { $prodUrl = $url.'product_details.php?cid='.$row['userId'].'&scatid='.$row['subCategoryId'].'&recNo='.$row['recNo'].'&page=product'; ?>