mysql_fetch_object question

[abda53]

$q = "SELECT * FROM jtn_docs WHERE u_id = '" . $ShowSubscribers . "'";
					$r = mysql_query($q);
					$row = mysql_fetch_object($r);

				if( $row->d_id == $DID )
				{
					echo "<input name=\"fld_documents[]\" checked=\"checked\" type=\"checkbox\" value=\"". $DID ."\" />" .$DocName. "<br />";
				}
				else
				{
					echo "<input name=\"fld_documents[]\" type=\"checkbox\" value=\"". $DID ."\" />" .$DocName. "<br />";
				}

on the site, it will only show 1 checked box instead of the multiple taht should be shown.. any ideas or suggestions?

[Piranha]

You have to go through all the returned rows:

$q = "SELECT * FROM jtn_docs WHERE u_id = '" . $ShowSubscribers . "'";
                    $r = mysql_query($q);
                    while ($row = mysql_fetch_object($r))
{

                if( $row->d_id == $DID )
                {
                    echo "<input name=\"fld_documents[]\" checked=\"checked\" type=\"checkbox\" value=\"". $DID ."\" />" .$DocName. "<br />";
                }
                else
                {
                    echo "<input name=\"fld_documents[]\" type=\"checkbox\" value=\"". $DID ."\" />" .$DocName. "<br />";
                }
} 

[abda53]

oops shoulda deleted this. i figured it out.

thanks for the reply!