Autosuggestion Using PHP,MySQL & Ajax

Index Html/PHP page includes the Request proceed to Next Page.

Location

Database Creation:

-- Table structure for table `countries`

CREATE TABLE `countries` (
`id` int(6) NOT NULL auto_increment,
`value` varchar(250) NOT NULL default '',
PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=243 ;

-- Dumping data for table `countries`
INSERT INTO `countries` VALUES (1, 'Afghanistan');
INSERT INTO `countries` VALUES (2, 'Aringland Islands');
INSERT INTO `countries` VALUES (3, 'Albania');
INSERT INTO `countries` VALUES (4, 'Algeria');
INSERT INTO `countries` VALUES (5, 'American Samoa');
INSERT INTO `countries` VALUES (6, 'Andorra');
INSERT INTO `countries` VALUES (7, 'Angola');
INSERT INTO `countries` VALUES (8, 'Anguilla');
INSERT INTO `countries` VALUES (9, 'Antarctica');
INSERT INTO `countries` VALUES (10, 'Antigua and Barbuda');

Script & Style Code:

Ajax Code:

 real_escape_string($_POST['queryString']);
//$queryString = strtoupper($queryString);
//$queryString = strip_tags($queryString);
//$queryString = trim ($queryString);
if(strlen($queryString) >0) {
$query = $db->query("SELECT *  FROM table_name WHERE field_name  LIKE '$queryString%' LIMIT 10");
if($query) {
while ($result = $query ->fetch_object()) {
echo '
field_name .'\');" style="list-style-type: none;">'.$result->field_name .'
';
}
} else {
echo 'ERROR: There was a problem with the query.';
}
} else {
}
} else {
echo 'There should be no direct access to this script!';
}
}
?>