Kathy

Hi all! I am REALLY having trouble with this, I have made a drop down, populated it from a database table called categories and a field called Category, I would now like to populate another drop down from a database table called clients and a field called coName, based on the choice one makes in the categories drop down. I do not know how I would go about connecting the two drop downs? I have searched everywhere! Would appreciate any help! Thanks! Here is what I've done so far: $link = mysql_connect("host","link","pass"); mysql_select_db("dbname", $link); $query = "select Category FROM categories"; $results = mysql_query($query, $link) or die("Error performing query"); if(mysql_num_rows($results) > 0){ echo("<select name=\"Category\">"); while($row = mysql_fetch_object($results)){ echo("<option value=\"$row->record_id\">$row->Category</option>"); } echo("</select>"); }/code]

Okay, I've done the following: <? // Connect database $link = mysql_connect("host","login","pass"); mysql_select_db("dbname", $link); $query = "select Category FROM categories"; $results = mysql_query($query, $link) or die("Error performing query"); if(mysql_num_rows($results) > 0){ echo("<select name=\"Category\">"); while($row = mysql_fetch_object($results)){ echo("<option value=\"$row->record_id\">$row->Category</option>"); } echo("</select>"); } ?> I would now like to be able to populate another drop down based on the selection of the above drop down from a table called clients and a field name called coName, I'd appreciate ANY help, thanks!

Something is wrong with this piece of code here: <?PHP while (list($id, $coName) = mysql_fetch_array($result, MYSQL_NUM)) { echo("<option value=\"$id\">$coName</option>"); } echo('</select>'); } } else if (!empty($_POST['category'] && !empty($_POST['coName']))) { $cat = $_POST['category']; $subcat = $_POST['coName']; ..process.. } } ?> I've added another ) after ['coName'], but I'm still receiving this error when I run the script? Parse error: syntax error, unexpected T_BOOLEAN_AND, expecting ')'

Okay great, I've managed to populate my drop down: <?PHP $link = mysql_connect("host","login","pass"); mysql_select_db("dbname", $link); $query = "select Category FROM categories"; $results = mysql_query($query, $link) or die("Error performing query"); if(mysql_num_rows($results) > 0){ echo("<select name=\"Category\">"); while($row = mysql_fetch_object($results)){ echo("<option value=\"$row->record_id\">$row->Category</option>"); } echo("</select>"); } else{ echo("<i>No values found</i>"); }?> I now want to populate another drop down from a choice in this drop down using the WHERE query, can anyone offer me guidance?

I'm being a total newbie here, I've tried it like this, but it's obviously still wrong: <?PHP mysql_connect("dedi536.nur4.host-h.net","ivif09","ivifpa55")or die(mysql_error()); mysql_select_db("web_cat09")or die(mysql_error()); ?> getting the same mysql error I appreciate any help you can give me

Just tried the following: INSERT INTO categories (Category) VALUES (‘Chemicals & Refining Agents’),(‘CIP Systems’),(‘Cleaning’),(‘Equipment & Services’) I get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Agents’),(‘CIP Systems’),(‘Cleaning’),(‘Equipment & Services’)' at line 1 why is this?

That did it! Thanks!

Here is my query: INSERT INTO categories (Category) VALUES ('Bottling Services'),('Brush Cutters'),('Building Construction/Supplies'),('Bulk Wine & Brandy Traders') Is this wrong? ???

I'm veryvery used to PHP, but am wondering if it would be better to do this in Javascript? I'm trying to populate a drop down with a database table called categories and a field called Category, after selecting a category from this drop down, I'd like it to select another drop down from a table called clients and a field called CoName, after picking a company I'd like the company's contact details to be displayed in a way? Any suggestions?

yes, that's what I'm trying to do, tried your suggestion, got the following error: #1062 - Duplicate entry '0' for key 1

I'm trying to insert multiple values into one field in my table using the following statement: INSERT INTO table name (field) VALUES ('type','type','type',type') I'm getting the following error if I do this though: #1136 - Column count doesn't match value count at row 1 Can anybody give me some advice?

Is this right? function select_db(){ mysql_connect("localhost","login","pass")or die(mysql_error()); mysql_select_db("dbname")or die(mysql_error()); } $query = 'SELECT id, Category FROM categories'; $result = mysql_query($query, $db); if ($result) { $htmlSelect = '<select name="category-select">'; while (list($id, $category) = mysql_fetch_array($result, MYSQL_NUM)) { $htmlSelect .= "<option value=\"$id\">$category</option>"; } $htmlSelect .= '</select>'; }

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource I get this when I run it The problem is over here : $result = mysql_query($query, $db); ?

I need to populate a drop down box with a table named categories and a field called Category, how do I go about doing this?? ???

