Compter trier données recherche interne mysql

<?php
echo $value;
$sql ='SELECT * FROM `commerces`'; 
$page_text_query = mysql_query($sql) or die("Query failed");
while($cont = mysql_fetch_array($page_text_query))
{
	echo $cont['Nom'];
	echo '<br />';
	echo $cont['Rue'];
	echo '<br />';
	echo $cont['Telephone'];
	echo '<br />';
	echo $cont['Fax'];
}

while( $cont = mysql_fetch_array($page_text_query) )
{
      echo $cont['Nom'];
      echo '<br />';
      echo $cont['Rue'];
      echo '<br />';
      echo $cont['Telephone'];
      echo '<br />';
      echo $cont['Fax'];
}

SELECT * FROM 'commerces' WHERE 'recherche%' LIKE Activites

<input name=""blabla"/>

var blabla = ?????

	<form method="post" action="ton_script.php">
		<p><input type="text" name="valeur_a_chercher" /></p>
		<p><input type="submit" value="Rechercher" /></p>
	</form>

<?php
	$valeur_a_chercher = mysql_real_escape_string( $_POST['valeur_a_chercher'] );
	$sql = "SELECT `champ1` , `champ2` , `champ3` FROM `table` WHERE `champ_ou_tu_veux_chercher` LIKE '%$valeur_a_chercher%'";
	/* la suite tu connais... */
?>

echo $cont['Rue'];
	echo '';
	echo $cont['Telephone'];
	echo '<>';
	echo $cont['Fax']; ) ?>

$sql = "SELECT `champ1` , `champ2` , `champ3` FROM `table` WHERE `champ_ou_tu_veux_chercher` LIKE '%$valeur_a_chercher%'";

<!-- php codepart 1 here -->
<?php require("libs/dbconnect.php");
 ?>
<!-- php codepart 1 end -->

<?PHP
$valeur = mysql_escape_string ( $_POST['valeur']);
$sql = "SELECT * FROM commerces WHERE MATCH (Nom,Rue,Telephone,Activites) AGAINST ('$valeur')"; 
$page_text_query = mysql_query($sql) or die('Query failed');
while ($cont = mysql_fetch_array($page_text_query, MYSQL_BOTH)) {
printf ('<br />');
printf ($cont['Nom']);
printf ('<br />');
printf ($cont['Rue']);
printf ('<br />');
printf ($cont['Telephone']);
printf ('<br />');
printf ($cont['Fax']);
printf ('<br />');
}
?>

é

string html_entity_decode  ( string $string  [, int $quote_style  [, string $charset  ]] )

html_entity_decode() est la fonction contraire de htmlentities() : elle convertit les entités HTML de la chaîne string en caractères normaux. 

Le paramètre optionnel quote_style vous permet de définir ce qu'il adviendra des guillemets simples et doubles. Ce paramètre prend l'une des valeurs suivantes (et la valeur par défaut est ENT_COMPAT) : 

Tableau 310.  Constantes disponibles pour quote_style 

Constante Description 
ENT_COMPAT Convertit les guillemets doubles et ignore les guillemets simples.  
ENT_QUOTES Convertit les guillemets doubles et les guillemets simples.  
ENT_NOQUOTES Ne convertit aucun guillemet. 

é
à
î

$text_a_chercher = html_entities( $text_a_chercher )

string htmlentities  ( string $string  [, int $quote_style  [, string $charset  [, bool $double_encode  ]]] )

$valeur = htmlentities( $valeur );

Amélie

$valeur = htmlentities( $valeur [, $UTF-8] );

, 'UTF-8'

, $var

$var = 'UTF-8';

<?PHP
$valeur = mysql_escape_string ( $_POST['valeur']);
$var = 'UTF-8';
$replace = html_entity_decode( $valeur , $var );
$sql = "SELECT * FROM commerces WHERE MATCH (Nom,Rue,Telephone,Activites) AGAINST ('$valeur')"; 
echo ($sql);
$page_text_query = mysql_query($sql) or die('Query failed');
echo ($cont[0]);
while ($cont = mysql_fetch_array($page_text_query, MYSQL_BOTH)) {
printf ('<br />');
printf ($cont['Nom']);
printf ('<br />');
printf ($cont['Rue']);
printf ('<br />');
printf ($cont['Telephone']);
printf ('<br />');
printf ($cont['Fax']);
printf ('<br />');
}
?>

Warning: html_entity_decode() expects parameter 2 to be long, string given in C:\xampp\htdocs\portail\recherche.php on line 33
SELECT * FROM commerces WHERE MATCH (Nom,Rue,Telephone,Activites) AGAINST ('')

$valeur = htmlentities( $_POST['valeur'] , ENT_NOQUOTES , 'UTF-8' );
$valeur = mysql_escape_string ( $valeur );
$sql = "SELECT * FROM commerces WHERE MATCH (Nom,Rue,Telephone,Activites) AGAINST ('$valeur')"; 

<a href...>am&eacute;lie</a>

<?PHP
$valeur = htmlentities( $_POST['valeur'] , ENT_NOQUOTES , 'UTF-8' );
$valeur = mysql_escape_string ( $valeur );
$sql = "SELECT * FROM commerces WHERE MATCH (Nom,Rue,Telephone,Activites) AGAINST ('$valeur')"; 
$page_text_query = mysql_query($sql) or die('Query failed');
while ($cont = mysql_fetch_array($page_text_query, MYSQL_BOTH)) {
printf ('<br />');
printf ($cont['Nom']);
printf ('<br />');
printf ('<span class="search">');
printf ($cont['Rue']);
printf ('<br />');
printf ($cont['Telephone']);
printf ('<br />');
printf ($cont['Fax']);
printf ('</span>');
printf ('<br />');
}
?>