87dave87 Posted September 23, 2006 Share Posted September 23, 2006 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. Quote Link to comment Share on other sites More sharing options...
shocker-z Posted September 23, 2006 Share Posted September 23, 2006 [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 ""RegardsLiam Quote Link to comment Share on other sites More sharing options...
87dave87 Posted September 23, 2006 Author Share Posted September 23, 2006 what isn't equal to ""? Quote Link to comment Share on other sites More sharing options...
shocker-z Posted September 23, 2006 Share Posted September 23, 2006 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.