View Single Post
Old 19th October 2009, 00:41
bernholdt bernholdt is offline
Senior Member
Join Date: Jun 2007
Posts: 156
Thanks: 47
Thanked 13 Times in 11 Posts
Default Mysql fetch array

Hi All
Im using this simple template system but i cant seem to get mysql_fetch_array to show all rows from table it works if i take a clean php page but as soon i put it in this template system if only show last line?

$template = new Template;
$template->replace("menu", "
<li><a href='index.php?Kundetoken=".$Kundetoken."'>Start</a></li>
<li><a href='indstillinger.php?Kundetoken=".$Kundetoken." '>Mine informationer</a></li>
<li><a href='../conf/logaf.php'>Log af</a></li>
<li><a href=''>Kontakt</a></li>
$template->replace("stats", "
<b>Statistikker</b><br />
Kundeid: ".$Kundeid."<br />
Sidstelogin: ".$Sidstelogin."<br />
Sidste ip: ".$Sidsteloginip."<br />
Din ip: ".$_SERVER["REMOTE_ADDR"]."<br />
$template->replace("Copy", "&copy 2006- ".date('Y')." <a href=''>X-Host</a>");

$Fakturer = mysql_query("SELECT * FROM Faktura WHERE Kundeid='".$Kundeid."'");
while ($row = mysql_fetch_array($Fakturer)) {
$template->replace("indhold", "Velkommen ".$Kundenavn."<br /><br />
Herunder kan du se dine ubetalte fakturer, opdatere dine kontakt informationer og se finde alle dine fakturer.<br /><br />
<a href='faktura.php?Kundetoken=".$Kundetoken."&Faktu ranummer=".$row['Fakturanummer']."'>Faktura nr: ".$row['Fakturanummer']."</a>");

Any ideas ???
Reply With Quote
Sponsored Links