where are all my records??

joyce posted this at 06:07 — 19th December 2001.

Joined: Nov 2001

these few lines of code below print records that are in the database. for eg. i have 10 records and it will print 10 records.

<?php
for($i=0;$i<mysql_num_rows($result);$i++) {
        list($taker_name, $taker_email, $show_record, $no_total, $no_correct, $time_taken, $time) = mysql_fetch_row($result);
        $percentage = round($no_correct/$no_total*10000) / 100;
        $row_color = ($i % 2) ? $table_color_1 : $table_color_2;

        print \"<tr>\n\";
        if ($show_record) $taker_name = \"<a href=\\"mailto:$taker_email\\">$taker_name</a>\";
        print \"    <td align=center bgcolor=$row_color><font face=\\"$font_face\\" color=\\"$font_color\\" size=2>$taker_name</font></td>\n\";
        print \"    <td align=center bgcolor=$row_color><font face=\\"$font_face\\" color=\\"$font_color\\" size=2>$no_total</font></td>\n\";
print \"</tr>\n\";
        }
?>

after i've change the code into these:

<?php
for($i=0;$i<mysql_num_rows($result);$i++) 
    {
        list($taker_name, $taker_email, $show_record, $no_total, $no_correct, $time_taken, $time) = mysql_fetch_row($result);
        $percentage = round($no_correct/$no_total*10000) / 100;
        $row_color = ($i % 2) ? $table_color_1 : $table_color_2;

        print \"<tr>\n\";
                
        if ($show_record) 
        {    
                            
                $database = 'forum';
                mysql_select_db($database);
                $result = mysql_query(\"SELECT userid FROM user WHERE username='$name'\");
                if ($result) 
                {
                    list ($userid, $username) = mysql_fetch_row($result);
                }
                $taker_name = \"<a href=\\"http://www.certifyexpress.com/forum/member.php?s=&action=getinfo&userid=$userid\\">$taker_name</a>\";
            }
            
            
        
        print \"    <td align=center bgcolor=$row_color><font face=\\"$font_face\\" color=\\"$font_color\\" size=2>$taker_name</font></td>\n\";
        print \"    <td align=center bgcolor=$row_color><font face=\\"$font_face\\" color=\\"$font_color\\" size=2>$no_total</font></td>\n\";
print \"</tr>\n\";
}
?>