CODICE CLASS.php (che contiene le funzioni per collegarsi al DB e fare diverse query)
Codice PHP:
    public function trova_prodotti($soldi)
    {
        if(isset(
$this->attiva))
        {
            
$i=0;
            
$istruzione="SELECT * FROM prodotti WHERE prezzo<='".$soldi."' ";
            
$query=mysql_query($istruzione) or die (mysql_error());
            while(
$dato=mysql_fetch_row($query))
                {
                    
$risposta[$i]=$dato;
                    
$i++;
                }
                return 
$risposta;

        }
        else
            return 
"ERRORE #COD002#";
    } 

CODICE pagina.php
Codice PHP:
 <form method="post" action="../descrizione.php" action="attiva" >
        <?php

            $i
=0;
            
$missioni=$connect->trova_prodotti($cliente[4]);
            if(
count($missioni)>0)
            {
                echo 
"<table width='99%' border='0' cellspacing='2' align='center'>";
                echo 
"<tr><td width='12%' ></td><td width='68%' align='center' style='color:#FFF'>Prodotto</td>";
                echo 
"<td width='10%' style='color:#FFF'>Prezzo</td><td width='10%'></td>";
                echo 
"<tr><td> </td><td> </td><td></td><td> </td></tr>";
        
            }
        
            for(
$i=0;$i<count($missioni); $i++)
               {
                                        
$beh=$missioni[$i];
                    echo 
"<tr><td width='12%'>[img]http://****.it/****/img/**.png[/img]";
                    echo 
"[img]****.it/***/img/".$beh[2].".png[/img]</td>";
                    echo 
"<td width='68%' style='font-weight:bold'>".$beh[1]."</td>";
                    echo 
"<td width='10%' align='center' style='font-weight:bold; color:#FA0'>".$beh[4]."</td>";
                    echo 
"<td width='10%'><input type='submit' value='Acquista'/>";
                    echo 
"<input type='hidden' name='prezzo' value='".$beh[4]."'/><input type='hidden' name='codice' value='".$beh[0]."'/>";
                    echo 
"</td></tr>";
                    
                }

        
            if(
count($missioni)>)
            {
                echo 
"</table>";
            }
        
?>
</form>