I'm currently using this code $to = 'person@domain.co.za'; $from = $email; $subject = 'Online Registration'; $message = '<body style="font-family:tahoma; font-size:12px; line-height:18px; color:#333366">'. $initials.', '.$surname.', '.$company_name.', '.$address.', '.$address2.', '.$address3.', '.$telephone.', '.$email.', '.$method.', '.$type.', '.$JobFunction. $Reference .'</body>'; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= 'FROM: '. $from . "\r\n"; mail($to, $subject, $message, $headers); to send an email from a file to myself containing filled in information from a form, note that $JobFunction can be a choice of 13 checkboxes. See code below: if(isset($_POST["ch1"])){ $checkbox1 = $_POST["ch1"] . ", "; } if(isset($_POST["ch2"])){ $checkbox2 = $_POST["ch2"] . ", "; } if(isset($_POST["ch3"])){ $checkbox3 = $_POST["ch3"] . ", "; } if(isset($_POST["ch4"])){ $checkbox4 = $_POST["ch4"] . ", "; } if(isset($_POST["ch5"])){ $checkbox5 = $_POST["ch5"] . ", "; } if(isset($_POST["ch6"])){ $checkbox6 = $_POST["ch6"] . ", "; } if(isset($_POST["ch7"])){ $checkbox7 = $_POST["ch7"] . ", "; } if(isset($_POST["ch8"])){ $checkbox8 = $_POST["ch8"] . ", "; } if(isset($_POST["ch9"])){ $checkbox9 = $_POST["ch9"] . ", "; } if(isset($_POST["ch10"])){ $checkbox10 = $_POST["ch10"] . ", "; } if(isset($_POST["ch11"])){ $checkbox11 = $_POST["ch11"] . ", "; } if(isset($_POST["ch12"])){ $checkbox12 = $_POST["ch12"] . ", "; } if(isset($_POST["ch13"])){ $checkbox13 = $_POST["ch13"] . ", "; } $JobFunction = $checkbox1 . $checkbox2 . $checkbox3 . $checkbox4 . $checkbox5 . $checkbox6 . $checkbox7 . $checkbox8 . $checkbox9 . $checkbox10 . $checkbox11 . $checkbox12 . $checkbox13; I would like to change this to a 1 and 0 system, when somebody selects the checkbox it should display as 1, if not, it should display as 0, I cannot get this to work though and have tried to include my radio buttons into this system. $msgheading = "Visitor Registration from website"; $msg = $initials . ","; $msg .= $surname . ","; $msg .= $company . ","; $msg .= $postal . ","; $msg .= $city . ","; $msg .= $code . ","; $msg .= $tel . ","; $msg .= $email . ","; if ($business == 1) { $msg .= "1,0,0,0,"; } if ($business == 2) { $msg .= "0,1,0,0,"; } if ($business == 3) { $msg .= "0,0,1,0,"; } if ($business == 4) { $msg .= "0,0,0,1,"; } if ($owner <> '') { $msg .= "1,"; } else { $msg .= "0,"; } if ($finance <> '') { $msg .= "1,"; } else { $msg .= "0,"; } if ($human <> '') { $msg .= "1,"; } else { $msg .= "0,"; } if ($marketing <> '') { $msg .= "1,"; } else { $msg .= "0,"; } if ($farm <> '') { $msg .= "1,"; } else { $msg .= "0,"; } if ($research <> '') { $msg .= "1,"; } else { $msg .= "0,"; } if ($information <> '') { $msg .= "1,"; } else { $msg .= "0,"; } if ($vitic <> '') { $msg .= "1,"; } else { $msg .= "0,"; } if ($wine <> '') { $msg .= "1,"; } else { $msg .= "0,"; } if ($hospitality <> '') { $msg .= "1,"; } else { $msg .= "0,"; } if ($buying <> '') { $msg .= "1,"; } else { $msg .= "0,"; } if ($other <> '') { $msg .= "1"; } else { $msg .= "0"; } $sendto = "person@domain.co.za"; mail($sendto , $msgheading , $msg , "From: Website"); I can't get it to work though, any suggestions??

Can anybody explain to me or send me links to some tutorials on how to populate a drop down menu with a database? What I ultimately want to achieve is to have a drop down box, containing types of businesses populated from a database and depending on what option you choose from the drop down on clicking an option eg. Bakeries this will then populate another drop down, from here you will choose a company name, eg. Margerie's Baked Goods, on clicking this it will bring up contact information, which I'm guessing should be populated in text fields?

still not sending mail ???

Thanks for that, I've just included it and tested it and this time it hasn't sent out anything at all?

Thanks for that, I inserted it and tried it out, <?php function select_db(){ mysql_connect("dedi536.nur4.host-h.net","winefarmer02","expofarmers2")or die(mysql_error()); mysql_select_db("winafarmers2")or die(mysql_error()); } //check to see if the user clicked on the submit button if (!strcasecmp($_SERVER['REQUEST_METHOD'], 'POST') && !empty($_POST)){ } $initials = $_POST['initials']; $surname = $_POST['surname']; $company_name = $_POST['company_name']; $address = $_POST['address']; $address2 = $_POST['address2']; $address3 = $_POST['address3']; $telephone = $_POST['telephone']; $email = $_POST['email']; $type = $_POST['type']; $method = $_POST['method']; $owner = $_POST['owner']; $finance = $_POST['finance']; $hr = $_POST['hr']; $sales = $_POST['sales']; $fm = $_POST['fm']; $research = $_POST['research']; $is = $_POST['is']; $viticulture = $_POST['viticulture']; $production = $_POST['production']; $retail = $_POST['retail']; $buying = $_POST['buying']; $distribution = $_POST['distribution']; $student = $_POST['student']; $other = $_POST['other']; Unfortunately, it sends the mail on refresh and on the opening of the page.. I cannot believe this.. ???

I also thought that it might have something to do with it, I moved the } around the code a lot and that seemed to change whether or not the mail would send at all and I had no luck with it. It just wouldn't send out any mail. Any idea what could be wrong there?

