HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Programming/Scripts (http://www.howtoforge.com/forums/forumdisplay.php?f=7)
-   -   Mysql fetch array (http://www.howtoforge.com/forums/showthread.php?t=40207)

bernholdt 18th October 2009 23:41

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 ???

falko 19th October 2009 14:12

I guess that $template->replace is the problem then.


All times are GMT +2. The time now is 11:42.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.