As you can see from my code, I do want to check if all mandatory fields are selected or filled in. As well as the issue of the communicationtyes. SO far I do not have fields or anything for the user to use, to select the different CommunicationTypes he wants. I am not sure how to go about this because, there is the issue that more than one "Destination" can be added for a single CommType. And the number of CommTypes is not fixed and could vary, so thats why Im not sure how much input fields etc to put on page. Does this make sense. Garth > Hmmm...I'm not sure I'm following you. You just want to know how to > deal with multiple drop down lists? Or do you want to be able to check > and make sure all the mandatory selections have been chosen? > -dg > http://www.rexruff.com > > On Nov 2, 2004, at 4:58 AM, Garth Hapgood - Strickland wrote: > > > Well my page doesnt have any of the spoken about elements on it yet, > > because I am not clear as to go about it. > > > > The fields I speak of are things that need to be added extra to my > > page. > > > > Here is my pages code so far........... > > > > <?php > > require('includes/application_top.php'); > > require('registration_globals.php'); > > require('includes/form_check.js.php'); > > ?> > > !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> > > <html> > > <head> > > <title>Matchmakers - empowerment opportunities network</title> > > <meta http-equiv="Content-Type" content="text/html; > > charset=iso-8859-1"> > > <link href="style.css" rel="stylesheet" type="text/css"> > > <script language="JavaScript" type="text/JavaScript"> > > > > <!-- > > > > function MM_preloadImages() { //v3.0 > > var d=document; if(d.images){ if(!d.MM_p) d .MM_p=new Array(); > > var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; > > i<a.length; i++) > > if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; > > d.MM_p[j++].src=a[i];}} > > } > > > > <!-- Hide from old browsers > > function error_popup() { > > newwin = window.open("error_popup.php","sss","height=470,width=450") > > } > > // end hiding --> > > > > //--> > > > > </script> > > > > </head> > > <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> > > <!-- header //--> > > <?php require('includes/header.php'); ?> > > <!-- header_eof //--> > > <!-- body //--> > > <table width="100%" border="0" cellspacing="2" cellpadding="5" > > background="images/page_bg.gif"> > > <tr> > > <td valign="top"><table width="130"> > > <tr> > > <td width="120" align="right" class="pagetitle"><br>registration<img > > src="images/register_image.gif"></td> > > </tr> > > </table></td> > > <td> > > <table width="100%" border="0" cellpadding="0" cellspacing="0"> > > <tr valign="top"> > > <p><br><br><b>Fill in all the fields below correct and accurately, > > then click "Register Now.</b><br><br> > > </tr> > > <tr> > > <td><table width="65%"> > > <form title="register" method="post" onsubmit="return check_form();"> > > <?php > > if (isset($submit) && $submit == "Register Now"){ > > if (strlen($business_name) == 0) {} > > else if (strlen($business_owner) == 0) {} > > else if (strlen($street_address) == 0) {} > > else if (strlen($suburb) == 0) {} > > else if (strlen($city_town) == 0) {} > > else if (strlen($province_desc) == 0) {} > > > > $email_popup(); (the code i was trying to use to call popup > > window) > > } > > else { > > $insertquery = "INSERT INTO business > > (BusinessName, BusinessOwner, StreetAdress, Suburb, CityTown, > > ProvinceID, StreetCode, PostalAddress, PostalCode, WebsiteAddress, > > IndustryID, IndustryOther, BusinessAge, AnnualTurnoverID, > > EmpowermentProfileID, BEEScoreCardID, PreferredLocationID, > > PreferredProductService, PreferredMatchPartner, PreferredAgeID, > > PreferredTurnoverID, PreferredEmpowermentProfileID, DateRegistered, > > MarketSourceID) > > VALUES > > ($business_name, $business_owner, $street_address, '', '', '', > > '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', > > '',)"; > > > > echo "Your registration has been submitted"; > > } > > > > ?> > > <tr> > > <td class="formAreaTitle">.: Business Contact Details</td> > > </tr> > > <tr> > > <td class="main"> > > <table border="0" width="100%" cellspacing="4" cellpadding="0" > > class="formArea"> > > <tr> > > <td width="45%" align="right" class="content">Business Name:</td> > > <td width="55%"><input class="content" type="text" size="35" > > maxlength="100" name="business_name"></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Business Owner:</td> > > <td width="55%"><input class="content" type="text" size="35" > > maxlength="100" name="business_owner"></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Street Address:</td> > > <td width="55%"><input class="content" type="text" size="35" > > maxlength="100" name="street_address"></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Suburb:</td> > > <td width="55%"><input class="content" type="text" size="35" > > maxlength="100" name="suburb"></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">City/Town:</td> > > <td width="55%"><input class="content" type="text" size="35" > > maxlength="100" name="city_town"></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Province:</td> > > <td width="55%"> > > <select class="content" name="province_desc" id="select"><option > > value="">-- select one --</option> > > <?PHP for($x=0;$x<$number_provinces;$x++) > > { > > echo('<option value="'.$rijprovinces["$x"]["ProvinceID"].'"'); > > echo('>'.$rijprovinces["$x"]["Description"].'</option>'); > > } > > ?> > > </select> > > </td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Street Code:</td> > > <td width="55%"><input class="content" type="text" size="5" > > maxlength="4" name="street_code"></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Postal Address:</td> > > <td width="55%"><textarea rows="5" cols="35" class="content" > > name="postal_address"></textarea></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Postal Code:</td> > > <td width="55%"><input class="content" type="text" size="5" > > maxlength="4" name="postal_code"></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Website Address:</td> > > <td width="55%"><input class="content" type="text" size="35" > > maxlength="50" name="website_address"></td> > > </tr> > > </table> > > </td> > > </tr> > > <tr> > > <td class="formAreaTitle">.: Business Information</td> > > </tr> > > <tr> > > <td class="main" width="60%"> > > <table border="0" width="100%" cellspacing="4" cellpadding="0" > > class="formArea"> > > <tr> > > <td width="45%" align="right" class="content">Industry:</td> > > <td width="55%"> > > <select class="content" name="industry_desc" id="select"><option > > value="">-- select one --</option> > > <?PHP for($x=0;$x<$number_industry;$x++) > > { > > echo('<option value="'.$rijindustry["$x"]["IndustryID"].'"'); > > echo('>'.$rijindustry["$x"]["Description"].'</option>'); > > } > > ?> > > </select> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Industry Other:</td> > > <td width="55%"><input class="content" type="text" size="35" > > maxlength="100" name="industry_other"></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Business Age > > (Years):</td> > > <td width="55%"><input class="content" size="5" maxlength="4" > > type="text" name="business_age"></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Annual Turnover:</td> > > <td width="55%"> > > <select class="content" name="ann_turn_desc" id="select"><option > > value="">-- select one --</option> > > <?PHP for($x=0;$x<$number_ann_turn;$x++) > > { > > echo('<option value="'.$rijann_turn["$x"]["AnnualTurnoverID"].'"'); > > echo('>'.$rijann_turn["$x"]["Description"].'</option>'); > > } > > ?> > > </select> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Empowerment > > Profile:</td> > > <td width="55%"> > > <select class="content" name="empower_prof_desc" id="select"><option > > value="">-- select one --</option> > > <?PHP for($x=0;$x<$number_empower;$x++) > > { > > echo('<option > > value="'.$rijempower["$x"]["EmpowermentProfileID"].'"'); > > echo('>'.$rijempower["$x"]["Description"].'</option>'); > > } > > ?> > > </select> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">BEE Score Card:</td> > > <td width="55%"> > > <select class="content" name="scorecard_desc" id="select"><option > > value="">-- select one --</option> > > <?PHP for($x=0;$x<$number_scorecard;$x++) > > { > > echo('<option value="'.$rijscorecard["$x"]["BEEScoreCardID"].'"'); > > echo('>'.$rijscorecard["$x"]["Description"].'</option>'); > > } > > ?> > > </select> > > </tr> > > </table> > > </td> > > </tr> > > <tr> > > <td class="formAreaTitle">.: Preferred Partner Information</td> > > </tr> > > <tr> > > <td class="main" width="60%"> > > <table border="0" width="100%" cellspacing="4" cellpadding="0" > > class="formArea"> > > <tr> > > <td width="45%" align="right" class="content">Preferred Product > > Service:</td> > > <td width="55%"><textarea rows="5" cols="35" class="content" > > maxlength="255" type="text" > > name="preferred_product_service"></textarea></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Preferred Match > > Partner:</td> > > <td width="55%"><textarea rows="5" cols="35" class="content" > > maxlength="255" type="text" > > name="preferred_match_partner"></textarea></td> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Preferred > > Location:</td> > > <td width="55%"> > > <select class="content" name="prefer_location_desc" > > id="select"><option value="">-- select one --</option> > > <?PHP for($x=0;$x<$number_provinces;$x++) > > { > > echo('<option value="'.$rijprovinces["$x"]["ProvinceID"].'"'); > > echo('>'.$rijprovinces["$x"]["Description"].'</option>'); > > } > > ?> > > </select> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Preferred Age:</td> > > <td width="55%"> > > <select class="content" name="prefer_age_desc" id="select"><option > > value="">-- select one --</option> > > <?PHP for($x=0;$x<$number_age;$x++) > > { > > echo('<option value="'.$rij_age["$x"]["AgeID"].'"'); > > echo('>'.$rij_age["$x"]["Description"].'</option>'); > > } > > ?> > > </select> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Preferred Annual > > Turnover:</td> > > <td width="55%"> > > <select class="content" name="prefer_turnover_desc" > > id="select"><option value="">-- select one --</option> > > <?PHP for($x=0;$x<$number_pref_turnover;$x++) > > { > > echo('<option > > value="'.$rij_pref_turnover["$x"]["PreferredAnnualTurnoverID"].'"'); > > echo('>'.$rij_pref_turnover["$x"]["Description"].'</option>'); > > } > > ?> > > </select> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Preferred Empowerment > > Profile:</td> > > <td width="55%"> > > <select class="content" name="prefer_empower_desc" > > id="select"><option value="">-- select one --</option> > > <?PHP for($x=0;$x<$number_pref_empower;$x++) > > { > > echo('<option > > value="'.$rij_pref_empower["$x"]["PreferredEmpowermentProfileID"].'"'); > > echo('>'.$rij_pref_empower["$x"]["Description"].'</option>'); > > } > > ?> > > </select> > > </tr> > > <tr> > > <td width="45%" align="right" class="content">Market Source:</td> > > <td width="55%"> > > <select class="content" name="prefer_turnover_desc" > > id="select"><option value="">-- select one --</option> > > <?PHP for($x=0;$x<$number_market_source;$x++) > > { > > echo('<option > > value="'.$rij_market_source["$x"]["PreferredAnnualTurnoverID"].'"'); > > echo('>'.$rij_market_source["$x"]["Description"].'</option>'); > > } > > ?> > > </select> > > </tr> > > </table> > > <tr> > > <td align="right"><input type="submit" name="submit" value="Register > > Now"></td> > > </tr> > > </td> > > <td width="60%"> > > > > </td> > > <tr> > > </tr> > > </form> > > </table></td> > > <td><table width="35%"> > > > > </table></td> > > </tr> > > </table> > > </td> > > <td width="15"> </td> > > </tr> > > </table> > > <!-- body_eof //--> > > <!-- footer //--> > > <?php require('includes/footer.php'); ?> > > <!-- footer_eof //--> > > </body> > > </html> > > <?php > > ?> > > > >> Seeing the page might help. > >> On Nov 1, 2004, at 2:52 AM, Garth Hapgood - Strickland wrote: > >> > >>> I have written a registration page in php and have a number of edit > >>> boxes > >>> and drop-down lists. The lists are pulling data out of their > >>> respective > >>> tables, whereas the edit boxes are just for saving data. > >>> > >>> Now my main table where all my data is being saved is called > >>> Business. > >>> Onto > >>> this I have a table called BusinessCommunication which has the fields > >>> (BusinessCommunicationID, BusinessID, CommunicationTypeID, > >>> Destination). > >>> > >>> BusinessCommunicationID = Primary Key > >>> BusinessID = Foreign key from Business Table > >>> CommunicationTypeID = Foreign key from CommunicationType table (lists > >>> all > >>> communication types) > >>> Destination = field where data is stored (tel number, email address > >>> or > >>> fax > >>> number etc) > >>> > >>> Now the problem is that I want the person registering to be able to > >>> select > >>> the Communication Type/s he wants to add and then be able to enter > >>> the > >>> relevant information for each selected CommType. There must also be > >>> ability > >>> to add 2 of the same CommType. > >>> > >>> How can I achieve this as simply and affective as possible on my > >>> registration page. > >>> > >>> If you have any solutions are need more information. Please let me > >>> know > >>> > >>> Many thanx > >>> Garth > >>> > >>> -- > >>> PHP General Mailing List (http://www.php.net/) > >>> To unsubscribe, visit: http://www.php.net/unsub.php > >>> > >>> > >> -dg > >> http://www.rexruff.com > -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Psimax MailScanner mailto:support|at|psimax|dot|co|dot|za -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
