Can any body help me.. i have some problem in jquery email validation, i want to check that this email has already registered or not.. i have tried but my code is not working (i.e did not show error message)
here is the script
$(document).ready(function(){
$("add_form").validate( {
rules: {
email: {
required: true,
email: true,
remote: "emails.php"
},
},
messages: {
email: {
remote: jQuery.format("{0} is already in use")
}
},
});
and emails.php file code here
<?php
$request = trim(strtolower($_REQUEST['email']));
require 'db.inc.php';
$db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD) or
die ('Unable to connect. Check your connection parameters.');
mysql_select_db(MYSQL_DB, $db) or die(mysql_error($db));
$query = 'SELECT email FROM Users WHERE email="'.$request.'"';
$result = mysql_query($query, $db) or die(mysql_error());
$valid = 'true';
if (mysql_num_rows($result)>0)
{
$valid = '"Thats already taken."';
}
echo $valid;
?>