mysql_connect("localhost","nicelabo","LostAlone77_") or die
("Keine Verbindung moeglich");
mysql_select_db("usrdb_nicelabo_miab") or die ("Die Datenbank existiert nicht");
?>
function TimeToSec($Time)
{
$TimeTemp = explode(":", $Time);
$TimeTemp = ($TimeTemp[0] * 60 * 60) + ($TimeTemp[1] * 60) + $TimeTemp[2];
return $TimeTemp;
}
function SecToTime($Time)
{
$Time = gmstrftime("%H:%M:%S",$Time);
return $Time;
}
?>
if (isset($_GET["id_iv"]) and ($_GET["id_iv"]>=0 and $_GET["id_iv"]<=9999)) {
$idv = $_GET["id_iv"];
//include "dbconnect.php";
$sql="select frage, antwort from interview_daten where id_iv='$idv' order by id_frage";
$res=mysql_query($sql);
$sqlkopf="select * from interview_kopf where id_iv=".$idv;
$res2=mysql_query($sqlkopf);
$datum=mysql_result($res2,0,"datum");
$grund=mysql_result($res2,0,"grund");
$magazin=mysql_result($res2,0,"magazin");
$interviewer=mysql_result($res2,0,"interviewer");
$homepage=mysql_result($res2,0,"homepage");
echo "";
echo "";
echo "mind.in.a.box - Interview for magazine '".$magazin."', Interviewer:'".$interviewer."', about: '".$grund."', Date: ".$datum;
echo " | ";
echo "
";
echo "";
echo "Link: ".$magazin."";
echo " | ";
echo "
";
while ($row=mysql_fetch_array($res))
{
echo "";
echo "";
echo "".$row[frage]." ".$row[antwort];
echo " |
";
} // while
echo "
";
}
// if (isset($_GET["id_iv"])) include ($_SERVER['DOCUMENT_ROOT']."/promo/interview.php?id_iv=".$_GET["id_iv"]);
?>