a questions about mysql_fetch_array()

[lsarg]

whenever i use this, i'm leaving out one item from the array. in other
words, one row from the table i'm querying won't show up. i'm new at
php, and this is probably a simple thing, but please help of you can.
here's an example that leaves out the most recent submission:

$query = "SELECT topic, message, author, DATE_FORMAT(pos ted, '%M %e,
%Y') AS d FROM messageboard ORDER BY posted DESC";

$result = @mysql_query ($query);
$row = mysql_fetch_arr ay($result, MYSQL_ASSOC);


while ($row = mysql_fetch_arr ay ($result, MYSQL_ASSOC) ) {

echo"<p> {$row['topic']}<br>
{$row['message']}
<br>Posted by {$row['author']} on {$row['d']}
<br>";

}

[Tim Van Wassenhove]

Re: a questions about mysql_fetch_arr ay()

In article <4c3827cd.04042 41052.36a88b62@ posting.google. com>, lsarg wrote:[color=blue]
> whenever i use this, i'm leaving out one item from the array. in other
> words, one row from the table i'm querying won't show up. i'm new at
> php, and this is probably a simple thing, but please help of you can.
> here's an example that leaves out the most recent submission:
>
> $query = "SELECT topic, message, author, DATE_FORMAT(pos ted, '%M %e,
> %Y') AS d FROM messageboard ORDER BY posted DESC";
>
> $result = @mysql_query ($query);
> $row = mysql_fetch_arr ay($result, MYSQL_ASSOC);[/color]

here $row contains the first row that is returned from your query
[color=blue]
> while ($row = mysql_fetch_arr ay ($result, MYSQL_ASSOC) ) {[/color]

the first time you here, $row will containt the 2nd row from your query[color=blue]
> }[/color]

Suggestion: Leave the first $row = mysql_fetch_ass oc($result) away.

--

http://home.mysth.be/~timvw