Hi,
I'm getting the following error message,
Parse error: syntax error, unexpected $end in D:\Inetpub\vhost\myroho.com\httpdocs\asearching.php on line 34
The php script is as follows,
<?php
// Connects to your Database
mysql_connect("localhost", "adder", "clifford") or die(mysql_error()) ;
mysql_select_db("real") or die(mysql_error()) ;
$country = isset($_POST['menuFilesDMA']) ? preg_replace('/[^a-zA-Z0-9\ ]/', '', $_POST['menuFilesDMA']) : '';
$type = isset($_POST['Type']) ? preg_replace('/[^a-zA-Z0-9\ ]/', '', $_POST['Type']) : '';
$Abstract = isset($_POST['keyword']) ? preg_replace('/[^a-zA-Z0-9\ ]/', '', $_POST['keyword']) : '';
$where = array();
if ($country) {
$where[] = "country='$country'";
}
if ($type) {
$where[] = "type='$type'";
}
if ($Abstract ) {
$where[] = "Abstract LIKE '%$Abstract%'";
}
if ($where) {
$sql = "SELECT * FROM items WHERE " . implode(' AND ', $where);
// query and display results
while($info = mysql_fetch_array( $data ))
{
//Outputs the image and other data
Echo "<b>country:</b> ".$info['country'] . "<br> ";
Echo "<b>type:</b> ".$info['type'] . " <br>";
Echo "<b>Abstract:</b> ".$info['Abstract'] . " <hr>";
}
?>
I am new to php and cannot see what my error might be,
Any help would be much appriciated,
Thanks
Colin
