linking mysql results to another data from the same table.

[babydolphin]

From the codes below, i'm trying to show the details of the description that the user is going to click on.

<?php
include "login.php";
$query = "select * from news order by dates desc";
$result = mysql_query($query);

if(!$result)
{
die("Could not query the database: <br>" .mysql_error());
}
while($rowsql=mysql_fetch_array($result, MYSQL_ASSOC))
{
$link = $rowsql["news_details"];
echo $rowsql["dates"]. "<br>";
echo "<a href=show_news_details.php?$_POST[news_id] class='whiteNorm'>".$rowsql["news_desc"]."</a>";
echo "<br>";
}
mysql_close($connection);
?>

when the user click on one of the description, it will go to the below php to retrieve the details out. but there is a warning as
"warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\wamp\www\bmc (halim's)\web\show_news_details.php on line 7"
can anyone help me please.

thanks in advance.

<?php
include "login.php";
$id = $_GET["news_id"];
$query = "select * from news where news_id = $id";
$result = mysql_query($query);
$answer = mysql_fetch_row($result);
echo  $answer[2]."  " .$answer[1]. "<br>". $answer[3];
?>

[ixalmida]

It sounds like there's a problem with the query, so $result is not getting a value. You should add an "or die()" process at least for troubleshooting:

$result = mysql_query($query)
  or die(mysql_error()."<br>".$query);

There are different points of view on whether to leave that code in the final product because it leaves the user hanging. But you can always add something like this to the final code:

if(mysql_error() !== "")
  {
  $user_msg = "<p>There has been an error.  Please <a href='mailto: [e-mail]?subject=Error report&body=".$_SERVER['PHP_SELF']."<br>".mysql_error()."<br>".$query."'>email the web admin</a>, then click here:  <a href='".$_SERVER['http_referrer']."'>(back)</a></p>";
  die($user_msg);
  }

[djjjozsi]

I think, you failed at the link <a href=>
And you wrote a $_POST[] value into the link.. I cant imagine how you get that...

<?php
include "login.php";
$query = "select * from news order by dates desc";
$result = mysql_query($query);

if(!$result)
{
die("Could not query the database: <br>" .mysql_error());
}
else
{
while($rowsql=mysql_fetch_assoc($result))
{
echo $rowsql["dates"]. "<br>";
echo "<a href=\"show_news_details.php?news_id={$rowsql["news_details_id"]}\" class='whiteNorm'>{$rowsql["news_desc"]}</a>";
echo "<br>";
}
}
mysql_close($connection);
?> 

And in the shownews program:

<?php
include "login.php";
if($_GET["news_id")
{
$id = mysql_real_escape_string($_GET["news_id"]);
$query = "select * from news where news_id =$id";
$result = mysql_query($query);
$answer = mysql_fetch_assoc($result);
echo  $answer[2]."  " .$answer[1]. "<br>". $answer[3];
}
else
echo "There is nothing to write ...";
?>