Creating search results in a table format

[Deicer]

Hi,
I'm looking to build a search engine, I have a prototype ready, http://www.bkslap.com, but i want to make my own search engine and create a search results page that is in a table format, with results in squares. Does anyone know how this could be done with PHP MySQL and HTML?
thanks,
Any help would be much apperciated!
deicer

[HotNoob]

it would be something a long the lines of:

Code: Select all

<table>
<?php
$query = 'SEARCH QUERY HERE';
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo '<tr><td>'.$row['RESULTS'].'</td></tr>';
}
?>
</table>



something like that; it all depends on your setup and how you want the results outputted tho.

OH and i see you wrote down you needed the mysql stuff for it?
well a basics would just be sometihng along the lines of:
SELECT * FROM `content` WHERE `keywords(orwhatever u want to use)` LIKE '%STRING TO LOOK FOR%'

[HotNoob]

oh yeah, and the '%' character is the wild card character

for example,
if you were to do
'%ike'
you could get 'like' as a result.