[Resolu]requete avec jointure

$result = mysql_query("(SELECT item_id,name, weight, material, crystal_type FROM `etcitem` WHERE `name` LIKE '%$sstring%' ORDER BY name) UNION (SELECT item_id,name,weight, material,crystal_type FROM `weapon` WHERE `name` LIKE '%$sstring%' ORDER BY name) UNION (SELECT item_id,name,weight, material,crystal_type FROM `armor` WHERE `name` LIKE '%$sstring%' ORDER BY name )  ");

mais je voudrai metre le resultat sur plusieur page

tout ce que je sais

$total= nombre de resultat trouver lor de la requete
$MombreParPage=nombre par page

$NombreDePages = ceil($total / $MombreParPage);

if (isset($_GET['p']))
{
$p = intval($_GET['p']);
}
else
{
$p = 1;
}
//On affiche les pages 1-2-3, etc.
echo 'Page : ';
for ($i = 1 ; $i <= $NombreDePages ; $i++)
{
    if ($i == $p) //On ne met pas de lien sur la page actuelle
    {
    echo $i;
    }
    else
    {
    echo '
        <a href="test.php?p='.$i.'">'.$i.'</a>
  ';
    }
}

$premier = ($p - 1) * $;

mais la est le souci je n'y arrive pas je ne c'es pas ou metre la limite


ici la requete a delimité par

LIMIT ' . $premier . ', ' . $MombreParPage .'

(SELECT ....) UNION (SELECT ...) UNION (SELECT...) LIMIT 10, 10

<?php

session_start();

$L2JBS_config["mysql_host"]="localhost";    // MySQL IP
$L2JBS_config["mysql_db"]="bdere";        //
$L2JBS_config["mysql_login"]="";        // MySQL Login name   
$L2JBS_config["mysql_password"]="";
//connection a la BD
mysql_connect($L2JBS_config["mysql_host"],$L2JBS_config["mysql_login"],$L2JBS_config["mysql_password"]) or die('Cannot connet to MySQL Server. Please edit the config .');
mysql_select_db($L2JBS_config["mysql_db"]) or die('Cannot find chusen databse. Please edit the config.');

error_reporting(0);

$sstring = mysql_real_escape_string($_POST['item']);

 
if (empty($sstring))
  {
    "au resultat trouver <a href='index.php'>back to search</a>";
    }else{
   
$trio = mysql_query("(SELECT item_id,name, weight, material, crystal_type FROM `etcitem` WHERE `name` LIKE '%$sstring%' ORDER BY name) UNION (SELECT item_id,name,weight, material,crystal_type FROM `weapon` WHERE `name` LIKE '%$sstring%' ORDER BY name) UNION (SELECT item_id,name,weight, material,crystal_type FROM `armor` WHERE `name` LIKE '%$sstring%' ORDER BY name)  ")or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());


$contenu = mysql_num_rows($trio);

if ($contenu == 0) {
    "$lang_noresult<br><a href='index.php'>$back</a>";
}else{


$total = $contenu ;
$MembreParPage = 100;
$NombreDePages = ceil($total / $MembreParPage);


if (isset($_GET['p']))
{
$p = intval($_GET['p']);
}
else
{
$p = 1;
}
//On affiche les pages 1-2-3, etc.
echo '<table style="margin-bottom:10px;"><tr><td width="50">Page : </td>';

for ($i = 1 ; $i <= $NombreDePages ; $i++)
{
    if ($i == $p) //On ne met pas de lien sur la page actuelle
    {
    echo '<td>'.$i.'</td>';
    }
    else
    {
    echo '<td><a href="?page=search-i&p='.$i.'">'.$i.'</a></td>
  ';
    }
}
echo'</tr></table>';

$premier = ($p - 1) * $MembreParPage;


$result = mysql_query("(SELECT item_id,name, weight, material, crystal_type FROM `etcitem` WHERE `name` LIKE '%$sstring%' ORDER BY name) UNION (SELECT item_id,name,weight, material,crystal_type FROM `weapon` WHERE `name` LIKE '%$sstring%' ORDER BY name) UNION (SELECT item_id,name,weight, material,crystal_type FROM `armor` WHERE `name` LIKE '%$sstring%' ORDER BY name ) LIMIT ".$premier." ,".$MembreParPage." ")or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());


echo "<table border=\"1\" width='95%' align='center'>";
echo "<tr  class='text'>
<td height=\"30\" width='2%'>$lang_pic</td>
<td width='60%'>$lang_name</td>
<td width='2%'>$lang_grade</td>
<td>weight</td>
<td>material</td>
</tr>";
while ($row = mysql_fetch_array($result,MYSQL_NUM)){
    $id =$row[0];
    $name = $row[1];
    $weight=$row[2];
    $material=$row[3];
    $grade =$row[4];

    echo "<tr>
    <td><img src='database/images/items/$id.gif' /></td>
    <td>  <a href='?page=detailsitem&item=$id'>$name</a></td>
    <td align='center'><img src='database/images/grades/$grade.gif'/></td>
    <td align='center'>$weight</td>
    <td>  $material</td>
    </tr>";
}
echo "</table>";
}
}
?>

<?php session_start();

if (isset($_POST['login']))
{
   $_SESSION['login'] = $_POST['login']; // addslashes si !get_magic_quotes_gpc
   echo '<a href="index.php?p=' . (isset($_GET['p']) ? (int)$_GET['p'] : 0) . '">Changer de page ' . $_SESSION['login'] . ' ?</a>';
   exit();
}
?>
<form action="index.php" method="post">
<input name="login" type="text" />
<input type="submit" name="submit" value="OK" />
</form>

il(isset($_POST['item'])
{ $_SESSION['item'] =$_POST['item'];
}
$sstring= mysql_real_escape_string($_SESSION['item']);

session-start()