Hi again, the code as requested, hope this helps. (If it does at least i'll have learnt something)
Thanks
FF
[PHP]
<form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
<?php
include "dbconn.php";
?>
//<?php
//include "countrylist.php";
//?>
<?php
//NORMALLY THE INCLUDE ABOVE IS USED, Below is the script for the countrylist.php
///////////////////////////////////////////////////////////////////////////////
// Doing my Country table query
$query = 'SELECT c.`printable_name` FROM country c';
$selection = mysql_query($query) or die('Query failed: ' . mysql_error());
$query="SELECT c.`printable_name` FROM country c";
$result = mysql_query ($query);
echo "<select printable_name=country value=''>Country</options>";
while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
echo "<option value=$nt[id]>$nt[printable_name]</option>";
}
echo "</select>";
// Output the resulting info
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";
// Free resultset
mysql_free_result($result);
// Closing connection
//mysql_close($link);
//END OF THE NORMALLY INCLUDED SCRIPT
/////////////////////////////////////////////////////////////////////////////////
?>
[/PHP]
[HTML]
<p>
Business Name:<br />
<input type="text" name= "BusinessName" size="25" maxlength="40" value="" />
</p>
<p>
Web site address(URL):<br />
<input type="text" name= "URL" size="25" maxlength="40" value="" />
</p>
<p>
Email Address:<br />
<input type="text" name= "EmailAddr" size="25" maxlength="40" value="" />
</p>
<p>
Password Min 8 chars:<br />
<input type="text" name= "User_Password" size="12" maxlength="32" value="" />
</p>
<input type="Submit" name="Submit" value="Submit">
</p>
</form>
[/HTML]
[PHP]
<?php
//If Submit pressed
if (isset($_POST['Submit']))
{
//Get the data input from the form above
$BusinessName = $_POST['BusinessName'];
$URL = $_POST['URL'];
$EmailAddr = $_POST['EmailAddr'];
$printable_name = $_POST['Country'];
//Now put the information into the Business details table
$query = "INSERT INTO businessdetails SET BusinessName='$BusinessName', URL='$URL', EmailAddr='$EmailAddr', Country='$printable_name'";
$result = mysql_query($query);
//***********Successfull or Not?******************
if ($result) echo "<p>Details successfully added, Thankyou. </p>";
else echo "<P> Failed to register details<?p>";
//Below is a small test to see what's in the array to be submitted
echo '<pre>';
print_r($_POST);
echo '</pre>';
mysql_close();
}
?>
[/PHP]
5
