Search everywhere

[plasmahba]

Hi!

One question

Is it possible to do somethink like this

SELECT FROM WHERE * LIKE '%$mysearch%'

I know the syntaxis is wrong but how can i express that?

Thanks 4 any help

[trex005]

Ok... I was getting sick of no one responding to you... so I wrote you a program to do this... is there a better way? I do not know...

<?
//connect to database you want to search
$search_query = "test";
$sql = "SHOW TABLES";
$result = mysql_query($sql);
while($row=mysql_fetch_array($result))
{
	$sql2 = "Describe `" . $row[0] . "`";
	$result2 = mysql_query($sql2);
	while($row2 = mysql_fetch_array($result2))
	{
		$final_query_wheres[] = " " . $row2[0] . " LIKE '%" . $search_query . "%' ";
	}
	$sql3 = "SELECT * FROM `" . $row[0] . "` WHERE " . implode(' OR ',$final_query_wheres);
	$result3 = mysql_query($sql3);  // this is the result with the information you wanted
	$final_query_wheres = array();
}
?>