Searching my data base

[Anon]

Does any one have a simple script that will search a data base and return the items to a page with a link to show the full row of information. Sorry if this is a simple thing I am new to PHP and on a steep learning curve.
Thanks
Harper

[jcornett]

I've done many of these and I've included some generic code below from a news article system I'm currently building:

<?php
// Database connection code goes here
$result = @("SELECT ident, headline from <table_name> where headline LIKE '% $search %'");
While($row = @mysql_fetch_array($result)) {
echo "<a href='details.php?ident=$ident'>$row[headline]</a><br>\n";
}
?>

This will produce a list of matching articles that have the word passed in the $search variable. (I assume your search page has an input tag named "search") On the "details.php" page, you just pull the information for the article matching the "ident" passed to it from the link.

Hope this helps...

John Cornett

[Anon]

Thank you for replying!