Jump to content


Photo

search every table & partial matches


  • Please log in to reply
1 reply to this topic

#1 87dave87

87dave87
  • Members
  • PipPipPip
  • Advanced Member
  • 86 posts

Posted 22 September 2006 - 01:42 PM

How can I search every table in my database?

&

How can I make it so the query looks for partial matches.

This is my results page: -

<?php 

$database="mydatabase";
$emusearch = $_POST['emusearch'];
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";
}
?>


#2 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 22 September 2006 - 01:46 PM

SELECT * FROM tablexyz WHERE x LIKE '%partialword%'

And I'd suggest putting all your tables in an array and looping through this array running the query and echoing results but replacing the table name from the array each time.

Info: PHP Manual





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users