Connecting Tech Pros Worldwide Help | Site Map

a questions about mysql_fetch_array()

  #1  
Old July 17th, 2005, 05:58 AM
lsarg
Guest
 
Posts: n/a
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(posted, '%M %e,
%Y') AS d FROM messageboard ORDER BY posted DESC";

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


while ($row = mysql_fetch_array ($result, MYSQL_ASSOC) ) {

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

}
  #2  
Old July 17th, 2005, 05:58 AM
Tim Van Wassenhove
Guest
 
Posts: n/a

re: a questions about mysql_fetch_array()


In article <4c3827cd.0404241052.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(posted, '%M %e,
> %Y') AS d FROM messageboard ORDER BY posted DESC";
>
> $result = @mysql_query ($query);
> $row = mysql_fetch_array($result, MYSQL_ASSOC);[/color]

here $row contains the first row that is returned from your query
[color=blue]
> while ($row = mysql_fetch_array ($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_assoc($result) away.

--
http://home.mysth.be/~timvw
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
back button confusedofphp answers 1 July 9th, 2008 11:03 PM
Dumb Question... mysql_fetch_array() Good Man answers 15 July 17th, 2005 02:03 PM
2 short mysql/php questions frizzle answers 8 July 17th, 2005 01:21 PM
having problems with this sections on the script. josh dismukes answers 2 July 17th, 2005 05:32 AM