<?php
//----------------------------------------------------------------
//
// Search page with key word or just word
//
// search.php
//
//----------------------------------------------------------------

$mysql_host = 'localhost'; // enter your host name
$mysql_user = 'login'; // enter your login
$mysql_password = 'password'; // enter your password
$mysql_base = 'database name'; // enter your database name


//You sign in the database
$db = mysql_connect($mysql_host,$mysql_user,$mysql_password) or die ("connexion error");

//you select your database
mysql_select_db($mysql_base,$db) or die ("erreur de connexion
base");


//search request
$req = mysql_query("SELECT * from your_table where mots_cles LIKE '%$_POST[searchword]%' Order by url Asc ") or die ("request error ".mysql_error());

//we count the result
$res= mysql_num_rows($req);

//we show the number of result
print '  There are '.$res.' for '.$searchword.' results <br>';

//----------------------------------------------------------------------
//We show the information by alphabetical order

while( $result = mysql_fetch_array($req))
{

print '<strong>'.$result['name'].'</strong><br / >';
print $result['description'].'<br />';
print'<a href="'.$result['url'].'">'.$rsult['url'].'</a><br / >';
print '-----------------------------------------------------------------'; // it's just a separation line
}//end of the while function

//we close the mysql connection
mysql_close();



?>