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