I really need help I am at the point of pulling out my hair!! I have a php file, it is a registration form, it captures the data, sends it to the database and it is meant to send me an email with all the details that the client has filled in and send the client a confirmation email, anyway, when the script is uploaded onto the server, and tested, an email is delivered to me, empty, as an email is being sent on opening of the page! Or on refresh of the page and not on submitting of the page!! This is soooo wrong! I cannot figure it out I have spent hours and hours and hours on it, I will appreciate any help! Here is my code: <?php function select_db(){ mysql_connect("localhost","farmer","farmer2")or die(mysql_error()); mysql_select_db("farmer2")or die(mysql_error()); } //check to see if the user clicked on the submit button if(isset($_POST["submit"])){ } $initials = $_POST['initials']; $surname = $_POST['surname']; $company_name = $_POST['company_name']; $address = $_POST['address']; $address2 = $_POST['address2']; $address3 = $_POST['address3']; $telephone = $_POST['telephone']; $email = $_POST['email']; $type = $_POST['type']; $method = $_POST['method']; $owner = $_POST['owner']; $finance = $_POST['finance']; $hr = $_POST['hr']; $sales = $_POST['sales']; $fm = $_POST['fm']; $research = $_POST['research']; $is = $_POST['is']; $viticulture = $_POST['viticulture']; $production = $_POST['production']; $retail = $_POST['retail']; $buying = $_POST['buying']; $distribution = $_POST['distribution']; $student = $_POST['student']; $other = $_POST['other']; $JobFunction = $_POST["ch1"] . ", " . $_POST["ch2"] . ", " . $_POST["ch3"] . ", " . $_POST["ch4"] . ", " . $_POST["ch5"] . ", " . $_POST["ch6"] . ", " . $_POST["ch7"] . ", " . $_POST["ch8"] . ", " . $_POST["ch9"] . ", " . $_POST["ch10"] . ", " . $_POST["ch11"] . ", " . $_POST["ch12"] . ", " . $_POST["ch13"]; $JobFunction = str_replace(", ,","",$JobFunction); select_db(); mysql_query("INSERT INTO contact_details (initials, surname, company_name, address, address2, address3, telephone, email, method, type, owner, finance, hr, fm, research, `is`, viticulture, production, retail, buying, distribution, student, other) VALUES ('$initials', '$surname', '$company_name', '$address', '$address2', '$address3', '$telephone', '$email', '$method', '$type', '$owner', '$finance', '$hr', '$fm', '$research', '$is', '$viticulture', '$production', '$retail', '$buying', '$distribution', '$student', '$other')") or die(mysql_error()); mysql_query("INSERT INTO users (JobFunction, DateRegistered, Email) VALUES ('$JobFunction','$DateRegistered','$Email')") or die(mysql_error()); //execute the query //echo $sqlAdd; $UserID = mysql_insert_id(); $Reference = 1000 + mysql_insert_id(); $Reference = "IVIF2009/" . $Reference; $UpdateReference = "UPDATE users SET RefrenceNumber = '$Reference' WHERE DownloadUserID = '$UserID'"; $DoUpdateRefrence = mysql_query($UpdateReference); $to = 'k@exa.co.za'; $from = 'k@exa.co.za'; $subject = 'Online Registration'; $message = '<body style="font-family:tahoma; font-size:12px; line-height:18px; color:#333366">'. $initials.', '.$surname.', '.$company_name.', '.$address.', '.$address2.', '.$address3.', '.$telephone.', '.$email.', '.$method.', '.$type.', '.$JobFunction.', '. $Reference .'</body>'; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= 'FROM: '. $from . "\r\n"; mail($to, $subject, $message, $headers); $to = $email; $from = "k@exa.co.za"; $subject = 'Online Registration at Intervitis-Interfructa Southern Africa'; $message = '<body style="font-family:tahoma; font-size:12px; line-height:18px; color:#333366"><table border=0> <tr> <td><p>Hi There!</p> <p>Thank you for registering online. Your online registration has been confirmed. </p> <p>Your reference is ' . $Reference . '</p> <p>Please note that the exhibition takes place from 28th to 30th July 2009.To assist our staff and speed up your entry ticket retrieval, <strong> please bring this e-mail with you when you visit the show.</strong>Pre-Registration tickets may be collected at the Pre-Registration and Press Ticket Desk.</p> <p>We look forward to your visit!Have a Great Day!</p> <p><img src="http://www.intervitis-interfructa.co.za/images/logo.jpg"></p></td> </tr> </table> </body>'; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= 'FROM: '. $from . "\r\n"; mail($to, $subject, $message, $headers); } //clear all the values $initials = ""; $surname = ""; $company_name = ""; $address = ""; $address2 = ""; $address3 = ""; $telephone = ""; $email = ""; $type = ""; $method = ""; $owner = ""; $finance = ""; $hr = ""; $sales = ""; $fm = ""; $research = ""; $is = ""; $viticulture = ""; $production = ""; $retail = ""; $buying = ""; $distribution = ""; $student = ""; $other = ""; ?> <html> <head> <title>Intervitis Interfructa</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <meta http-equiv="X-UA-Compatible" content="IE=7"/> <meta http-equiv="X-UA-Compatible" content="IE=8"/> <link href="style.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- .style7 {font-size: x-small} .style8 {font-size: xx-small} .style14 {font-size: x-small; font-weight: bold; } .style15 { font-size: 10px; font-weight: bold; } --> </style> <script type="text/JavaScript"> <!-- function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_validateForm() { //v4.0 var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments; for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]); if (val) { nm=val.name; if ((val=val.value)!="") { if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@'); if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n'; } else if (test!='R') { num = parseFloat(val); if (isNaN(val)) errors+='- '+nm+' must contain a number.\n'; if (test.indexOf('inRange') != -1) { p=test.indexOf(':'); min=test.substring(8,p); max=test.substring(p+1); if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n'; } } } else if (test.charAt(0) == 'R') errors += '- '+nm+' is required.\n'; } } if (errors) alert('The following error(s) occurred:\n'+errors); document.MM_returnValue = (errors == ''); } function validate(form){ var errors = []; if ( !checkRadioArray(form.method) ) { errors[errors.length] = "You must choose between production or supplier."; } if ( !checkRadioArray(form.type) ) { errors[errors.length] = "You must choose between wine, fruit, both or other."; } if (errors.length > 0) { reportErrors(errors); return false; } return true; } function checkRadioArray(radioButtons){ for (var i=0; i < radioButtons.length; i++) { if (radioButtons[i].checked) { return true; } } return false; } function reportErrors(errors){ var msg = "There were some problems...\n"; var numError; for (var i = 0; i<errors.length; i++) { numError = i + 1; msg += "\n" + numError + ". " + errors[i]; } alert(msg); } //--> </script> </head> <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <!-- ImageReady Slices (Template.psd) --> <form method="post" action="reg_suc.php" onSubmit="return validate(this);"> <table id="Table_01" align="center" width="850" height="883" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="4" background="images/Template_01.gif" height="194"></td> </tr> <tr> <td colspan="2" background="images/Template_02.gif" height="45"></td> <td width="426" height="45" ><div align="left" class="heading"> <div style="color:#f26732;">Online Registration </div> </div></td> <td rowspan="8" class="ragthPanel" width="137" height="424"> </td> </tr> <tr> <td background="images/Template_05.gif" style="background-repeat:no-repeat;" width="218" height="36"> </td> <td colspan="2" rowspan="7" height="379" class="contentCell" valign="top" align="center"> <div id="tabMenu" align="center"><a href="visitor_info.html">Background</a> | <a href="vi_cat.html">Categories</a> | <a href="vi_highlights.html" >Highlights</a><br/> <a href="vi_online_reg.php" style="border-bottom:2px solid #9ccb3d;">Online Registration</a> | <a href="vi_ex_cat.html">Exhibitor Catalogue</a>| <a href="vi_down.php">Downloads</a> |</div> <br> <table width="100%" border="0" cellspacing="3" cellpadding="2"> <tr> <td colspan="4"><div align="center" class="style15">PLEASE FILL IN THE REQUIRED FIELDS * </div></td> </tr> <tr> <td colspan="2"><span class="style7">INITIALS/VOORLETTERS * </span></td> <td colspan="2"> <input name="initials" type="text" value="<?php echo $initials; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">SURNAME/VAN * </span></td> <td colspan="2"><input name="surname" type="text" value="<?php echo $surname; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">COMPANY/MAATSKAPPY * </span></td> <td colspan="2"><input name="company_name" type="text" value="<?php echo $compnay_name; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">POSTAL ADDRESS/POSADRES * </span></td> <td colspan="2"><input name="address" type="text" id="address" value="<?php echo $address; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7"> CITY/STAD * </span></td> <td colspan="2"><input name="address2" type="text" id="address2" value="<?php echo $address2; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">CODE/KODE * </span></td> <td colspan="2"><input name="address3" type="text" id="address3" value="<?php echo $address3; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">(CODE) TEL NO/ * <br> (KODE) TEL NR. </span></td> <td colspan="2"><input name="telephone" type="text" id="telephone" value="<?php echo $telephone; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">E-MAIL/E-POS * </span></td> <td colspan="2"><input name="email" type="text" value="<?php echo $email; ?>"></td> </tr> <tr> <td colspan="4"><hr></td> </tr> <tr> <td colspan="4"><div align="center"><span class="style15">TICK AT LEAST ONE FIELD * </span></div></td> </tr> <tr> <td><span class="style7">PRODUCTION OF/PRODUKSIE VAN </span></td> <td><input name="method" type="radio" value="production"></td> <td><span class="style7">WINE/WYN </span></td> <td><input name="type" type="radio" value="wine"></td> </tr> <tr> <td><span class="style7">SUPPLIER TO/VERSKAFFER AAN </span></td> <td><input name="method" type="radio" value="supplier"></td> <td><span class="style7">FRUIT/VRUGTE</span></td> <td><input name="type" type="radio" value="fruit"></td> </tr> <tr> <td> </td> <td> </td> <td><span class="style7">BOTH/BYDE</span></td> <td><input name="type" type="radio" value="both"></td> </tr> <tr> <td> </td> <td> </td> <td><span class="style7">OTHER/ANDER</span></td> <td><input name="type" type="radio" value="ander"></td> </tr> <tr> <td colspan="4"><hr></td> </tr> <tr> <td><span class="style14">JOB FUNCTION/WERKS FUNKSIE </span></td> <td><div align="center"></div></td> <td><div align="center"><span class="style15">TICK AT LEAST ONE FIELD * </span></div></td> <td> </td> </tr> <tr> <td><div align="right"><span class="style7">OWNER/MD/CHAIRMAN</span></div></td> <td><div align="center"> <input name="ch1" type="checkbox" id="owner" value="owner"> </div></td> <td colspan="2"><span class="style7">EIENAAR/BD/VOORSITTER</span></td> </tr> <tr> <td><div align="right"><span class="style7">FINANCE/ADMINISTRATION</span></div></td> <td><div align="center"> <input name="ch2" type="checkbox" id="finance" value="finance"> </div></td> <td colspan="2"><span class="style7">FINANSIES/ADMINISTRASIE</span></td> </tr> <tr> <td><div align="right"><span class="style7">HUMAN RESOURCES </span></div></td> <td><div align="center"> <input name="ch3" type="checkbox" id="hr" value="hr"> </div></td> <td colspan="2"><span class="style7">MENSLIKE HULPBRONNE </span></td> </tr> <tr> <td><div align="right"><span class="style7">FARM MANAGEMENT </span></div></td> <td><div align="center"> <input name="ch4" type="checkbox" id="fm" value="fm"> </div></td> <td colspan="2"><span class="style7">BOERDERY BESTUUR </span></td> </tr> <tr> <td><div align="right"><span class="style7">RESEARCH/LABORATORY</span></div></td> <td><div align="center"> <input name="ch5" type="checkbox" id="research" value="research"> </div></td> <td colspan="2"><span class="style7">NAVORSING/LABORATORIUM</span></td> </tr> <tr> <td><div align="right"><span class="style7">INFORMATION SYSTEMS </span></div></td> <td><div align="center"> <input name="ch6" type="checkbox" id="is" value="is"> </div></td> <td colspan="2"><span class="style7">INLIGTING STELSELS </span></td> </tr> <tr> <td><div align="right"><span class="style7">VITICULTURE</span></div></td> <td><div align="center"> <input name="ch7" type="checkbox" id="viticulture" value="viticulture"> </div></td> <td colspan="2"><span class="style7">WINGERDBOU</span></td> </tr> <tr> <td><div align="right"><span class="style7">WINEMAKER/PRODUCTION</span></div></td> <td><div align="center"> <input name="ch8" type="checkbox" id="production" value="production"> </div></td> <td colspan="2"><span class="style7">WYNMAKER/PRODUKSIE</span></td> </tr> <tr> <td><div align="right"><span class="style7">HOSPITALITY/RETAIL</span></div></td> <td><div align="center"> <input name="ch9" type="checkbox" id="retail" value="retail"> </div></td> <td colspan="2"><span class="style7">GASVRYHEIDSBEDRYF/KLEINHANDEL</span></td> </tr> <tr> <td><div align="right"><span class="style7">BUYING</span></div></td> <td><div align="center"> <input name="ch10" type="checkbox" id="buying" value="buying"> </div></td> <td colspan="2"><span class="style7">AANKOPE</span></td> </tr> <tr> <td><div align="right"><span class="style7">DISTRIBUTION/WAREHOUSING</span></div></td> <td><div align="center"> <input name="ch11" type="checkbox" id="distribution" value="distribution"> </div></td> <td colspan="2"><span class="style7">VERSPREIDING/BERGING</span></td> </tr> <tr> <td><div align="right"><span class="style7">STUDENT</span></div></td> <td><div align="center"> <input name="ch12" type="checkbox" id="student" value="student"> </div></td> <td colspan="2"><span class="style7">STUDENT</span></td> </tr> <tr> <td><div align="right"><span class="style7">OTHER</span></div></td> <td><div align="center"> <input name="ch13" type="checkbox" id="other" value="other"> </div></td> <td colspan="2"><span class="style7">ANDER</span></td> </tr> <tr> <td colspan="4"><center> <hr> <br> <input name="submit" type="submit" id="submit" onClick="MM_validateForm('initials','','R','surname','','R','company_name','','R','address','','R','address2','','R','address3','','RisNum','telephone','','R','email','','RisEmail');return document.MM_returnValue" value="Submit"> <br> <hr> </center></td> </tr> <tr> <td colspan="4"><div align="center"><span class="style8">Disclaimer: Right of admission reserved. By completing this ticket and entering the show, I agree to be contacted in a business capacity via INTERVITIS INTERFRUCTA Southern Africa database </span></div></td> </tr> </table> </td> </tr> <tr><td background="images/Template_07.gif" width="218" height="27" style="background-repeat:no-repeat;"><div class="homeLink"><a href="background.html">Home</a></div></td></tr> <tr><td background="images/Template_08.gif" width="218" height="27" style="background-repeat:no-repeat;"><div class="menuLinks"><a href="background.html">Exhibition Details</a></div></td></tr> <tr><td class="menuCell" width="218" height="27" style="background-repeat:no-repeat;"><div class="menuLinks"><a href="why_exhib.html">Exhibition Information</a></div></td></tr> <tr> <td class="menuCell" width="218" height="27"> <div class="menuLinks"><a href="contact.php">Contact Us </a></div></td> </tr> <tr valign="top"> <td class="menuCell" width="218" height="27"> <div class="menuLinks"><a href="visitor_info.html" style="color:#f26732; font-weight:bold;">Visitor Information </a></div></td> </tr> <tr> <td width="218" height="100" class="laftCell"> <img src="images/spacer.gif" width="1" height="240" alt=""></td> </tr> <tr> <td colspan="4" align="center"> <div style="font-family:'Trebuchet MS', tahoma, Verdana, Arial; font-size:12px; padding:20px 0px 20px 0px;">© 2008 Exalon Dynamic Systems</div> </td> </tr> <tr> <td> <img src="images/spacer.gif" width="218" height="1" alt=""></td> <td width="128"> <img src="images/spacer.gif" width="127" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="368" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="137" height="1" alt=""></td> </tr> </table> </form> <!-- End ImageReady Slices --> </body> </html>

