"; // check name, if less than 2 characters give error if (strlen($yourName) < 2) { $checkValue = true; $errorMessage .= "
  • Your name is required
  • "; } // Ensure your email is in a valid format if (!preg_match('/^[\w-\.\']{1,}\@([\da-zA-Z-]{1,}\.){1,}[\da-zA-Z-]{2,}$/is', $yourEmail)) { $checkValue = true; $errorMessage .= "
  • Your email is required
  • \n"; } // Check hometown if (strlen($hometown) < 2) { $checkValue = true; $errorMessage .= "
  • Your hometown is required
  • "; } // check review if (!$review) { $checkValue = true; $errorMessage .= "
  • Please leave a review
  • "; } // if no errors, add to database if (!$checkValue) { $r = mysql_query(sprintf("INSERT INTO reviews SET yourname='%s', youremail='%s', hometown='%s', review='%s'", mysql_real_escape_string($yourName), mysql_real_escape_string($yourEmail), mysql_real_escape_string($hometown), mysql_real_escape_string($review))); if (!$r) { $checkValue = true; $errorMessage .= "
  • There was an error storing this review in the database: " . mysql_error($r) . "
  • "; } else { // Redirect, to clear out the form. $_SESSION['success'] = "Thank you!
    Your review will appear here shortly."; header("Location: audience-reviews.html"); exit; } } $errorMessage .= ""; } ?> Reviews - Baby It's You! - Official Broadway Site
    Baby Its You Shirelle Heads

    Read our AUDIENCE REVIEWS

    0 ORDER BY id DESC LIMIT 0,10"); if (!mysql_num_rows($result)) { print "

    No reviews have been posted.

    "; } else { while ($data = mysql_fetch_array($result)) { print "
    "; print "" . $data['yourname'] . " from " . $data['hometown'] . " says:"; print "

    " . $data['review'] . "

    "; print "
    "; } } ?>

    WRITE YOUR REVIEW

    " . $_SESSION['success'] . "

    "; unset($_SESSION['success']); } ?>