PHP - Moved: A Query To Exclude Certn Fields That Match

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=322237.0

A select query I've written joins three tables.  The query works fine, pulling up a users table, a table for specials advertising that are entered by members, a and a third table the identivies members who have joined a customer  application.   A page displays listing all the entries who have joined the customer application, their names, address, etc display but if they have not set up their special advertising, then the fields for that table display NULL.   I have tried an If and an ifelse to not display text (you can see in the code the HTML Hours of Operation: and Specials:).  Thee field I am using to differentiate is "m_primeID", it is an intiger field.  The if statement I've written is follows.

	if( $row["$m_primeID"] == 'NULL' )
	{
		$company .= "";
	}
	elseif( $row["$m_primeID"] <> 'NULL'  )
		{
	$company .= "<b>Hours of Operation:</b><br>" . ($row["m_coupon_title"]) . "<br /><br />\n";
	$company .= "<b>Special:</b><br>" .($row["m_coupon_desc"]) . "<br /><br />\n";
		}

Here is a screen shot of part of the joined tables.       This screen shot show the Null on the joined tables that don't have customer advertising set up.   Any Ideas Attached Files  Screen-Shot-of-Join.jpg   108.65KB   0 downloads

Hi,
I searched and couldn't find a previous solution..

I'm supposed to take this existing long form and tweak it so it excludes empty fields when emailed.. Can anyone show me what would work for this code below? Any help would be greatly appreciated..

Sorry for the long code, i didn't know where to cut it off..

Code: [Select]
<?php
$EmailTo = Trim(stripslashes($_POST['EmailTo']));
$EmailFrom = Trim(stripslashes($_POST['EmailFrom'])); 
$Subject = "";

// terms
$terms_conditions_details = Trim(stripslashes($_POST['terms_conditions_details']));

// contact information
$full_name = Trim(stripslashes($_POST['full_name'])); 
$title = Trim(stripslashes($_POST['title'])); 
$company = Trim(stripslashes($_POST['company']));
$billing_address = Trim(stripslashes($_POST['billing_address']));
$billing_city = Trim(stripslashes($_POST['billing_city']));
$billing_state = Trim(stripslashes($_POST['billing_state']));
$billing_zip = Trim(stripslashes($_POST['billing_zip']));
$phone = Trim(stripslashes($_POST['phone']));
$alt_phone = Trim(stripslashes($_POST['alt_phone']));
$how_did_you_hear = Trim(stripslashes($_POST['how_did_you_hear']));

// event information
$event_date = Trim(stripslashes($_POST['event_date']));
$guests = Trim(stripslashes($_POST['guests']));
$event_start_time = Trim(stripslashes($_POST['event_start_time']));
$event_end_time = Trim(stripslashes($_POST['event_end_time']));
$event_address = Trim(stripslashes($_POST['event_address']));
$event_city = Trim(stripslashes($_POST['event_city']));
$event_state = Trim(stripslashes($_POST['event_state']));
$event_zip = Trim(stripslashes($_POST['event_zip']));
$event_type = Trim(stripslashes($_POST['event_type']));
$event_type_other = Trim(stripslashes($_POST['event_type_other']));
$event_theme = Trim(stripslashes($_POST['event_theme']));
$special_requests = Trim(stripslashes($_POST['special_requests']));
$budget = Trim(stripslashes($_POST['budget']));
$service_type = Trim(stripslashes($_POST['service_type']));

