Hi,
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.
The php code is
PHP Code:
<?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>"; } ?>
Any help would be much appriciated,
Thanks,
Colin
|