News Problem :(

[мϊкэ]

Right on my news system i want to show the news titles and who the article is by in the the updates box, this strangely only works if your on the news page :s when i want it to work on all pages, anybody know whats wrong ! :s the page to show all of the news this is the source

the only page it works on is
www.xenigma.co.uk/index.php?page=news/viewnews

 <?
include("dbconnect.php");//include the file to connect to the database
$getnews = mysql_query("SELECT 10 FROM mynews ORDER BY id DESC");//query the database for all of the news

while($r=mysql_fetch_array($getnews)){//while there are rows in the table
extract($r);//remove the $r so its just $variable

echo("MY NEWS LAYOUT!!!");

}

?>

the variables are

$title - the news' title
$user - who added the news
$date - Month/Day/Year
$message - news itself

and the page to show the updates is:

 <?
include("news/dbconnect.php");//include the file to connect to the database
$getnews = mysql_query("SELECT 5 FROM mynews ORDER BY id DESC");//query the database for all of the news

while($r=mysql_fetch_array($getnews)){//while there are rows in the table
extract($r);//remove the $r so its just $variable

echo("$title by $user<br>");

}

?>

anybody know whats up this is probably one of my nooby mistakes which ill either realise at the last moment or somebody points it out to me and laughs at me like a noob

Please Help
xEnigmA

[мϊкэ]

Ignored Bump ^^

Edit by Urges - Please do not double post, Simply edit your last one. Thanks

[Rix]

can u show me in better detail and i'll have a look

[мϊкэ]

can i show you what in better detail? im giving you the source of whats on the news page and whats on the page were the updates are

what more can i give!

[мϊкэ]

no help ^^ bump

[Edited By Partie2] (Forum Moderator) please dont bump your posts it just wastes forum space!

[Mentor]

You mysql is wrong
$getnews = mysql_query("SELECT 5 FROM mynews ORDER BY id DESC");

its only selecting a row called 5 wich there probly isnt, what i think u want is

$getnews = mysql_query("SELECT * FROM mynews ORDER BY id DESC LIMIT 5");

[мϊкэ]

thanks again mentor!