I have this php search script, but when I run it I just get this
This is the right layout but it is not filling it with results.country:
type:
Abstract:
The php code is
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']) : '';
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
}
{
//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>";
}
?>Thanks,
Colin