ho questa pagina ke mi fa una query:
vorrei mettere i risultati di questa query in più pagine se nella tabella c sn più di un certo numero di valori. come devo modificare questa pagina?Codice PHP:<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
</head>
<body background="../images/sfondo.jpg">
<p align="right">
<font face="Arno Pro Light Display" size="3">[url="logout.php"]Logout[/url]</font></p>
<p align="center">
[img]../images/ForumSystem.gif[/img]</p>
<font size="6" face="Algerian">ELENCO FORUM</font></p>
<form action="elencodiscussioni.php" method="post">
<?php
$odbc_dns = "db_forum";
$odbc_userid = "";
$odbc_password = "";
$query = "SELECT ID,Titolo
FROM Forum";
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='Arno Pro Light Display' size='5'>";
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>
<font face='Arno Pro Light Display' size='4'>";
echo odbc_result($odbc_rs, $a);
echo "</TD>";
}
echo "<TD><input type='radio' name=titoloforum value=".odbc_result($odbc_rs, "Id")."></TD></TR>";
}
echo "</TABLE>";
?>
<input type="submit" name="submit" value="Continua"> </td>
<td width="307">
</tr>
</table></form>
<p align="center"><a href="menuamministratore.php">
<font size="3" face="Arno Pro Light Display">[b]Menù Amministratore[/b]</font></a></p>
<p align="center"><a href="gestioneforum.php">
<font size="3" face="Arno Pro Light Display">[b]Indietro[/b]</font></a></p>
</body>
</html>
grazie mille
Rispondi quotando
