utilizzazione di un db
query SQLServer
<? $Riga=odbc_exec($Connessione,$Query_String); ?>
<? odbc_fetch_row($Riga); ?>
<? odbc_free_result($Riga); ?>
$Query_String="SELECT * FROM lista";
$Riga=odbc_exec($Connessione,$Query_String);
while(odbc_fetch_row($Riga))
{ echo odbc_result($Riga,"NRIGA").
"-".odbc_result($Riga,"RIGA"); }
odbc_free_result($Riga); ?>
query MySQL
<? $tabella = mysql_query ($Query_String);
$riga = mysql_fetch_array ($tabella); ?>
$Query_String="SELECT * FROM lista";
$tabella = mysql_query ($Query_String);
if ($riga = mysql_fetch_array ($tabella)) {
do {
print $riga[0]."-".$riga[1];
} while ($riga = mysql_fetch_array ($tabellaa)); }
else { print "sorry! neanche una riga"; } ?>
|