hi all!
i have the following problem:
1.im loading 5 colums from a mysql-table into an array:
$threads = db_query("SELECT title, date, body, poster, board_posts_ID FROM board_posts
WHERE msgkind = 'thr'
ORDER BY date DESC");
everything fine so far...
2.im trying to list them line by line:
while (list ($title, $date, $body, $poster, $msgID) = mysql_fetch_array($threads)){
print (" <tr>\n".
" <td><a href=\"view_thread.php&parent=".$msgID.
" \">$title</a></td>\n".
" <td>$poster</td>\n".
" <td>$date</td>\n".
" </tr>\n");
}
here is the problem:
there's always one line(row) missing (i.e. if there are 17 rows in the db, 16 are
being displayed in the browser).i've tried the same code with mysql_fetch_row()...no
difference in the outcome.
please reply to this msg if you can help,
thx in advance, Chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
