query select

[elixir1349]

Ecco il codice intero:

<form action="insert.php" method="post">
[b]Nome[/b]<input type="text" name="Nome">
[b]Numero[/b]<input type="text" name="Numero">
<input type="Submit">
</form>

<?php   
echo "<table border='1' style='border-collapse: collapse;border-color: silver;'>";   
echo "<tr style='font-weight: bold;'>";   
echo "<td width='auto' bgcolor=”#7FFFD4″>[i]ID<i/></td>";   
echo "<td width='auto' >[i]Nome<i/></td>"; echo "<td width='auto' ></td>"; 
echo "<td ></td>"; 
echo "</tr>";  

define('DB_NAME', 'forms1'); 
define('DB_USER', 'root'); 
define('DB_PASSWORD', ''); 
define('DB_HOST', 'localhost');  
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {     
    die('Could not connect: ' . mysql_error()); }   
$db_selected = mysql_select_db(DB_NAME, $link); 
if (!$db_selected) {
     die('Can\'t use ' . DB_NAME . ': ' . mysql_error()); }  

$Nome = $_POST['Nome'];
$Numero = $_POST['Numero'];  
$sql = mysql_query("SELECT * FROM demo WHERE Autore LIKE '%$Nome%' AND Titolo LIKE '%$Numero%' ORDER BY autore") or die(mysql_error());    

while($row=mysql_fetch_array($sql)){      

echo "<tr>";     
echo "<td width='auto' bgcolor=”#FF0000 ″>" . "". "[b]"  . $row[0] . "". "<b/>". "</td>";     
echo "<td width='auto'>" . "" . $row[1] . "" . "</td>";     
echo "<td width='auto'>". "</td>";     
echo "<td width='auto'>" . "". "[i]" . $row[2] . "<i/>". "" . "</td>";          
echo "</tr>";           
} 
mysql_close(); 
?>