Yeah, I noticed that last night before I went to bed - The field that is turning up empty is a drop down box (something which I've never done before) so you select an option from a list of places. But it's not passing the selection on.
I guess i'll have to look in to the dropdown boxes/forms side of thing later on.
The form:
<html>
<head>
<link rel="stylesheet" type="text/css" href="stylesheet.css" />
<title>Paint-Zone</title>
</head>
<form action="fields.php" method="post">
Enter the name of the field: <input type="text" name="name" /><br />
Enter the location of the field:
<select name="Location"><br />
<option value="Birmingham">Birmingham</option>
<option value="Manchester">Manchester</option>
<option value="London">London</option>
<option value="North Yorkshire">North Yorkshire</option>
</select><br />
Enter the phone number of the field: <input type="text" name="number" /><br />
Enter the email address of the field: <input type="text" name="email" /><br />
<label>Type a short summary:<br />
<textarea name="summary" rows="10" cols="40">
</textarea></label>
<input type="submit" value="Go!"/>
</form>
</body>
</html>
The current code:
<html>
<head>
</head>
<body>
<?php
$dbcnx = @mysql_connect('my', 'info', 'here');
if (!$dbcnx) {
echo 'Unable to connect to the ' .
'database server at this time.' ;
exit();
}
// Select the database
if (!@mysql_select_db('paintzone')) {
exit('Unable to locate the ' .
'database at this time.');
}
// Write to the fields
if (isset($_POST['summary'])) {
$name= addslashes(htmlentities($_POST['name']));
$location= addslashes(htmlentities($_POST['location']));
$number= addslashes(htmlentities($_POST['number']));
$email= addslashes(htmlentities($_POST['email']));
$summary= addslashes(htmlentities($_POST['summary']));
$sql = "INSERT INTO fields VALUES($name, $location, $number, $email, $summary)";
if (@mysql_query($sql)) {
echo 'The field has been added';
} else {
echo '<p>Error adding submitted review: ' .
mysql_error() . '</p>';
}
}
// Query All entries
$result = @mysql_query('SELECT * FROM fields');
if (!$result) {
echo ('<p>Error performing query: ' .
mysql_error() . '</p>');
}
else
{
$number_of_records = mysql_num_rows($result);
$name = mysql_result($result,$number_of_records-1,"name");
$location = mysql_result($result,$number_of_records-1,"location");
$number = mysql_result($result,$number_of_records-1,"number");
$email = mysql_result($result,$number_of_records-1,"email");
$summary = mysql_result($result,$number_of_records-1,"summary");
echo '<table width="600" cellspacing="0" border="2"><tr><td><center>' .$name .'</center></td><td><center>' .location .'<br /></center></td></tr><tr><td colspan="2"><center> ' .$number .' <br /><br /></center></td></tr><tr><td colspan="2"><center>' .$email .'</center></td></tr><tr><td colspan="2"><center>' .$summary .'</center></td></tr></table><br /><br /><br />';
$name = mysql_result($result,$number_of_records-2,"name");
$location = mysql_result($result,$number_of_records-2,"location");
$number = mysql_result($result,$number_of_records-2,"number");
$email = mysql_result($result,$number_of_records-2,"email");
$summary = mysql_result($result,$number_of_records-2,"summary");
echo '<table width="600" cellspacing="0" border="2"><tr><td><center>' .$name .'</center></td><td><center>' .location .'<br /></center></td></tr><tr><td colspan="2"><center> ' .$number .' <br /><br /></center></td></tr><tr><td colspan="2"><center>' .$email .'</center></td></tr><tr><td colspan="2"><center>' .$summary .'</center></td></tr></table><br /><br /><br />';
$name = mysql_result($result,$number_of_records-3,"name");
$location = mysql_result($result,$number_of_records-3,"location");
$number = mysql_result($result,$number_of_records-3,"number");
$email = mysql_result($result,$number_of_records-3,"email");
$summary = mysql_result($result,$number_of_records-3,"summary");
echo '<table width="600" cellspacing="0" border="2"><tr><td><center>' .$name .'</center></td><td><center>' .location .'<br /></center></td></tr><tr><td colspan="2"><center> ' .$number .' <br /><br /></center></td></tr><tr><td colspan="2"><center>' .$email .'</center></td></tr><tr><td colspan="2"><center>' .$summary .'</center></td></tr></table><br /><br /><br />';
}
?>
</body>
</html>
