$value) { $query="UPDATE hotlist SET hot_private = 'Y' WHERE (hot_id=$value)"; $result=mysql_query($query,$link) or die(mysql_error()); } } if ( isset( $hotlist)) { foreach ( $hotlist as $key=>$value) { $query="delete FROM hotlist WHERE (hot_id=$value)"; $result=mysql_query($query,$link) or die(mysql_error()); } } # otherwise the mode is to add to the hotlist } $my = $db->get_col("SELECT hot_advid FROM hotlist WHERE (hot_userid=$Sess_UserId)"); $me = $db->get_col("SELECT hot_userid FROM hotlist WHERE (hot_advid=$Sess_UserId)"); $dual_links = array_intersect((array)$my, (array)$me); if ($mode == 0) { $colspan = 6; $query="SELECT * FROM hotlist INNER JOIN adverts ON (hot_advid = adv_userid) WHERE (hot_userid=$Sess_UserId) ORDER BY hot_dateadded"; } else { $colspan = 4; $query="SELECT * FROM hotlist INNER JOIN adverts ON (hot_userid = adv_userid) WHERE (hot_advid=$Sess_UserId) ORDER BY hot_dateadded"; } $result=mysql_query($query,$link) or die(mysql_error()); ?> =$skin->ShowHeader($area)?>