// wings & wingers
$grilled_wings = Trim(stripslashes($_POST['grilled_wings']));
$buffalo_wings = Trim(stripslashes($_POST['buffalo_wings']));
$wingers = Trim(stripslashes($_POST['wingers']));
$wing_sauces1 = Trim(stripslashes($_POST['wing_sauces1']));
$wing_sauces2 = Trim(stripslashes($_POST['wing_sauces2']));
$wing_sauces3 = Trim(stripslashes($_POST['wing_sauces3']));
$wing_sauces4 = Trim(stripslashes($_POST['wing_sauces4']));
$wing_sauces5 = Trim(stripslashes($_POST['wing_sauces5']));
$wing_sauces6 = Trim(stripslashes($_POST['wing_sauces6']));
$wing_sauces7 = Trim(stripslashes($_POST['wing_sauces7']));
$wing_sauces8 = Trim(stripslashes($_POST['wing_sauces8']));
$wing_sauces9 = Trim(stripslashes($_POST['wing_sauces9']));
$wing_sauces10 = Trim(stripslashes($_POST['wing_sauces10']));
$wing_sauces11 = Trim(stripslashes($_POST['wing_sauces11']));
$wing_sauces12 = Trim(stripslashes($_POST['wing_sauces12']));
$wing_sauces13 = Trim(stripslashes($_POST['wing_sauces13']));
$wing_sauces14 = Trim(stripslashes($_POST['wing_sauces14']));

// party platters
$chicken_finger_platter = Trim(stripslashes($_POST['chicken_finger_platter']));
$chicken_nugget_platter = Trim(stripslashes($_POST['chicken_nugget_platter']));
$chicken_wing_platter = Trim(stripslashes($_POST['chicken_wing_platter']));

// salads
$caesar_salad = Trim(stripslashes($_POST['caesar_salad']));
$house_salad = Trim(stripslashes($_POST['house_salad']));
$cobb_salad = Trim(stripslashes($_POST['cobb_salad']));
$sea_breeze_salad = Trim(stripslashes($_POST['sea_breeze_salad']));

// appetizers
$fresh_fruit_platter = Trim(stripslashes($_POST['fresh_fruit_platter']));
$chilled_vegetable_platter = Trim(stripslashes($_POST['chilled_vegetable_platter']));
$cocktail_shrimp = Trim(stripslashes($_POST['cocktail_shrimp']));
$tailgate_chips_platter = Trim(stripslashes($_POST['tailgate_chips_platter']));
$chips_and_salsa = Trim(stripslashes($_POST['chips_and_salsa']));
$spinach_artichoke_dip_platter = Trim(stripslashes($_POST['spinach_artichoke_dip_platter']));
$quesadilla_platter = Trim(stripslashes($_POST['quesadilla_platter']));

// entrees
$bbq_ribs_platter = Trim(stripslashes($_POST['bbq_ribs_platter']));
$hawaiian_chicken = Trim(stripslashes($_POST['hawaiian_chicken']));
$mahi_over_rice = Trim(stripslashes($_POST['mahi_over_rice']));

// sandwiches
$gourmet_slider_platter = Trim(stripslashes($_POST['gourmet_slider_platter']));
$mini_cheeseburger_platter = Trim(stripslashes($_POST['mini_cheeseburger_platter']));
$club_sandwich_platter = Trim(stripslashes($_POST['club_sandwich_platter']));
$turkey_wrap_platter = Trim(stripslashes($_POST['turkey_wrap_platter']));
$philly_cheese_platter = Trim(stripslashes($_POST['philly_cheese_platter']));


// dessert
$chocolate_brownie_platter = Trim(stripslashes($_POST['chocolate_brownie_platter']));
$apple_crisp = Trim(stripslashes($_POST['apple_crisp']));
$mini_gourmet_cheesecakes = Trim(stripslashes($_POST['mini_gourmet_cheesecakes']));

