Unexpected syntex error
Posted: Fri Sep 07, 2007 3:04 am
Hi,
I'm getting the following error message,
I am new to php and cannot see what my error might be,
Any help would be much appriciated,
Thanks
Colin
I'm getting the following error message,
The php script is as follows,Parse error: syntax error, unexpected $end in D:\Inetpub\vhost\myroho.com\httpdocs\asearching.php on line 34
Code: Select all
<?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>";
}
?>Any help would be much appriciated,
Thanks
Colin