Okay, thanks! I've corrected the "submit" button error. But I'm still stuck on nothing happening.... ???

I don't understand, what else would it be? As this is my button's code and I haven't named my button anything else? Is this the reason why nothing is working? <input type="submit" name="Submit" value="Submit">

I haven't got a clue what I'm doing wrong! I've made a registration form, added all the php I though necessary, linked the database and when you enter code on it, nothing happens, the entries clear, the emails, don't send, and the data doesn't get saved into the database! So frustrating!!! Here is my code: <?php include("dbinc.php"); require("ClassMathGuard.php"); include("checkUser.php"); //add a hit $addHit = "insert into hit(last_modified, page) values(CURDATE(), 'submit')"; mysql_query($addHit, $con); //check to see if the user clicked on the register button if(isset($_POST["submit"])) { //check the mathguard if (MathGuard :: checkResult($_POST['mathguard_answer'], $_POST['mathguard_code'])) { //get the values from the form $initials = $_POST['initials']; $surname = $_POST['surname']; $company = $_POST['company']; $address = $_POST['address']; $city = $_POST['city']; $code = $_POST['code']; $tel = $_POST['tel']; $email = $_POST['email']; $production = $_POST['production']; $supplier = $_POST['supplier']; $wine = $_POST['wine']; $fruit = $_POST['fruit']; $both = $_POST['both']; $ander = $_POST['ander']; $owner = $_POST['owner']; $finance = $_POST['finance']; $hr = $_POST['hr']; $sales = $_POST['sales']; $fm = $_POST['fm']; $research = $_POST['research']; $is = $_POST['is']; $viticulture = $_POST['viticulture']; $production = $_POST['prodcution']; $retail = $_POST['retail']; $buying = $_POST['buying']; $distribution = $_POST['distribution']; $student = $_POST['student']; $other = $_POST['other']; if (isset($_POST['Submit'])) { $selected_radio = $_POST['method']; if ($selected_radio == 'production') { $production_status = 'checked'; } else if ($selected_radio == 'supplier') { $supplier_status = 'checked'; } } if (isset($_POST['Submit'])) { $selected_radio = $_POST['type']; if ($selected_radio == 'wine') { $wine_status = 'checked'; } if ($selected_radio == 'fruit') { $fruit_status = 'checked'; } if ($selected_radio == 'both') { $both_status = 'checked'; } else if ($selected_radio == 'ander') { $ander_status = 'checked'; } } //check that the required fields have been filled in if (($surname <> '') && ($cell <> '') && ($email <> '') && ((isset($production)) || (isset($supplier)) || (isset($wine)) || (isset($fruit)) || (isset($both)) || (isset($ander)) || (isset($owner)) || (isset($finance)) || (isset($hr)) || (isset($sales)) || (isset($fm)) || (isset($research)) || (isset($is)) || (isset($viticulture)) || (isset($production)) || (isset($retail)) || (isset($buying)) || (isset($distribution)) || (isset($student)) || (isset($other)))) { //insert the user into the database $add = "insert into contact_details(initials, surname, email, , company_name, address, address2, address3, address4, city, code, tel, email)"; $add .= " values('$surname', '$cell', '$email', '$production', '$supplier', '$wine', '$fruit', '$both', '$ander', '$owner', '$finance', '$hr', '$sales', '$fm', '$research', '$is', '$viticulture', '$production', '$retail', '$buying', '$distribution', '$student', '$other', '$second')"; mysql_query($add, $con); echo mysql_error($con); //send an email notification of the registration $subject = "New User Registered on Intervitis Interfructa"; $to = "info@info.co.za"; $msg = "A new user registered on info.co.za with the following detials:\r\n\r\n"; $msg = "Initials = " . $initials . "\r\n"; $msg = "Surname = " . $surnmae . "\r\n"; $msg = "Company = " . $company . "\r\n"; $msg = "Address = " . $address . "\r\n"; $msg = "City = " . $city . "\r\n"; $msg = "Code = " . $code . "\r\n"; $msg = "Tel = " . $tel . "\r\n"; $msg = "Email = " . $email . "\r\n"; $msg = "Production = " . $production . "\r\n"; $msg = "Supplier = " . $supplier . "\r\n"; $msg = "Wine = " . $wine . "\r\n"; $msg = "Fruit = " . $fruit . "\r\n"; $msg = "Both = " . $both . "\r\n"; $msg = "Ander = " . $ander . "\r\n"; $msg = "Owner = " . $owner . "\r\n"; $msg = "Finance = " . $finance . "\r\n"; $msg = "HR = " . $hr . "\r\n"; $msg = "Sales = " . $sales . "\r\n"; $msg = "Farm Management = " . $fm . "\r\n"; $msg = "Research = " . $research . "\r\n"; $msg = "Information Systems = " . $is . "\r\n"; $msg = "Viticulture = " . $viticulture . "\r\n"; $msg = "Production = " . $production . "\r\n"; $msg = "Retail = " . $retail . "\r\n"; $msg = "Buying = " . $buying . "\r\n"; $msg = "Distibution = " . $distribution . "\r\n"; $msg = "Student = " . $student . "\r\n"; $msg = "Other = " . $other . "\r\n\r\n"; mail($to, $subject, $msg); //send a mail to the client $clientSubject = "Welcome to info.co.za"; $clientTo = $email; $clientMsg = "<html> <head> <title>Online Registration - info.co.za</title> </head> <body style='color:#000000; font-family:verdana, helvetica, sans serif; font-size:12px;'> <p>Hi there " . rtrim($initial, $surname) . "!</p> <p>Thank you for your registering online to visit info.co.za Southern Africa. Your online registration has been confirmed. Your reference is 2009/ //creates a unique ID with a random number as a prefix - more secure than a static prefix $c = uniqid (rand (),true); echo $c; echo '<br>'; </p> <p>Please note that the exhibition takes place in halls 2,3 and 4 of the International Convention Centre and will be open daily between 10h00 and 18h00 from 28th to 30th July 2009.</p> <p>To assist our staff and speed up your entry ticket retrieval, <strong> please bring this e-mail with you when you visit the show. </strong></p> <p>Pre-Registration tickets may be collected at the Pre-Registration and Press Ticket Desk, situated to the right of the entrance to Hall 2 of the International Convention Centre.</p> <p>We look forward to your visit!</p> <p>Have a great day!</p> <table style='font-size:10px; width::200px; color:#000080; font-family:calibri, verdana, helvetica, sans serif; font-size:12px;'> <tr> <td colspan='2'> <img src='http://www.info.co.za/ivif/images/logo.jpg' width='192' height='82' alt='' /></td> </tr> <tr> </body> </html> "; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n"; $headers .= "From: info@info.co.za" . "\r\n"; $headers .= "Reply-To: info@info.co.za" . "\r\n"; $headers .= "Cc: info@info.co.za" . "\r\n"; mail($clientTo, $clientSubject, $clientMsg, $headers); //thank them for registerring and inform them how its going to work $goodErr = "Thank you for registering. You may now log in."; //clear all the values $initials = ""; $surname = ""; $company = ""; $address = ""; $city = ""; $code = ""; $tel = ""; $email = ""; $production = ""; $supplier = ""; $wine = ""; $fruit = ""; $both = ""; $ander = ""; $owner = ""; $finance = ""; $hr = ""; $sales = ""; $fm = ""; $research = ""; $is = ""; $viticulture = ""; $production = ""; $retail = ""; $buying = ""; $distribution = ""; $student = ""; $other = ""; } else { $badErr = "Please fill in all the fields marked with an asterisk."; } } else { //insert your code which tells the user he is spamming your website $badErr = "Your answer to the mathguard question was incorrect, please try again."; } } ?> <html> <head> <form method="POST"> <title>Intervitis Interfructa</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link href="style.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- .style7 {font-size: x-small} .style8 {font-size: xx-small} .style11 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; } .style14 {font-size: x-small; font-weight: bold; } --> </style> </head> <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <!-- ImageReady Slices (Template.psd) --> <table id="Table_01" align="center" width="850" height="883" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="4" background="images/Template_01.gif" width="850" height="194"></td> </tr> <tr> <td colspan="2" background="images/Template_02.gif" width="345" height="45"></td> <td width="368" height="45" ><div align="left" class="heading"> <div style="color:#f26732;">Online Registration </div> </div></td> <td rowspan="8" class="ragthPanel" width="137" height="424"> </td> </tr> <tr> <td background="images/Template_05.gif" width="218" height="36"> </td> <td colspan="2" rowspan="7" width="495" height="379" class="contentCell" valign="top" align="center"> <div id="tabMenu" align="center"><a href="visitor_info.html">Background</a> | <a href="vi_cat.html">Categories</a> | <a href="vi_highlights.html" >Highlights</a><br/> <a href="vi_online_reg.php" style="border-bottom:2px solid #9ccb3d;">Online Registration</a> | <a href="vi_ex_cat.html">Exhibitor Catalogue</a>| <a href="vi_down.php">Downloads</a> |</div> <br> <table width="100%" border="0" cellspacing="3" cellpadding="2"> <tr> <td colspan="2"><span class="style7">INITIALS/VOORLETTERS</span></td> <td colspan="2"><input name="initials" type="text" id="<?php echo $initials; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">SURNAME/VAN</span></td> <td colspan="2"><input name="surname" type="text" id="<?php echo $surname; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">COMPANY/MAATSKAPPY</span></td> <td colspan="2"><input name="company" type="text" id="<?php echo $company; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">POSTAL ADDRESS/POSADRES </span></td> <td colspan="2"><textarea name="address" rows="4" id="<?php echo $address; ?>"></textarea></td> </tr> <tr> <td colspan="2"><span class="style7">CITY/STAD</span></td> <td colspan="2"><input name="city" type="text" id="<?php echo $city; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">CODE/KODE</span></td> <td colspan="2"><input name="code" type="text" id="<?php echo $code; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">(CODE) TEL NO/<br> (KODE) TEL NR. </span></td> <td colspan="2"><input name="tel" type="text" id="<?php echo $tel; ?>"></td> </tr> <tr> <td colspan="2"><span class="style7">E-MAIL/E-POS</span></td> <td colspan="2"><input name="email" type="text" id="<?php echo $email; ?>"></td> </tr> <tr> <td colspan="4"><hr></td> </tr> <tr> <td><span class="style7">PRODUCTION OF/PRODUKSIE VAN </span></td> <td><input name="method" type="radio" value="production"><?PHP print $production_status; ?></td> <td><span class="style7">WINE/WYN</span></td> <td><input name="type" type="radio" value="wine"><?PHP print $wine_status; ?></td> </tr> <tr> <td><span class="style7">SUPPLIER TO/VERSKAFFER AAN </span></td> <td><input name="method" type="radio" value="supplier"><?PHP print $supplier_status; ?></td> <td><span class="style7">FRUIT/VRUGTE</span></td> <td><input name="type" type="radio" value="fruit"><?PHP print $fruit_status; ?></td> </tr> <tr> <td> </td> <td> </td> <td><span class="style7">BOTH/BYDE</span></td> <td><input name="type" type="radio" value="both"><?PHP print $both_status; ?></td> </tr> <tr> <td> </td> <td> </td> <td><span class="style7">OTHER/ANDER</span></td> <td><input name="type" type="radio" value="ander"><?PHP print $ander_status; ?></td> </tr> <tr> <td colspan="4"><hr></td> </tr> <tr> <td><span class="style14">JOB FUNCTION/WERKS FUNKSIE </span></td> <td><div align="center"></div></td> <td> </td> <td> </td> </tr> <tr> <td><div align="right"><span class="style7">OWNER/MD/CHAIRMAN</span></div></td> <td><div align="center"> <input name="ch1" type="checkbox" id="owner" value="owner"> </div></td> <td colspan="2"><span class="style7">EIENAAR/BD/VOORSITTER</span></td> </tr> <tr> <td><div align="right"><span class="style7">FINANCE/ADMINISTRATION</span></div></td> <td><div align="center"> <input name="ch2" type="checkbox" id="finance" value="finance"> </div></td> <td colspan="2"><span class="style7">FINANSIES/ADMINISTRASIE</span></td> </tr> <tr> <td><div align="right"><span class="style7">HUMAN RESOURCES </span></div></td> <td><div align="center"> <input name="ch3" type="checkbox" id="hr" value="hr"> </div></td> <td colspan="2"><span class="style7">MENSLIKE HULPBRONNE </span></td> </tr> <tr> <td><div align="right"><span class="style7">FARM MANAGEMENT </span></div></td> <td><div align="center"> <input name="ch4" type="checkbox" id="fm" value="fm"> </div></td> <td colspan="2"><span class="style7">BOERDERY BESTUUR </span></td> </tr> <tr> <td><div align="right"><span class="style7">RESEARCH/LABORATORY</span></div></td> <td><div align="center"> <input name="ch5" type="checkbox" id="research" value="research"> </div></td> <td colspan="2"><span class="style7">NAVORSING/LABORATORIUM</span></td> </tr> <tr> <td><div align="right"><span class="style7">INFORMATION SYSTEMS </span></div></td> <td><div align="center"> <input name="ch6" type="checkbox" id="is" value="is"> </div></td> <td colspan="2"><span class="style7">INLIGTING STELSELS </span></td> </tr> <tr> <td><div align="right"><span class="style7">VITICULTURE</span></div></td> <td><div align="center"> <input name="ch7" type="checkbox" id="viticulture" value="viticulture"> </div></td> <td colspan="2"><span class="style7">WINGERDBOU</span></td> </tr> <tr> <td><div align="right"><span class="style7">WINEMAKER/PRODUCTION</span></div></td> <td><div align="center"> <input name="ch8" type="checkbox" id="production" value="production"> </div></td> <td colspan="2"><span class="style7">WYNMAKER/PRODUKSIE</span></td> </tr> <tr> <td><div align="right"><span class="style7">HOSPITALITY/RETAIL</span></div></td> <td><div align="center"> <input name="ch9" type="checkbox" id="retail" value="retail"> </div></td> <td colspan="2"><span class="style7">GASVRYHEIDSBEDRYF/KLEINHANDEL</span></td> </tr> <tr> <td><div align="right"><span class="style7">BUYING</span></div></td> <td><div align="center"> <input name="ch10" type="checkbox" id="buying" value="buying"> </div></td> <td colspan="2"><span class="style7">AANKOPE</span></td> </tr> <tr> <td><div align="right"><span class="style7">DISTRIBUTION/WAREHOUSING</span></div></td> <td><div align="center"> <input name="ch11" type="checkbox" id="distribution" value="distribution"> </div></td> <td colspan="2"><span class="style7">VERSPREIDING/BERGING</span></td> </tr> <tr> <td><div align="right"><span class="style7">STUDENT</span></div></td> <td><div align="center"> <input name="ch12" type="checkbox" id="student" value="student"> </div></td> <td colspan="2"><span class="style7">STUDENT</span></td> </tr> <tr> <td><div align="right"><span class="style7">OTHER</span></div></td> <td><div align="center"> <input name="ch13" type="checkbox" id="other" value="other"> </div></td> <td colspan="2"><span class="style7">ANDER</span></td> </tr> <tr> <td colspan="4"><hr></td> </tr> <tr> <td colspan="4"><div align="center" class="style11"> <p> <?php MathGuard::insertQuestion(); ?> <br/> (This is to prevent spam programs from sending hundreds of fake requests)<br> <br> </p> </div></td> </tr> <tr> <td colspan="4"><center> <hr> <br> <input type="submit" name="Submit" value="Submit"> <br> <hr> </center></td> </tr> <tr> <td colspan="4"><div align="center"><span class="style8">Disclaimer: Right of admission reserved. By completing this ticket and entering the show, I agree to be contacted in a business capacity via INTERVITIS INTERFRUCTA Southern Africa database </span></div></td> </tr> </table><?php if($badErr <> "") { ?> <?php } if($goodErr <> "") { ?> <p align="center"><?php echo $badErr; ?> <?php echo $goodErr; ?></p> <?php } ?> <?php echo $err; ?> </td> </tr> <tr> <td background="images/Template_07.gif" width="218" height="27"> <div class="homeLink"><a href="background.html">Home</a></div></td> </tr> <tr> <td background="images/Template_08.gif" width="218" height="27"> <div class="menuLinks"><a href="background.html">Exhibition Details</a></div></td> </tr> <tr> <td class="menuCell" width="218" height="27"> <div class="menuLinks"><a href="why_exhib.html">Exhibition Information</a></div></td> </tr> <tr> <td class="menuCell" width="218" height="27"> <div class="menuLinks"><a href="contact.php">Contact Us </a></div></td> </tr> <tr> <td class="menuCell" width="218" height="27"> <div class="menuLinks"><a href="visitor_info.html" style="color:#f26732; font-weight:bold;">Visitor Information </a></div></td> </tr> <tr> <td width="218" height="414" class="laftCell"> <img src="images/spacer.gif" width="1" height="240" alt=""></td> </tr> <tr> <td colspan="4" align="center"> <div style="font-family:'Trebuchet MS', tahoma, Verdana, Arial; font-size:12px; padding:20px 0px 20px 0px;">© 2008 Exalon Dynamic Systems</div> </td> </tr> <tr> <td> <img src="images/spacer.gif" width="218" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="127" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="368" height="1" alt=""></td> <td> <img src="images/spacer.gif" width="137" height="1" alt=""></td> </tr> </table> <!-- End ImageReady Slices --> </form> </body> </html>

