$filename="host.php";
include_once($filename);
$tablename = "emisiuni";
$link = mysql_connect($hostname,$username,$password) or die("nu m-am putut conecta");
mysql_select_db($database, $link)or die ("nu am putut selecta");
$result = mysql_query("SELECT count(*) AS nr FROM $tablename",$link) or die("
Nu am putu numara.
");
$nr = mysql_result($result,0,"nr");
$result = mysql_query("SELECT * FROM $tablename ", $link) or die ("
Nu am putut selecta.
");
if ($nr!=0) {
for ($i = 0; $i < $nr; $i++) {
$titlu = mysql_result($result, $i, "titlu");
$realizator = mysql_result($result, $i, "realizator");
$invitat = mysql_result($result, $i, "invitat");
$descriere = mysql_result($result, $i, "descriere");
echo "
".$titlu."  |
ora de difuzare |
| Realizator: ".$realizator." |
| Invitat: ".$invitat." |
".$descriere." |
";
}
}
mysql_close($link);
?>