Script ignores first entry in database

[Lesane]

With the following code i try 2 get the awards out of the database, when i have one award like this one:

awardsid=19 and aw=19 then it shows it on the postbit

now when i add a second award with these variables:

awardsid=16 and aw=0 then nothing will be showed, the first award will be ignored

when i change the second award to awardsid=16 and aw=16 then it shows that second award on the postbit...

so when i add a second award then it fully ignores the first entry/award :noid:

Does someone have a solution for this problem because i get paranoid

I'm using this code:

PHP Code:

if ($post[award]=="1") 
   {
     $awards=$DB_site->query("SELECT aw,awardsid,name, url FROM award");
     while ($award=$DB_site->fetch_array($awards)) {
     if ($award[aw] == $award[awardsid]) {
        eval("\$post[hasaward] = \"".gettemplate("awards")."\";");
    } 
else {
     $post[hasaward]="nope";
     } 
}
} 


[Admin]

Not sure I follow you, at all, but try changing this:

PHP Code:

        eval("\$post[hasaward] = \"".gettemplate("awards")."\";"); 


to this:

PHP Code:

        eval("\$post[hasaward] .= \"".gettemplate("awards")."\";"); 


since you are ADDING to the current variable, not re-creating it.

[Lesane]

You are a lifesaver, thanks man.

[Lesane]

hmm..how spooky is this? I got the hack almost finished and now the code dont works anymore, i'm using this code at the moment:

PHP Code:

if ($post[award]=="1") 
   {
     $awards=$DB_site->query("SELECT * FROM useraward where userid=$post[userid]");
     while ($award=$DB_site->fetch_array($awards)) 
     {
          if ($award[awardsid] == $award[aw]) 
          {
             eval("\$post[hasaward] .= \"".gettemplate("awards")."\";");
          } else {
           $post[hasaward]="";
          } 
     }
   } 


I have currently 3 awards in the database.

Lesane = checked
Lala = checked
Cool = not checked

It must display lesane + lala because they are checked but it displays nothing, it listen only to cool. When i have cool = checked then it displays everything so the script listen again only to the last entry in the database


Do you see any problem in the code that i dont see or do you know an other way? Thanks.