How to SELECT correct info from table for particular ID

[lands]

hey basically ive got news posts on my index.php with a link on each one to comment
the link will be something like www.website.co.uk/news_comments.php?newsid=<?php code for id ?>
which works as a link, now when it goes to the other page it has that link at the top with the correct newsid how can i show the news post that matches the link...

inside here:

<?php
$con = connect etc
$result = mysql_query('SELECT * FROM news WHERE news_id=!!WHAT GOES HERE!! ORDER BY news_id DESC');
while($row = mysql_fetch_array($result))
{
echo
"TABLES AND STUFF"

[lands]

ive sort of got it

$result = mysql_query('SELECT * FROM news WHERE news_id="$_GET[newsid]" ORDER BY news_id DESC');
while($row = mysql_fetch_array($result))
{

but now showing anything???

[Derokorian]

$result = mysql_query('SELECT * FROM news WHERE news_id="$_GET[newsid]" ORDER BY news_id DESC');

// Change to:


$result = mysql_query('SELECT * FROM news WHERE news_id="' . $_GET[newsid] . '" ORDER BY news_id DESC');

try that. HTH

[leatherback]

Just add this:

while($row = mysql_fetch_array($result))
  {
  echo $row['news'];
  }

that should get you some output.