estrarre i dati tramite id dalla tab principale

[rocco.mod]

ti posto l intero script cosi lo capisci meglio

if(isset($_GET['page']) && $_GET['details'] == "ticket"){
$id_ticket = isset($_GET['id'])?$_GET['id']:'';
$numer_tiket = isset($_GET['numer_tiket'])?$_GET['numer_tiket']:'';


$DB->connect();
$estrazione_ticket = mysql_query("SELECT * FROM ticket_general WHERE id = $id_ticket ORDER BY  id DESC");
$controllo_presenza_ticket =mysql_num_rows($estrazione_ticket);





?>

<div>


<table  class ='tableviewlistticket' border='0' cellpadding='0' cellspacing='0'>
  <tr>
    <td class='bordsinistrolistticket'></td>
    <td class='centrolistticket'>
<?php if($controllo_presenza_ticket >0){
         while($array = mysql_fetch_array($estrazione_ticket)){/*apro il ciclo while*/
         
         
$estrazione_priorita          = mysql_query("SELECT * FROM priority       WHERE id ='".$array['priority']."' AND enable ='1' ");
$estrazione_department        = mysql_query("SELECT * FROM depart         WHERE id ='".$array['department']."' ");
$estrazione_stato             = mysql_query("SELECT * FROM ticket_stato   WHERE statoid ='".$array['status']."' ");  







//$estrazione_ticketmessage     = mysql_query("SELECT * FROM ticket_message WHERE ticketid ='".$array['id']."' ");//da guardare
//$estrazione_user              = mysql_query("SELECT * FROM user           WHERE id ='".$array['userid']."'  AND stato 1   LIMIT 1");
//$estrazione_staff             = mysql_query("SELECT * FROM staff          WHERE id ='".$array['staffid']."' AND stato 1   LIMIT 1");
//$estrazione_admin             = mysql_query("SELECT * FROM amministrator  WHERE id ='".$array['adminid']."' AND stato 1   LIMIT 1");

?>







<table  class='detailticket' border='0' cellpadding='0' cellspacing='0'>
  <tr>
     <td>
 
 
 
 
 <table class='titleticket'>
  <tr>
     <td><?php echo $array['subject'];?></td>
 </tr>
</table>



    </td>
  </tr>
   <tr>
      <td>
      
      
      
      <fieldset class='swiftfieldset'>
            <legend><?php echo"Detail ticket";?> </legend>
 <table class='detailticket' border='0' cellpadding='0' cellspacing='0'>
   <tr>
      <td class='tddetailticket'>[b]<?php echo"Ticket ID:";?> [/b]</td >
      <td class='detailtickettd'><?php echo $array['ref'];?></td>
      <td class='tddetailticket'>[b]<?php echo"Status:";?>[/b]</td>
      <td class='detailtickettd'><?php  while($array=mysql_fetch_array($estrazione_stato)){
      echo"<font color='".$array['statofontcolor']."'>".$array['statonome']."</font>";
      }?>
      </td>
   </tr>
    <tr>
       <td class='tddetailticket'>[b]<?php echo"Department:"; ?>[/b] </td>
       <td class='detailtickettd'><?php while($array=mysql_fetch_array($estrazione_department)){echo $array['depart_nome'];}?></td>
       <td class='tddetailticket'>[b]<?php echo"Priority:"; ?>[/b]</td>
       <td class='detailtickettd'><?php while($array=mysql_fetch_array($estrazione_priorita)){
       echo"<font color='".$array['font_colore']."'>".$array['nome_priority']."</font>";
       }?>
       </td>
    </tr>
 <?php   
 $DB->connect();
 $estrazione_ticket_time = mysql_query("
 SELECT id , timestamp_opened ,timestamp_lastreply_user , timestamp_lastreply_staff , timestamp_lastreply_admin 
 FROM ticket_general 
 WHERE id = $id_ticket 
 ORDER BY  id DESC");
 $array = mysql_fetch_array($estrazione_ticket_time);

 ?>

     <tr>
        <td class='tddetailticket'>[b]<?php echo"Created On:"; ?> [/b]</td>
        <td class='detailtickettd'><?php echo $array['timestamp_opened']; ?></td>
        <td class='tddetailticket'>[b]<?php echo"Last Update:"; ?>[/b]</td>
        <td class='detailtickettd'><?php //if($verific_disponibil_rispost >0){while($array=mysql_fetch_array($controllo_reply)){echo $array['data_risposta'];}}?>
        </td>
     </tr>
</table>
      </fieldset>
              

              
              
              
              
              
            </td>
         </tr>
          <tr>
              <td>
              
              
              
<?php 
$DB->connect();
$verifica_propieta = mysql_query("
SELECT * 
FROM impostazioni  
WHERE user_cange_status_depart  = 1 
OR user_cange_status_depart     = 1 
OR user_cange_status_priority   = 1 ");
if(@mysql_num_rows($verifica_propieta)== 1){
?>
     <fieldset class='swiftfieldset'>
       <legend><?php echo"Edit Properties"; ?></legend>
<table class='uploadprioritytable' border='0' cellpadding='0' cellspacing='0'>
<?php   
//$verifica_upload_department = mysql_query("SELECT * FROM impostazioni    WHERE user_cange_status_depart  = 1 ");
//if(@mysql_num_rows($verifica_upload_department)==1){?>

  <tr>
      <td  class='tduploadprioritytable'></td>
      <td  class='tduploadprioritytableselect'>
      <select name='depart' id='depart' class='selectprioritdepart' >
<?php 
$DB->connect();
$estrazione_dipartimento = mysql_query("SELECT * FROM depart WHERE enable ='1'  ORDER BY id ASC");
$controllo_dipartimento = mysql_num_rows($estrazione_dipartimento);
if($controllo_dipartimento >0){while($array=mysql_fetch_array($estrazione_dipartimento)){
echo"<option value='".$array['id']."'>".$array['depart_nome']."</option>";}}
else{echo"<option value=''>Non SONO PRESENTI CAT</option>";}?>
       </select>
       </td>
        <td  class='tduploadprioritytable'></td>
    </tr>
                <?php //}
//$verifica_upload_priority = mysql_query("SELECT * FROM impostazioni    WHERE user_cange_status_priority   = 1 ");
//if(@mysql_num_rows($verifica_upload_priority)==1){
?>
   <tr>
      <td  class='tduploadprioritytable'></td>
      <td  class='tduploadprioritytableselect'>
      <select name='priority' id='priority' class='selectprioritdepart' >
<?php
$DB->connect();
$estrazione_priorita = mysql_query("SELECT * FROM  priority WHERE enable = '1' ORDER BY id ASC");
$controllo_priorita = mysql_num_rows($estrazione_priorita);
if($controllo_priorita >0){while($array=mysql_fetch_array($estrazione_priorita)){
echo"<option class='priorityoption' style='color:".$array['font_colore']."' value='".$array['id']."'>".$array['nome_priority']."</option>";}}
else{echo"<option value=''>Non SONO PRESENTI CAT</option>";} 
?>    </select>
      </td>
       <td  class='tduploadprioritytable'></td>
   </tr>
<?php //}
//$verifica_upload_stats = mysql_query("SELECT * FROM impostazioni    WHERE user_cange_status_status    = 1 ");
//if(@mysql_num_rows($verifica_upload_stats)==1){
?>
   <tr>
      <td  class='tduploadprioritytable'></td>
      <td  class='tduploadprioritytableselect'>
      <select name='status' id='status' class='selectprioritdepart' >
<?php
$DB->connect();
$estrazione_stato = mysql_query("SELECT * FROM ticket_stato WHERE statoenable ='1' ORDER BY statoid ASC");
$controllo_stato = mysql_num_rows($estrazione_stato);
if($controllo_stato >0){
while($array=mysql_fetch_array($estrazione_stato)){
echo"<option  style='color:".$array['statofontcolor']."' value='".$array['statoid']."'>".$array['statonome']."</option>";
}
}else{echo"<option value=''>Non SONO PRESENTI CAT</option>";}?> 
    </select>
    </td>
     <td  class='tduploadprioritytable'></td>
   </tr>
 <?php //}?>
    <tr>
       <td  class='tduploadprioritytable'></td>
       <td  class='tduploadprioritytableselect'><input type='submit' name='' value='Upload' class='replicaticket'></td>
       <td  class='tduploadprioritytable'></td>
    </tr>
</table>
     </fieldset>
<?php }?>





       </td>
   </tr>
    <tr>
      <td>
      
      
      
      
      
      
<table class='bottonesubmit'>
   <tr>
      <td><input type ='submit' name=''value='Rispondi' class='replicaticket'></td>
   </tr>
</table>






      </td>
   </tr>
    <tr>
       <td>
       
       
       
       
       
       <?php
echo bbcode_format($var);



$estrazione_ticket = mysql_query("
SELECT *
FROM ticket_message 
WHERE ticketid ='".$array['id']."' 
AND  userid = 1
OR  staffid = 1
OR  adminid = 1
");//da guardare
$array = mysql_fetch_array($estrazione_ticket);

//$estrazione_user  = mysql_query("SELECT * FROM user           WHERE id ='".$array['userid']."'  AND stato 1   LIMIT 1");
//$estrazione_staff = mysql_query("SELECT * FROM staff          WHERE id ='".$array['staffid']."' AND stato 1   LIMIT 1");
//$estrazione_admin = mysql_query("SELECT * FROM amministrator  WHERE id ='".$array['adminid']."' AND stato 1   LIMIT 1");

echo "record estratti dalla query: ".mysql_num_rows($estrazione_ticket);



?>
<table class='conversationtable' border='0' cellpadding='0' cellspacing='0'>
  <tr>
    <td>
    
    
<table  class='titlelistticketconversation' border='0' cellpadding='0' cellspacing='0'>
  <tr>
      <td>Conversazione</td>
  </tr>
</table>

    </td>
  </tr>
   <tr>
     <td>
     
     
<table  class='contenutoticketconversation' border='0' cellpadding='0' cellspacing='0'>
   <tr>
     <td class='tdnomeautore'><table  class='titleimg'border='0' cellpadding='0' cellspacing='0'>
   <tr>
     <td class='nomeautore'><?php  $array['userid'];  ?></td>
     <td class='nomeautoreimagine'><?php // echo"[img]$path_site/template/$template/images/icone_mini/img_user.gif[/img]";?></td>
   </tr>
</table>


     </td>
  </tr>
   <tr>
       <td class='dataticket'><?php //echo"[img]$path_site/template/$template/images/icone_mini/icon_emailopen.gif[/img]".$array['data_apertura']."";?> </td>
  </tr>
   <tr>
       <td class='messticket'><?php echo bbcode_format($array['message']);?> </td>
   </tr>
</table>
                 <?php //}?>
                    <?php /*
$controllo_reply =  mysql_query("select  *  from ticket_risposte where id_ticket ='$id' and numer_ticket='$numer_tiket'  order by id asc ");
$verific_disponibil_rispost =mysql_num_rows($controllo_reply);
if($verific_disponibil_rispost >0){
while($array=mysql_fetch_array($controllo_reply)){*/
?>
<table  class='titlelistticketconversation' border='0' cellpadding='0' cellspacing='0'>
   <tr>
      <td>Conversazione</td>
   </tr>
</table>

     </td>
   </tr>
    <tr>
      <td> 
      
<table  class='contenutoticketconversation' border='0' cellpadding='0' cellspacing='0'>
  <tr>
    <td class='tdnomeautore'><table  class='titleimgtd' border='0' cellpadding='0' cellspacing='0'>
  <tr>
    <td class='nomeautore'><?php //echo $array['autore_risposta'];?></td>
    <td class='nomeautoreimagine'><?php /*
$query = "SELECT `cat_autore` as `cat_autore` FROM `ticket_risposte` WHERE `id`='".$array['id']."' and  `numer_ticket` ='".$array['numer_ticket']."' ";
$handle = mysql_query($query);
$verific_autore_replay = mysql_result($handle, 'cat_autore');
switch ($verific_autore_replay) {
    case 1:
    default:
        echo "[img]$path_site/template/$template/images/icone_mini/img_user.gif[/img]";
        break;
    case 2:
        echo "[img]$path_site/template/$template/images/icone_mini/img_staff.gif[/img]";
        break;
    
} */?>
     </td>
   </tr>
</table>
       </td>
     </tr>
      <tr>
         <td class='dataticket'><?php //echo"[img]$path_site/template/$template/images/icone_mini/icon_emailopen.gif[/img]".$array['data_risposta']."";?></td>
      </tr>
       <tr>
          <td class='messticket'><?php //echo bbcode_format($array['risposta']);?></td>
       </tr>
</table>
<?php 
//}

?>  </td>  
     </tr>
    </table>

           </td>
          </tr>
        </table>
<?php 
} /*chiudo il ciclo while*/
}
else
{
echo"non sono presenti ticket";//quando non ci sono tichket
}
?>
    </td>
    <td class='borddestrolistticket'></td>
  </tr>
</table>

</div>