Mysql Select not showing tables

Soldato
Joined
30 Jun 2003
Posts
2,807
Location
Berkshire
The following code is supposed to show the first 10 rows, unfortunately its not at present, and ideas as to what its going wrong?

Code:
<?php 

include_once 'db.php';

$query  = " SELECT * FROM `news` LIMIT 0 , 10 ";
$result = mysql_query($query);

while($row = mysql_fetch_array($result))
{
    echo "Name :{$row['Subject']} <br>" .
         "Subject : {$row['icon']} <br>" .
         "Message : {$row['news']} <br><br>";
}

?>
 
oooops human error (ok my error) should have been icons, not icon

ideally what i want to do now is place data in a table form a bit like php nuke where i have subject to the left, icon on same level to the right and the news underneath, if anyone can adjust my script to compensate this part would be appreicated
 
Back
Top Bottom