Print query when I parse ID

[Ricki Susic]

Hi,
Can anyone help me to get my query printed when I parse ID.

Here is the code:

[snip]

FILE: udskriv.php

<?php

include("connect.php");
mysql_select_db("DATABASE");
$result = mysql_query("SELECT ID, tekst, DATE_FORMAT(dato, '%d %m %Y
kl. %H:%i')as dato FROM TABLE ORDER BY ID desc LIMIT 0,3");
while ($raekke = mysql_fetch_array($result)){

echo"<P>Indtastet dato: ".$raekke['dato']."</P>";
$text = $raekke['tekst'];
echo nl2br(substr($text,0,50));
print "<a href='showpost.php?ID={$raekke["ID"]}'>Some Text</a>";


}
mysql_close($link);
?>

FILE: showpost.php

<?php

include("connect.php");
$ID = $_POST['ID'];
$sql = "SELECT tekst FROM TABLE WHERE ID=$ID";
$result = mysql_query($sql);
echo "her er:".$result;

mysql_close($link);


?>

[snip]

The problem is that I don't get any output from the database. Why?

Ricki

[sam]

1-In the file showpost.php change

this line:
$ID = $_POST['ID'];
with this line:
$ID = $_GET['ID'];

You send the ID to showpost.php in the URL:
<a href='showpost.php?ID={$raekke["ID"]}'>Some Text</a>

So you get it in the $_GET array and not in the $_POST array.

2- this line is wrong (here you print the resource id):

echo "her er:".$result;

instead :
get the result from the resource id:
$txt = mysql_fetch_row($result);
print the result:
echo "her er:".$txt[0];

HTH.

"Ricki Susic" <ri*************@webfabrikken.net> wrote in message
news:3f***********************@dread12.news.tele.d k...

Hi,
Can anyone help me to get my query printed when I parse ID.

Here is the code:

[snip]

FILE: udskriv.php

<?php

include("connect.php");
mysql_select_db("DATABASE");
$result = mysql_query("SELECT ID, tekst, DATE_FORMAT(dato, '%d %m %Y
kl. %H:%i')as dato FROM TABLE ORDER BY ID desc LIMIT 0,3");
while ($raekke = mysql_fetch_array($result)){

echo"<P>Indtastet dato: ".$raekke['dato']."</P>";
$text = $raekke['tekst'];
echo nl2br(substr($text,0,50));
print "<a href='showpost.php?ID={$raekke["ID"]}'>Some Text</a>";


}
mysql_close($link);
?>

FILE: showpost.php

<?php

include("connect.php");
$ID = $_POST['ID'];
$sql = "SELECT tekst FROM TABLE WHERE ID=$ID";
$result = mysql_query($sql);
echo "her er:".$result;

mysql_close($link);


?>

[snip]

The problem is that I don't get any output from the database. Why?

Ricki

[Ricki Susic]

Thank you. Now it works!

Ricki