Ciao a tutti, ho questo problema, se visualizzo questa pagina:
mi da questo errore:Codice PHP:<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
</head>
<body background="../images/sfondo.jpg">
<?php
session_start();
$prova=$_SESSION["type"];
if($prova=='Amministratore'){
$odbc_dns = "db_forum";
$odbc_userid = "";
$odbc_password = "";
$utente = $HTTP_POST_VARS["utente"];
$query = "SELECT Username, Cognome, Nome, Data_di_nascita, E-mail, Città
FROM Utente
WHERE Username='" . $utente . "'";
if ( !( $odbc_db = odbc_connect($odbc_dns, $odbc_userid, $odbc_password) ) )
die("Could not connect to ODBC data source $odbc_dns");
if ( !( $odbc_rs = odbc_do($odbc_db, $query) ) )
die("Error executing query $query");
$num_cols = odbc_num_fields($odbc_rs);
if ($num_cols < 1)
die("Query retured an empty set");
echo "<TABLE>";
echo("<TR>");
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TH>[B]<font face='Rage Italic' size='3' color='#005CB9'>";
echo odbc_field_name($odbc_rs, $a);
echo "</TH>[/B]</font>";
}
echo "</TR>";
while( odbc_fetch_row($odbc_rs) )
{
echo "<TR>";
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TD><center>
<font face='Bradley Hand ITC' size='2' color='#000080'>";
echo odbc_result($odbc_rs, $a);
echo "</TD></center>";
}
echo "</TR>";
}
echo "</TABLE>";
}
else{
header("location:../SessioneScaduta.php");
exit;
}
?>
</body>
</html>
ma la query dovrebbe essere giusta... come lo risolvo??? grazie milleWarning: odbc_do(): SQL error: [Microsoft][Driver ODBC Microsoft Access] Parametri insufficienti. Previsto 2., SQL state 07001 in SQLExecDirect in c:\programmi\easyphp1-7\www\mancini3\_private\datiutente.php on line 27 Error executing query SELECT Username, Cognome, Nome, Data_di_nascita, E-mail, Città FROM Utente WHERE Username='Monet'
Rispondi quotando
