Well, progress, I think...
As you can see in the code below...
I changed the while statement as you suggested (correcting for the round bracket ending up on the next line...)
I also commented out the first list statement since it was not in your code...
// Fetch some info from the faq
$result = $db->query('SELECT faq_name, question, answer, disp_position FROM '.$db->prefix.'faq ORDER BY disp_position') or error('Unable to fetch faq info', __FILE__, __LINE__, $db->error());
if (!$db->num_rows($result))
message($lang_common['Bad request'], true);
//list($faq_name, $question, $answer, $disp_position) = $db->fetch_row($result);
if ($db->num_rows($result))
{
while (list($id, $faq_name, $question, $answer, $disp_position) = $db->fetch_row($result))
{
list($faq_name, $question, $answer, $disp_position) = $db->fetch_row($result);
?>
<tr>
<td class="puncon1" style="width: 25%; vertical-align: top" ><p style="margin-bottom: 0"><b><?php echo $lang_faq['question'].$disp_position.'</p><p style="margin-left: 10px; margin-top: 5px; margin-bottom: 5px"></b>'.$question ?></p></td>
<td class="puncon2" style="vertical-align: top"><p style="margin-bottom: 0"><b><?php echo $lang_faq['answer'].'</b></p><p style="margin-left: 10px; margin-top: 5px; margin-bottom: 5px">'.$answer ?></p></td>
</tr>
<?php
}
}
else
echo "\t".'<tr><td class="puncon1" colspan="6">'.$lang_faq['Empty FAQ'].'</td></tr>'."\n";
?>
I now get record #2 only and a blank record. (there should be 3 records.)
I didn't really understand what you said about this in your last post, could you clarify it for me?
I really appreciate your help on this!!!