php/mysql-id in baza de date,dar afisare text

[Netul]

<?
$sql = "select * from produse ORDER by id_produs ASC LIMIT 20";
$result = mysql_query ($sql);
while($row = mysql_fetch_array($result))
    { 
        $id_produs=$row["id_produs"];
        $nume_produs=$row["$nume_produs"];
        $oferta=$row["oferta"];
        
        if ($oferta==1)
        {
        ?>
        <table>
            <tr>
            <td bgcolor="red">
                    <? echo $nume_produs;?><br>    
            </td>
            </tr>
        </table>        
        <?    
        }
    }
?>