Re: Re: HTML_quickform setdefaults question

rav k wrote: > Thanks for the advice Mark, > > I'm doing this but I'm still not getting the right outcome: > > // GETS THE INFO FROM THE USERS TABLE > $statement=$mdb2->prepare('SELECT Userid, Profile, Email, Sendmail FROM > Users WHERE Userid = ?', array('integer'), > array('integer','text','text','integer')); > $result=$statement->execute($id['userid']); > $statement->free(); > $userinfo=$result->fetchRow(MDB2_FETCHMODE_ASSOC); > > // GETS THE SKILLS FROM USERSKILLS WHICH MATCH THE USERSID > $statement=$mdb2->prepare('SELECT Skillid FROM Userskills WHERE Userid = > ?', array('integer'), array('integer')); > $result=$statement->execute($id['userid']); > $statement->free(); > $checked = $mdb2->fetchRow($result, MDB_FETCHMODE_ASSOC); > > // SUPPOSED TO USE USERINFO TO FILL FIELDS > // $CHECKED GOES INTO SKILLS GROUP TO FILL CHECKBOXES > $form->setDefaults($userinfo); > $form->setDefaults($skills->$checked); ^^^^^^^^^ Is this a typo in your mail or do you have this really in your code? > var_dump($userinfo); > var_dump($checked); $checked sounds much better than $skills->$checked. Do you get a reasonable output here? If not, please show us how the two arrays look like. Regards, Mark