5 - Mostrare informazioni relative a un album
home |
Elenco degli Album disponibili:
' . mysql_error());
print "\n";
//get field names
print "\n";
while ($campo = mysql_fetch_field($resquery))
{
print " | $campo->name | \n";
} // end while
print "
\n\n";
//get row data as an associative array
while ($row = mysql_fetch_assoc($resquery))
{
print "\n";
//look at each field
foreach ($row as $col=>$val){
print " | $val | \n";
} // end foreach
print "
\n\n";
}// end while
print "
\n";
?>
' . mysql_error());
print "\n";
//get field names
print "\n";
while ($campo = mysql_fetch_field($resquery2))
{
print " | $campo->name | \n";
} // end while
print "
\n\n";
//get row data as an associative array
while ($row = mysql_fetch_assoc($resquery2))
{
print "\n";
//look at each field
foreach ($row as $col=>$val){
print " | $val | \n";
} // end foreach
print "
\n\n";
}// end while
print "
\n";
?>
' . mysql_error());
print "\n";
//get field names
print "\n";
while ($campo = mysql_fetch_field($resquery3))
{
print " | $campo->name | \n";
} // end while
print "
\n\n";
//get row data as an associative array
while ($row = mysql_fetch_assoc($resquery3))
{
print "\n";
//look at each field
foreach ($row as $col=>$val){
print " | $val | \n";
} // end foreach
print "
\n\n";
}// end while
print "
\n";
}
else
{ $query = "SELECT Album.TitoloAlbum, Gruppo.NomeGruppo, Album.Etichetta, Album.AnnoAlbum, Album.DurataTot, Album.Formato from Album, Gruppo, ArtistaA WHERE Album.TitoloAlbum = '$album' AND Album.IDAlbum = ArtistaA.IDAlbum AND ArtistaA.IDGruppo = Gruppo.IDGruppo;";
$resquery = mysql_query($query, $conn) or die ($query . '
' . mysql_error());
print "\n";
//get field names
print "\n";
while ($campo = mysql_fetch_field($resquery))
{
print " | $campo->name | \n";
} // end while
print "
\n\n";
//get row data as an associative array
while ($row = mysql_fetch_assoc($resquery))
{
print "\n";
//look at each field
foreach ($row as $col=>$val){
print " | $val | \n";
} // end foreach
print "
\n\n";
}// end while
print "
\n";
?>
' . mysql_error());
print "\n";
//get field names
print "\n";
while ($campo = mysql_fetch_field($resquery2))
{
print " | $campo->name | \n";
} // end while
print "
\n\n";
//get row data as an associative array
while ($row = mysql_fetch_assoc($resquery2))
{
print "\n";
//look at each field
foreach ($row as $col=>$val){
print " | $val | \n";
} // end foreach
print "
\n\n";
}// end while
print "
\n";
?>
' . mysql_error());
print "\n";
//get field names
print "\n";
while ($campo = mysql_fetch_field($resquery3))
{
print " | $campo->name | \n";
} // end while
print "
\n\n";
//get row data as an associative array
while ($row = mysql_fetch_assoc($resquery3))
{
print "\n";
//look at each field
foreach ($row as $col=>$val){
print " | $val | \n";
} // end foreach
print "
\n\n";
}// end while
print "
\n";
}
?>