[PHP]Penso che sia errata la query

[stefano3804]

ho risolto cosi :

<?
include "config.php";
$db = mysql_connect("$server", "$username", "$password");
mysql_select_db("$database",$db);
$sql_recipe = "Select * from main WHERE id='$_GET[id]'";
if (!$exec_recipe = mysql_query($sql_recipe))
{
            cs_AddHeader();
            echo "

" . MSG_RECIPE_NO_RETRIEVE ."
\n" . mysql_error();
            cs_AddFooter();
            exit();
        }
        while ($data = mysql_fetch_object($exec_recipe)) 
        {
            echo "<h2>$data->name</h2>\n";
            if (!empty($data->image)) 
            {
                echo "<div align=center><img src=\"images/$data->image\" alt=\"$data->name\"></div>\n";
            } 
            
            echo "

" . 'Portata' . ": $data->dish\n";
            echo "
" . 'Ingrediente Principale' . ": $data->mainingredient\n";
            echo "
" . 'Numero di Persone' . ": $data->people\n";
            echo "
" . 'Origine' . ": $data->origin\n";
            echo "
" . 'Stagione Consigliata' . ": $data->season\n";
            echo "
" . 'Tempo di preparazione' . ": $data->time\n";
            echo "
" . 'Difficoltà' . ": \n";
            for ($i = 1; $i <= $data->difficulty; $i++) 
            {
                echo "*";
            }
            echo "
" . 'Vino suggerito' . ": $data->wines\n";
            echo "
" . 'Ingredienti' . ": ". nl2br($data->ingredients) ."\n";
            echo "
" . 'Descrizione' . ": ". nl2br($data->description) ."\n";
            echo "
" . 'Note' . ": $data->notes\n";
        }
        
        exit();
        
        
    
?>