Mysql search to HTML

[hoops]

Hello,

I'm looking for a simple search script that will pull data from my database and display it in an HTML page. I have found several things on the web, but only a few actually worked correct.

Any help would be appreciated.

 

[Keral_Patel]

PHP

PHP is the answer to your problem

Only thing is one can only write a query if you can show the sample design of the database.

But still to get you started I can write it here.

<?php
//Database connection stuff. Assuming it is already connected.
$results = mysql_query("Select * from tablename WHERE columnname LIKE '%KEYWORD%'");
while ( $rows = mysql_fetch_array ( $results ) )
{
$id = $rows['id'];//if any
$title = $row['title'];//title of link or page name etc.
$desc = $rows['desc'];//description or content etc.
$desc = substr($desc, 0, 50);//To only print 50 characters. Can be changed.
echo "<a href='$page.php?$id'>$title</a><br />$desc<br /><hr><br />";
}//while ends
?>

 

[user-7256]

You could use PHP. You could also use Perl. Or Ruby. Or C#. Just sayin', everyone always jumps to PHP but there *are* others.

 

[enlytend]

Are you looking for information how to code this yourself or are you looking for a script that does it for you? If you're looking for a script, Webmerge may work for you.