Jump to content

Archived

This topic is now archived and is closed to further replies.

87dave87

search every table & partial matches

Recommended Posts

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

[code]
<?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";
}
?>
[/code]

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.