Re: Help needed on php/mysql

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">&nbsp;</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