Function : Not showing all results.

[a1amattyj]

Hello,

 

Function:

 

function News()
{
    mysql_close($conn2);

    require ('multi_operations/config_inc.php');

    $query = "SELECT * FROM multi_news ORDER BY id DESC";
    $result = mysql_query($query) or die(mysql_error());
    $row2 = mysql_fetch_array($result);

    if ($row2['status'] == '1') {

while($row2 = mysql_fetch_array($result)){
echo '			
	<table width="100%" cellpadding="3" cellspacing="1" border="0" class="bordercolor">
             <tr class="titlebg">
			<td align="center" colspan="2" class="largetext"><b>'.$row2['subject'].' - '.$row2['date'].'</b></td>
		</tr>

<tr>
			<td class="windowbg" valign="top" style="padding: 7px;">

				<div style="font-size: 0.85em">'.$row2['message'].'</div>

			</td>
		</tr>
	</table>

';
}

    }
    mysql_close($conn);
}

 

However, with the select mysql ^

 

if there is one result in the database, it will not display it.

If there is a second result in the database, it will display the first one.

if i insert a third result, it will show the last two but not the most recent one.

 

So basically, it is not displaying the most recent one.

 

Thanks

[DeanWhitehouse]

try chaging

if ($row2['status'] > 0) {

[a1amattyj]

Nope, still does the same.

 

Thanks

[sasa]

function News()
{
    mysql_close($conn2);

    require ('multi_operations/config_inc.php');

    $query = "SELECT * FROM multi_news WHERE `status`='1' ORDER BY id DESC";
    $result = mysql_query($query) or die(mysql_error());
//    $row2 = mysql_fetch_array($result);

//    if ($row2['status'] == '1') {

while($row2 = mysql_fetch_array($result)){
echo '			
	<table width="100%" cellpadding="3" cellspacing="1" border="0" class="bordercolor">
             <tr class="titlebg">
			<td align="center" colspan="2" class="largetext"><b>'.$row2['subject'].' - '.$row2['date'].'</b></td>
		</tr>

<tr>
			<td class="windowbg" valign="top" style="padding: 7px;">

				<div style="font-size: 0.85em">'.$row2['message'].'</div>

			</td>
		</tr>
	</table>

';
}

//    }
    mysql_close($conn);
}