ho fatto come mi hai detto ma la ricerca non estrae alcun risultato
codice:
<?php include('../all/config.php') ?>
<form method="post">
Nome Applicazione:
<input type="text" id="searchesc" />__
<input type="submit" value="Conferma" />
</form>
<?php
if (isset($_POST['searchesc'])) {
$search = $_POST['searchesc'];
trim ($search);
$result = mysql_query("select * from escalation where application like '%".$search."%")
or die(mysql_error());
} else {
$result = mysql_query("select * from escalation ORDER BY application")
or die(mysql_error()); }
?>
<table>
<tr>
<td>Applicativo</td>
<td>Riferimenti</td>
<td>Rep.</span></td>
<td>Note Aggiuntive</td>
<td">Last Upd.</td>
</tr>
<?php while ($row = mysql_fetch_array( $result )) { ?>
<tr>
<td class="application"><?php echo $row['application'];?></td>
<td class="references"><?php echo $row['references'];?></td>
<td class="call"><?php if ($row['call'] == 'SI') { echo "<font color=green>".$row['call']."</font>";} elseif ($row['call'] == '12x7') { echo "<font color=blue>".$row['call']."</font>";} elseif ($row['call'] == 'NO') { echo "<font color=red>".$row['call']."</font>";} else { echo$row['call'];}?></td>
<td class="note"><?php echo $row['note'];?></td>
<td class="updline"><?php echo date("m/d/y G:i", strtotime($row['updline']));?></td>
</tr><?php } ?>
</table>