Fonction sql pour trouver le nom d'une table

<?php

$dbServer="localhost"; 
$dbName="essai"; 
$User="xxxxxx"; 
$Pwd="xxxxxx"; 
$cnx = mysql_connect($dbServer, $User, $Pwd ); 
$db = mysql_select_db($dbName); 
$valeurcherchee= "jacques";

  $rep = mysql_db_query($dbName,'show tables in essai') or die (mysql_error()); 
  $tbl=array();
  while ($lgn=mysql_fetch_array($rep)) $tbl[]=$lgn[0];
  mysql_free_result($rep);  

  foreach ($tbl as $table) {
    $rep= mysql_db_query($dbName,'SHOW COLUMNS FROM `'.$table.'` FROM '.$dbName) or die (mysql_error());
    $tbcolonnes=array();
    while ($lgn=mysql_fetch_array($rep)) $tbcolonnes[]=$lgn[0];

    foreach ($tbcolonnes as $colonne) {
      $rep= mysql_db_query($dbName,'SELECT * FROM `'.$table.'` WHERE CONCAT(`'.$colonne.
            '`) =\''.mysql_real_escape_string($valeurcherchee).'\'') or die (mysql_error());
      echo " trouvé ",mysql_num_rows($rep), " fois dans la colonne ", htmlspecialchars($colonne), 
           ' de la table ', htmlspecialchars($table),'<BR>';
       mysql_free_result($rep); 
    } // foreach ($tblcolonnes
  } // foreach ($tbl
?>