From query to array problem

ej php dudes…

its bin a while() sinds i was back here… bin buzy with tons of stuff… but its good to see most of you still here… :smiley:

ok i have a problem with my gallery… i made a gallery a few months back (without MYSQL)… now i was working on a update and landed on something i just cant seem to get around…

problem is i have 3 items in my DB… when i request a result i only get 1… insted of all of um :S… now i have a feeling this is cos i use a template system… ({image} in index.tpl) i just cant seem to get around this problem…:krazy:


mysql_connect($db_host, $db_login, $db_pass); 
mysql_select_db($db_name);
		
$result = mysql_query("SELECT * FROM $db_tabel ORDER by id DESC")or die(mysql_error());
		while ($row = mysql_fetch_object($result)){

echo $row->koptekst . "<br />";

$ktekst = $row->koptekst;
}


//* Koppel IMAGECOUNT tag aan template *//
$tpl->assign("IMAGENAME", "$ktekst");

here yuh kan see what meen, top section is the echo outside of my template, and in the gray is inside my template…

http://www.trinitycore.nl/4FO_FUSv2.0/