[Sarcoth]

Originally Posted by bananalive

How can I have a question which uses a query?
The following example gets a list of threads in the forumid 10.

1. Create 'Custom' question
2. Use following php Code:

PHP Code:

$answer = '<select name="'.$formbit[id].'">';
      $answer .= '<option></option>';
      $thisanswer = $q[$formbit[id]];
      $threads = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "thread
      WHERE forumid = '10'
      ORDER BY title ASC");
          while($row = $db->fetch_array($threads)) {
      $answer .= '<option value="'.$row[threadid].'"';
      if ($row[threadid] == $thisanswer) {
      $answer .= 'selected="selected"';
      }
      $answer .= '>'.$row[title].'</option>';
      }
      $answer .= '</select>'; 


Alright, now that is impressive! Can you tell me the code I would need to do a query on the profilefields (i.e. field8)? I'd like to pull that field and then just have it added to the form without the user having to enter it again.