table row does not appear

Jim_Madrid

I have a script embedded in a table cell. When the script is executed and there is an error message (which appears in the cell as well) the last row of the table does not appear. If the script is executed and all information is submitted correctly (i.e. no error messages) the last row of the table appears just fine.

Any ideas of why the row does not appear if there are error messages?

Thanks

<?php include ('connlogin.php');?>
<html>
<head>
<title>Fauna Database Registration</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<?php
require_once 'function3.php';

$first_name = $POST['first_name'];
$last_name = $POST['last_name'];
$email_address = $POST['email_address'];
$password = $POST['password'];
$password2 = $POST['password2'];
$username = $POST['username'];

$first_name = stripslashes($first_name);
$last_name = stripslashes($last_name);
$email_address = stripslashes($email_address);
$username = stripslashes($username);

// has the form been submitted?
if (isset($POST['submit'])) {
// the form has been submitted
// perform data checks.
$sql_email_check = mysql_query("SELECT email_address FROM users WHERE email_address='$email_address'");
$sql_username_check = mysql_query("SELECT username FROM users WHERE username='$username'");
$email_check = mysql_num_rows($sql_email_check);
$username_check = mysql_num_rows($sql_username_check);
$error_str = ''; // initialise $error_str as empty
if (empty($POST['first_name'])) $error_str .= '<li>You did not enter your first name</li>';
if (empty($POST['last_name'])) $error_str .= '<li>You did not enter your last name</li>';
if (empty($POST['email_address'])) $error_str .= '<li>You did not enter your E-mail address</li>';
if (empty($POST['username'])) $error_str .= '<li>You did not enter your desired username</li>';
if (empty($POST['password'])) $error_str .= '<li>You did not enter your desired password</li>';
// more checks
if ($POST['password'] != $POST['password2']) $error_str .= '<li>Your passwords do not match.</li>';
if (!preg_match("/.@...*/", $POST['email_address']) | preg_match("/(<|> )/", $POST['email_address'])) $error_str .= '<li>Invalid E-mail address</li>';
if ($email_check > 0) $error_str .= '<li>E-mail address already in use, select another.</li>';
if ($username_check > 0) $error_str .= '<li>Username already in use, select another.</li>';
// we could also strip any HTML from the variables, convert it to entities, have a maximum character limit on the values, etc etc, but this is just an example.
// now, have any of these errors happened? We can find out by checking if $error_str is empty
if (!empty($error_str)) {
// errors have occured, halt execution and show form again.
echo '<div align="center">There were errors in the information you entered, they are listed below:</div>';
echo '<ul>'.$error_str.'</ul>';
// show form again
user_form();
exit; // die
}
$sql = mysql_query("INSERT INTO USERS (first_name, last_name, email_address, username, password, signup_date)
VALUES('$first_name', '$last_name', '$email_address', '$username', '$password', now())") or die (mysql_error());

if(!$sql){
echo 'There has been an error creating your account. Please contact the webmaster.';
user_form();
} else {
echo ' Successfully submitted, please <a href="IAM_login.php">login </a> now';
}
}
?>
</td>
</tr>
<tr bgcolor="#009999">
<td colspan="2" valign="top">text......</td>
</tr>
</table>
</body>
</html>

jpmoriarty

probably because your using die(), which, understandably, is pretty fatal and stops running your script. Why not have a look at it's definition in the manual.

also, it helps greatly if you can surround your code with the php tags - makes it a lot easier to read.

Jim_Madrid

If I remove the exit (), the information submitted is posted to the database even if there are errors. How can I alter the statement to maintain visible the last row of the table but yet meet all the criteria before the info is submitted to the database? In other words what should I replace exit() with?

Thanks