mysql while query

admin

Administrator
Staff member
******
QUERY
******
$sql = "SELECT * from d_news ORDER BY id DESC";
$result = mysql_query( $sql );
******

******
$row = mysql_fetch_array( $result )
echo $row["name"];
******

The above fragment, when in my script returns $row["name"] i.e. "Dave" However, the following code returns nothing.

******
while ( $row = mysql_fetch_array( $result ) );
{
echo $row["name"];
}
******

What have I done wrong?
 
Back
Top