=";
else
$eq='=';
$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
if ($_POST['type'] == 'landingpage') {
$mysql['aff_campaign_id'] = $db->real_escape_string($_POST['aff_campaign_id']);
$landing_page_sql = "SELECT * FROM `202_landing_pages` AS 2lp JOIN 202_aff_campaigns using(aff_campaign_id) JOIN 202_aff_networks using(aff_network_id) WHERE 2lp.user_id='".$mysql['user_id']."' AND 2lp.aff_campaign_id".$eq."'".$mysql['aff_campaign_id']."' AND `landing_page_deleted`='0' AND aff_campaign_deleted='0' AND `aff_network_deleted`='0' ORDER BY `aff_campaign_id`, `landing_page_nickname` ASC";
}
if ($_POST['type'] == 'advlandingpage') {
$mysql['aff_campaign_id'] = $db->real_escape_string($_POST['aff_campaign_id']);
$landing_page_sql = "SELECT * FROM `202_landing_pages` WHERE `user_id`='".$mysql['user_id']."' AND `landing_page_type`='1' AND `landing_page_deleted`='0' ORDER BY `landing_page_nickname` ASC";
}
//if on a refine page, we want to list both SLP and ALP use a UNION to get them both
if ($_POST['type'] == 'landingpages') {
$mysql['aff_campaign_id'] = $db->real_escape_string($_POST['aff_campaign_id']);
$landing_page_sql = "(SELECT landing_page_id,landing_page_nickname FROM `202_landing_pages` AS 2lp JOIN 202_aff_campaigns using(aff_campaign_id) JOIN 202_aff_networks using(aff_network_id) WHERE 2lp.user_id='".$mysql['user_id']."' AND 2lp.aff_campaign_id".$eq."'".$mysql['aff_campaign_id']."' AND `landing_page_deleted`='0' AND aff_campaign_deleted='0' AND `aff_network_deleted`='0' ORDER BY `aff_campaign_id`, `landing_page_nickname` ASC) UNION (SELECT landing_page_id,landing_page_nickname FROM `202_landing_pages` WHERE `user_id`='".$mysql['user_id']."' AND `landing_page_type`='1' AND `landing_page_deleted`='0' ORDER BY `landing_page_nickname` ASC)";
}
?>query($landing_page_sql) or record_mysql_error($landing_page_sql);
if ($landing_page_result->num_rows == 0) { ?>