error trapping on search input box

[87dave87]

I am trying to create a search box which queries my database tables and if the text entered into the input box is the same as the field 'emulator' then it will return the results of the entire row.

The following code works except when text is entered which doesnt match the 'emulator' field: -

[code]
<?php  
$database="mydatabase";  
mysql_connect ("localhost", "user", "pass");  
@mysql_select_db($database) or die( "Unable to select database");
$sql = mysql_query("select * from windows_atari2600 where emulator = '$_POST[emusearch]'");
if(isset($sql)){
while ($get_info = mysql_fetch_row($sql)) {  
  echo "<tr>";  
  foreach ($get_info as $field) echo "<td>$field</td>\n";
  echo "</tr>\n";
}
}else{
  echo "<tr>";
  echo "We cannot find your infomation.";
  echo "</tr>\n";
}
?>
[/code]


I have also tried the following code but now the results arent shown and any text entered into the input box returns 'We cannot find your information'

[code]
<?php  
$database="mydatabase";  
mysql_connect ("localhost", "user", "pass");  
@mysql_select_db($database) or die( "Unable to select database");
$sql = mysql_query("select * from windows_atari2600 where emulator = '$_POST[emusearch]'");
if($sql==""){
while ($get_info = mysql_fetch_row($sql)) {  
  echo "<tr>";  
  foreach ($get_info as $field) echo "<td>$field</td>\n";
  echo "</tr>\n";
}
}else{
  echo "<tr>";
  echo "We cannot find your infomation.";
  echo "</tr>\n";
}
?>
[/code]

Any help would be greatly appreciated.

[shocker-z]

[code]<?php 
$database="mydatabase"; 
mysql_connect ("localhost", "user", "pass"); 
@mysql_select_db($database) or die( "Unable to select database");
$sql = mysql_query("select * from windows_atari2600 where emulator = '$_POST[emusearch]'");
if($sql !== ""){
while ($get_info = mysql_fetch_row($sql)) { 
  echo "<tr>"; 
  foreach ($get_info as $field) echo "<td>$field</td>\n";
  echo "</tr>\n";
}
}else{
  echo "<tr>";
  echo "We cannot find your infomation.";
  echo "</tr>\n";
}
?>[/code]


need to check that it is NOT eual to ""

Regards
Liam

[87dave87]

what isn't equal to ""?

[shocker-z]

you put
$sql = mysql_query("select * from windows_atari2600 where emulator = '$_POST[emusearch]'");
if($sql == ""){


but your checking if $sl if equal to nothing then display the data.. but if nothing then no data to display so you need to check that it isnt nothing therefore data returned from query then echo that data.. just try what i put..


Liam