//$10 meal deal
$meal_deal_wings = Trim(stripslashes($_POST['meal_deal_wings']));
$meal_deal_grilled_chicken = Trim(stripslashes($_POST['meal_deal_grilled_chicken']));
$meal_deal_burger = Trim(stripslashes($_POST['meal_deal_burger']));
$meal_deal_lemonade = Trim(stripslashes($_POST['meal_deal_lemonade']));
$meal_deal_iced_tea = Trim(stripslashes($_POST['meal_deal_iced_tea']));
$meal_deal_sauces1 = Trim(stripslashes($_POST['meal_deal_sauces1']));
$meal_deal_sauces2 = Trim(stripslashes($_POST['meal_deal_sauces2']));
$meal_deal_sauces3 = Trim(stripslashes($_POST['meal_deal_sauces3']));
$meal_deal_sauces4 = Trim(stripslashes($_POST['meal_deal_sauces4']));
$meal_deal_sauces5 = Trim(stripslashes($_POST['meal_deal_sauces5']));
$meal_deal_sauces6 = Trim(stripslashes($_POST['meal_deal_sauces6']));
$meal_deal_sauces7 = Trim(stripslashes($_POST['meal_deal_sauces7']));
$meal_deal_sauces8 = Trim(stripslashes($_POST['meal_deal_sauces8']));
$meal_deal_sauces9 = Trim(stripslashes($_POST['meal_deal_sauces9']));
$meal_deal_sauces10 = Trim(stripslashes($_POST['meal_deal_sauces10']));
$meal_deal_sauces11 = Trim(stripslashes($_POST['meal_deal_sauces11']));
$meal_deal_sauces12 = Trim(stripslashes($_POST['meal_deal_sauces12']));
$meal_deal_sauces13 = Trim(stripslashes($_POST['meal_deal_sauces13']));
$meal_deal_sauces14 = Trim(stripslashes($_POST['meal_deal_sauces14']));

// box lunches
$box_turkey_ruben = Trim(stripslashes($_POST['box_turkey_ruben']));
$box_blt_on_ciabatta = Trim(stripslashes($_POST['box_blt_on_ciabatta']));
$box_club = Trim(stripslashes($_POST['box_club']));
$box_ham_and_cheese = Trim(stripslashes($_POST['box_ham_and_cheese']));
$box_chipolte_shrimp_blt = Trim(stripslashes($_POST['box_chipolte_shrimp_blt']));
$box_turkey_bacon_ranch = Trim(stripslashes($_POST['box_turkey_bacon_ranch']));
$box_buffalo_chicken = Trim(stripslashes($_POST['box_buffalo_chicken']));
$box_veggie = Trim(stripslashes($_POST['box_veggie']));
$box_caesar_salad = Trim(stripslashes($_POST['box_caesar_salad']));
$box_house_salad = Trim(stripslashes($_POST['box_house_salad']));
$box_cobb_salad = Trim(stripslashes($_POST['box_cobb_salad']));
$box_sea_breeze_salad = Trim(stripslashes($_POST['box_sea_breeze_salad']));

// full service catering
$theme_package = Trim(stripslashes($_POST['theme_package']));
$theme_package_information = Trim(stripslashes($_POST['theme_package_information']));
$reception = Trim(stripslashes($_POST['reception']));
$reception_information = Trim(stripslashes($_POST['reception_information']));
$specialty_stations = Trim(stripslashes($_POST['specialty_stations']));
$bar_beverage_service = Trim(stripslashes($_POST['bar_beverage_service']));
$bar_beverage_service_information = Trim(stripslashes($_POST['bar_beverage_service_information']));
$breakfast = Trim(stripslashes($_POST['breakfast']));
$breakfast_information = Trim(stripslashes($_POST['breakfast_information']));
$notes = Trim(stripslashes($_POST['notes']));

// payment
$payment1 = Trim(stripslashes($_POST['payment1']));
$payment2 = Trim(stripslashes($_POST['payment2']));
$payment3 = Trim(stripslashes($_POST['payment3']));
$payment4 = Trim(stripslashes($_POST['payment4']));
$payment5 = Trim(stripslashes($_POST['payment5']));
$payment6 = Trim(stripslashes($_POST['payment6']));

// confirmation email
$confirmation_subject = "";
$confirmation_body = "$full_name,\n\n
Thank you for emailing us. A catering manager from your location will get in touch with you shortly.\n\n
\n
\n";


$Body = "";

$Body .= "CONTACT INFORMATION\n";
$Body .= "\nFull Name: ";
$Body .= $full_name;
$Body .= "\nTitle: ";
$Body .= $title;
$Body .= "\nCompany: ";
$Body .= $company;
$Body .= "\nBilling Address: ";
$Body .= $billing_address;
$Body .= ", ";
$Body .= $billing_city;
$Body .= ", ";
$Body .= $billing_state;
$Body .= ", ";
$Body .= $billing_zip;
$Body .= "\nPhone: ";
$Body .= $phone;
$Body .= "\nAlternate Phone: ";
$Body .= $alt_phone;
$Body .= "\nHow did you hear about us?: ";
$Body .= $how_did_you_hear;
$Body .= "\n";
$Body .= $terms_conditions_details;

