while statements, eval, and only one result showing :(

[dv6cougar]

hey guys, i'm using the Template Hack, mucho props to whomever made that, it's a great hack!

however, i'm trying to make a raffle like hack with this, so far i'm not doign to bad

this would be my first attempt at a hack.

i have this in my code

PHP Code:

//check to see that $id is not set
if(!isset($id)) {
    $raffle = $DB_site->query("SELECT * FROM raffle_list WHERE status='current'");
        while($raffleql = $DB_site->fetch_array($raffle)) {
        
        $raftitle = $raffleql['title'];
        $rafid = $raffleql['id'];
         eval("\$ticketid = \"".logiciangettemplate('ticketid')."\";");
        }//end while
}//end $id is not set 


and then i have my template set to use $ticketid, which works great

but then the ticketid tempalte looks like this

PHP Code:

<a href="show.php?pg=raffle&id=$rafid">$raftitle</a> 


the $rafid and $raftitle work like a charm, however, if i have 2 raffles i want to show up it only shows one

how do you make the while statement work correctly? i know you can do it, since teh forumhome and forumdisplay does it

thanks alot