missing search results

[cs1h]

Hi,

 

I have this php search script, but when I run it I just get this

 

country:

type:

Abstract:

 

This is the right layout but it is not filling it with results.

The php code is

 

<?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

[recklessgeneral]

Hi Colin,

 

Could you provide the following pieces of information so I can see what's going on a bit better.

 

1. The piece of code that populates $info. It's probably pretty simple but may contain a typo. That's one of my major gripes about PHP so I'm always double checking spelling. I come from a C/C++ background where any typos at least have to be consistent.

 

2. Echo the $sql string to make sure it looks okay and that the fields you're querying actually match data in the database.

 

3. Are you getting any errors from mysql_query? The mysql_error() function is very useful for debugging, though you may want to remove it before going live.

 

Cheers,

Darren.