$Body .= "\n\nEVENT INFORMATION\n";
$Body .= "\nEvent Date: ";
$Body .= $event_date;
$Body .= "\nNumber of Guests: ";
$Body .= $guests;
$Body .= "\nEvent Start Time: ";
$Body .= $event_start_time;
$Body .= "\nEvent End Time: ";
$Body .= $event_end_time;
$Body .= "\nEvent Address: ";
$Body .= $event_address;
$Body .= ", ";
$Body .= $event_city;
$Body .= ", ";
$Body .= $event_state;
$Body .= ", ";
$Body .= $event_zip;
$Body .= "\nType of Event: ";
$Body .= $event_type;
$Body .= "\nType of Event: Other: ";
$Body .= $event_type_other;
$Body .= "\nEvent Theme: ";
$Body .= $event_theme;
$Body .= "\nSpecial Requests: ";
$Body .= $special_requests;
$Body .= "\nBudget: ";
$Body .= $budget;
$Body .= "\nType of Service: ";
$Body .= $service_type;

$Body .= "\n\nWINGS & WINGERS\n";
$Body .= "\nGrilled Wings: ";
$Body .= $grilled_wings;
$Body .= "\nBuffalo Wings: ";
$Body .= $buffalo_wings;
$Body .= "\nWingers: ";
$Body .= $wingers;
$Body .= "\nWing Sauces: ";
$Body .= "$wing_sauces1, $wing_sauces2, $wing_sauces3, $wing_sauces4, $wing_sauces5, $wing_sauces6, $wing_sauces7, $wing_sauces8, $wing_sauces9, $wing_sauces10, $wing_sauces11, $wing_sauces12, $wing_sauces13, $wing_sauces14";

$Body .= "\n\nPARTY PLATTERS\n";
$Body .= "\nChicken Finger Platter: ";
$Body .= $chicken_finger_platter;
$Body .= "\nChicken Nugget Platter: ";
$Body .= $chicken_nugget_platter;
$Body .= "\nChicken Wing Platter: ";
$Body .= $chicken_wing_platter;

$Body .= "\n\nSALADS\n";
$Body .= "\nCaesar Salad: ";
$Body .= $caesar_salad;
$Body .= "\nHouse Salad: ";
$Body .= $house_salad;
$Body .= "\nCobb Salad: ";
$Body .= $cobb_salad;
$Body .= "\nSea Breeze Salad: ";
$Body .= $sea_breeze_salad;

$Body .= "\n\nAPPETIZERS\n";
$Body .= "\nFresh Fruit Platter: ";
$Body .= $fresh_fruit_platter;
$Body .= "\nChilled Vegetable Platter: ";
$Body .= $chilled_vegetable_platter;
$Body .= "\nCocktail Shrimp: ";
$Body .= $cocktail_shrimp;
$Body .= "\nTailgate Chips Platter: ";
$Body .= $tailgate_chips_platter;
$Body .= "\nChips and Salsa: ";
$Body .= $chips_and_salsa;
$Body .= "\nSpinach Artichoke Dip Platter: ";
$Body .= $spinach_artichoke_dip_platter;
$Body .= "\nQuesadilla Platter: ";
$Body .= $quesadilla_platter;

$Body .= "\n\nENTREES\n";
$Body .= "\nBBQ Ribs Platter: ";
$Body .= $bbq_ribs_platter;
$Body .= "\nHawaiian Chicken: ";
$Body .= $hawaiian_chicken;
$Body .= "\nMahi Over Rice: ";
$Body .= $mahi_over_rice;

