<?php
include("includes/db.php");
$string = mysql_real_escape_string(urldecode($_GET['q']));

if(strlen($string)< 4)
{
	echo "Please Enter More Of a Phase Or Catch Phase";
}
else
{
	// START CHECK
	$query = mysql_query ( "SELECT * FROM engine" );
	while ( $row = mysql_fetch_assoc ( $query ) )
	{
		print_r ( $row );
		echo '<br /><br />';
	}
	// END CHECK

	echo "SELECT * FROM engine WHERE `keyword` LIKE '%$string%'<br />";

	$query = mysql_query("SELECT * FROM engine WHERE `keyword` LIKE '%$string%'") or die (mysql_error());

	echo mysql_num_rows ( $query );

	while($row = mysql_fetch_assoc($query))
	{
		$name = $row['name'];
		$deciption = $row['deciption'];
		$website_url = $row['website_url'];
		$link = $row['random_link'];
		echo "<div align='left'>";
		echo "$name<br />";
		echo "$deciption<br />";
		echo "<a herf='$link'>$website_url</a>";
		echo "<p />";
	}
}
?>