why don't the results show? (link included)

[87dave87]

http://www.emulators.cc/search.php

On the results page nothing is appearing.

The coding for the search page is: -

[code]<form name="emusearch" method="POST" action="searchresults.php">
  <p>
  <input type="text" name="emusearch" size="20"><input type="submit" value="Submit" name="emusearch"></p>
</form>[/code]

The coding for the results page is: -

[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 = '$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]

[BillyBoB]

i think i have replied to this b4
you do not get the posted info just by say $emusearch

here is how it should be ...

[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]

[87dave87]

yes that works now, but the 'cannot find information' part is still not working.

[BillyBoB]

try this i dont know if it will work

[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]

[87dave87]

No doesn't seem to, just displays 'We cannot find your infomation' no matter what is entered :?