#1  
Old 18th October 2009, 23:41
bernholdt bernholdt is offline
Senior Member
 
Join Date: Jun 2007
Posts: 154
Thanks: 44
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 ???
__________________
www.gamebook.me
Reply With Quote
Sponsored Links
  #2  
Old 19th October 2009, 14:12
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

I guess that $template->replace is the problem then.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
phpmyadmin error lifeisboost Installation/Configuration 9 14th August 2008 19:19
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
log files, rotation and emailing them hairydog2 General 65 11th October 2006 13:18
phpMyAdmin - panick attack md@waw.co.uk General 6 3rd September 2006 20:52
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


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


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