View Single Post
  #1  
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?

Quote:
$template = new Template;
$template->load("".$_SERVER["DOCUMENT_ROOT"]."/style/".$Style."/kunde/index.html");
$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='http://www.x-host.dk/kontakt/kontakt.php'>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='http://x-host.dk'>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>");
}

$template->publish();
Any ideas ???
Reply With Quote
Sponsored Links