$Body .= "\n\nSANDWICHES\n";
$Body .= "\nGourmet Slider Platter: ";
$Body .= $gourmet_slider_platter;
$Body .= "\nMini Cheeseburger Platter: ";
$Body .= $mini_cheeseburger_platter;
$Body .= "\nClub Sandwich Platter: ";
$Body .= $club_sandwich_platter;
$Body .= "\nTurkey Wrap Platter: ";
$Body .= $turkey_wrap_platter;
$Body .= "\nPhilly Cheese Platter: ";
$Body .= $philly_cheese_platter;

$Body .= "\n\nDESSERT\n";
$Body .= "\nChocolate Brownie Platter: ";
$Body .= $chocolate_brownie_platter;
$Body .= "\nApple Crisp: ";
$Body .= $apple_crisp;
$Body .= "\nMini Gourmet Cheesecakes: ";
$Body .= $mini_gourmet_cheesecakes;

$Body .= "\n\n$10 MEAL DEAL\n";
$Body .= "\nWings: ";
$Body .= $meal_deal_wings;
$Body .= "\nGrilled Chicken Breast: ";
$Body .= $meal_deal_grilled_chicken;
$Body .= "\nBurger: ";
$Body .= $meal_deal_burger;
$Body .= "\nLemonade: ";
$Body .= $meal_deal_lemonade;
$Body .= "\nIced Tea: ";
$Body .= $meal_deal_iced_tea;
$Body .= "\nWing Sauces: ";
$Body .= "\n\nBOX LUNCHES\n";
$Body .= "\nSandwiches";
$Body .= "\nTurkey Ruben: ";
$Body .= $box_turkey_ruben;
$Body .= "\nBLT on Ciabatta Bread: ";
$Body .= $box_blt_on_ciabatta;
$Body .= "\nClub: ";
$Body .= $box_club;
$Body .= "\nHam and Cheese: ";
$Body .= $box_ham_and_cheese;
$Body .= "\n\nWraps";
$Body .= "\nChipolte Shrimp BLT: ";
$Body .= $box_chipolte_shrimp_blt;
$Body .= "\nTurkey Bacon Ranch: ";
$Body .= $box_turkey_bacon_ranch;
$Body .= "\nBuffalo Chicken: ";
$Body .= $box_buffalo_chicken;
$Body .= "\nVeggie: ";
$Body .= $box_veggie;
$Body .= "\n\nSalad";
$Body .= "\nCaesar Salad: ";
$Body .= $box_caesar_salad;
$Body .= "\nHouse Salad: ";
$Body .= $box_house_salad;
$Body .= "\nCobb Salad: ";
$Body .= $box_cobb_salad;
$Body .= "\nSea Breeze Salad: ";
$Body .= $box_sea_breeze_salad;

$Body .= "\n\nFULL SERVICE CATERING\n";
$Body .= "\nTheme Package: ";
$Body .= $theme_package;
$Body .= "\nInformation: ";
$Body .= $theme_package_information;
$Body .= "\nReception: ";
$Body .= $reception;
$Body .= "\nInformation: ";
$Body .= $reception_information;
$Body .= "\nSpecialty Stations: ";
$Body .= $specialty_stations;
$Body .= "\nBar/Beverage Service: ";
$Body .= $bar_beverage_service;
$Body .= "\nInformation: ";
$Body .= $bar_beverage_service_information;
$Body .= "\nBreakfast: ";
$Body .= $breakfast;
$Body .= "\nInformation: ";
$Body .= $breakfast_information;
$Body .= "\nNotes: ";
$Body .= $notes;

$Body .= "\n\nPAYMENT TYPE\n";
$Body .= "$payment1, $payment2, $payment3, $payment4, $payment5, $payment6";

$success = mail($EmailTo, $Subject, $Body, "From: <$EmailFrom>")
&& mail($EmailFrom, $confirmation_subject, $confirmation_body, "From: <$EmailTo>");

Hi everyone,
I am working on a website that involves MySQL. Here is the example to my table.


field1 | field2

George Fritz | www.fritz.org
Linda Gomez | www.gomez.org

I need a code, that will fetch field2 of the given field1. For example, if $field1 is George Fritz, the code should return www.fritz.org
Any help?

Thanks...
Funstein