By nothing I mean, after typing in anything, like g in the password text box, where you are meant to type apple, and f in the email text box, the boxes will clear themselves and it's almost like the page, just reloads itself? No error's come up and no redirecting takes place Here is my code: <? //submit form $action = $_POST["Submit"]; if ($action == 'Send') $email = $_POST["initials"]; //check for password if ($_POST['password'] == 'ivif09/107') { //gain access } //funciton to validate and email address if (empty($_POST['email'])) { $errors[] = 'Please enter an e-mail'; } else if (!eregi("^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,3})$", $_POST['email'])) { $errors[] = 'Please enter a valid e-mail address'; } //insert your code that will be executed when user enters the correct answer $email = $_POST['email']; $password = $_POST['password']; $exhibitor_manual = $_POST['exhibitor_manual']; $furniture_catalogue = $_POST['furniture_catalogue']; $order_form_xl = $_POST['order_form_xl']; $order_form_pdf = $_POST['order_form_pdf']; $buyers_guide = $_POST['buyers_guide']; $floor_plan = $_POST['floor_plan']; if (($email <> '') && ($password <> '')){ $add_email = "Select email from login"; $added = mysql_query($add_email); echo mysql_error(); $add_email = "Insert into contact_details(email) "; $add_email .= "value('$email')"; $enter_email = mysql_query($add_email); echo mysql_error(); header("Location: http://www.redirect"); // $msgheading = "Exhibitor Login"; $msg .= "email = " . $email . "\n\r"; $msg .= "password = " . $password . "\n\r"; $msg .= "exhibitor_manual = " . $exhibitor_manual . "\n\r"; $msg .= "furniture_catalogue = " . $furniture_catalogue . "\n\r"; $msg .= "order_form_xl = " . $order_form_xl . "\n\r"; $msg .= "order_form_pdf = " . $oder_form_pdf . "\n\r"; $msg .= "buyers_guide = " . buyers_guide . "\n\r"; $msg .= "floor_plan = " . floor_plan . "\n\r"; $sendto = "ivifinfo@iemail.co.za"; mail($sendto , $msgheading , $msg , "From: Website"); echo "<script language='Javascript'>alert ('Thank you for your query, you will be redirected to the download page')</script>"; } ?>