allora ho fatto così:
Codice PHP:
<script type="text/javascript">
<!--
function Menu(links) {
location.href = links[links.selectedIndex].value;
}
//-->
</script>
....
<?php
include_once 'config.php';
$query = "select id,utente from articoli";
$result = mysql_query($query) or die(mysql_error($link));
echo '<select onChange="Menu(this)">';
while ($riga = mysql_fetch_array($result)) {
echo "<option value=utenti.php?id_utente='" . $riga['id'] . "'>" . $riga['utente'] . "</option>";
}
echo '</select>';
?>
la pagina utenti.php è questa:
Codice PHP:
<?php
include_once 'config.php';
$id_utente = $_GET['id_utente'];
$query = "select * from articoli where utente='" . $id_utente . "'";
$result = mysql_query($query, $link) or die(mysql_error($link));
while ($riga = mysql_fetch_assoc($result)) {
echo '<div>[b]' . $riga['title'] . '[/b]</div>';
echo '<div>Sezione: ' . $riga['sectionid'] . '</div>';
echo '<div>Data creazione: ' . date('d-m-Y H:i:s', strtotime($riga['data'])) . '</div>';
if ($riga['data'] != $riga['datamod']) {
echo '<div>Data modifica: ' . date('d-m-Y H:i:s', strtotime($riga['datamod'])) . '</div>';
}
echo '<div>' . $riga['testo'] . '</div>';
echo '[url="modifica.php?id=' . $riga['id'] . '"]Modifica[/url]
';
echo '[url="elimina.php?id=' . $riga['id'] . '"]Elimina[/url]';
echo '<hr />';
}
?>
mi compare questo errore:
codice:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5''' at line 1