#Get state list $state_query = "SELECT id, name FROM orchard_state"; $state_result = mysql_query ($state_query); #Get country list $country_query = "SELECT id, name FROM country ORDER BY name"; if (!$country_result = mysql_query ($country_query)) showerror(); #Get DMS list $dms_query = "SELECT customer_id, name FROM customer_master WHERE physical <> 'Y' and customer_master_master_id is not null ORDER BY name"; if (!$dms_result = mysql_query ($dms_query)) showerror(); ?>