mysql_query problem

$resultat = mysql_query("select * from mdb where id='".$_POST["id"]."'");

Eller for at holde det simpelt ;-)

mysql_query("select * from mdb where id='$_POST[id]'");

Og hvis det ikke er nok, så prøv med

$resultat = mysql_query("select * from mdb where id='".$_POST["id"]."'") or die(mysql_error());

Fulde script:
------------------------------------------------------
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Dany Cheng's Hjemmeside</title>

<style type="text/css">
BODY {
    scrollbar-face-color: #ABBED1;
    scrollbar-arrow-color:  #46505E;
    scrollbar-track-color: #D1DCE7;
    scrollbar-highlight-color: #C8D3E1;
    scrollbar-3dlight-color: #EAEFF4;
    scrollbar-shadow-color: #7492B6;
    scrollbar-darkshadow-color: #3A5370;
}
</style>
</head>

<body bgcolor="#F0F0F0">
<div align="center">
<table border="0" width="760" cellspacing="0" cellpadding="0" background="images/mdb_bg.gif">
    <tr>
        <td rowspan="2">
        <img border="0" src="images/mdb_left.gif" width="69" height="69"></td>
        <td width="100%" height="41">
        <p align="center">
        <img border="0" src="images/mdb_logo.gif" width="400" height="40"></td>
        <td rowspan="2">
        <img border="0" src="images/mdb_right.gif" width="69" height="69"></td>
    </tr>
    <tr>
        <td width="100%">
        <p align="center">&nbsp;</td>
    </tr>
</table>
</div>
<div align="center">

<?php
include 'connect.php';

$resultat = mysql_query("select * from mdb where id='".$_POST["id"]."'") or die(mysql_error());

while ($raekke = mysql_fetch_array($resultat)) {
  extract($raekke);


echo "<br>";
echo "<table border='0' width='725' cellspacing='0' cellpadding='0' background='images/top_center.gif'>";
echo "    <tr>";
echo "        <td bordercolor='#000000'><img border='0' src='images/top_left.gif' width='50' height='28'></td>";
echo "        <td width='100%' bordercolor='#000000'>";
echo "        <p align='center'><b><font face='Verdana' size='2' color='#ECF0F4'>";
echo "        $title1 ($year)</font></b></td>";
echo "        <td bordercolor='#000000'><img border='0' src='images/top_right.gif' width='50' height='28'></td>";
echo "    </tr>";
echo "</table>";
echo "";
echo "<div align='left'>";
echo "";
echo "<TABLE cellSpacing=1 cellPadding=2 width='725' border='1' background='images/mdb_cat.gif' height='26' align='center' >";
echo "        <TH height=22 width='256'><font face='Verdana' size='2'>Cover</font></TH>";
echo "        <TH height=22 colspan='2'><font face='Verdana' size='2'>Media Detail</font></TH>";
echo "                ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD width='256' rowspan='16'>";
echo "<img border='0' src='' width='200'></TD>";
echo "<TD align='left' valign='top' width='125'>";
echo "<font face='Verdana' size='2'>Media ID:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>$ID</font></TD>";
echo "</TR>";
echo "                ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'>";
echo "<p align='left'><font face='Verdana' size='2'>Media Type:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>$type</font></TD>";
echo "</TR>";
echo "                ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>Title:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>$title1</font></TD>";
echo "</TR>";
echo "                ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>Also ";
echo "Known As:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>$title2</font></TD>";
echo "</TR>        ";
echo "        ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>Release ";
echo "Year:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>$year</font></TD>";
echo "</TR>    ";
echo "        ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>Country:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>";
echo "$location</font></TD>";
echo "</TR>    ";
echo "        ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>No. of ";
echo "CD</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>$disc</font></TD>";
echo "</TR>    ";
echo "        ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>Video ";
echo "Quality</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>$videoquality</font></TD>";
echo "</TR>";
echo "                ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>Audio ";
echo "Quality</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>$audioquality</font></TD>";
echo "</TR>";
echo "        ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>Cast:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>";
echo "<label for='checkbox_row_16'>$actor</label></font></TD>";
echo "</TR>";
echo "                ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>Audio ";
echo "language</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>";
echo "$language1 $langsep1 $language2 $langsep2 $language3</font></TD>";
echo "</TR>";
echo "                ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>Subtitle ";
echo "Language:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>";
echo "$subtitle1 $subsep1 $subtitle2 $subsep2 $subtitle3</font></TD>";
echo "</TR>";
echo "                ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>Advanced ";
echo "to:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>$loan</font></TD>";
echo "</TR>";
echo "                ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>Advance ";
echo "date:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>$loandate</font></TD>";
echo "</TR>";
echo "                ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>My ";
echo "Rating:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>$persrating</font></TD>";
echo "</TR>";
echo "                ";
echo "<TR width='50%' bgcolor='#ECF0F4' align='center'>";
echo "<TD align='left' valign='top' width='125'><font face='Verdana' size='2'>User ";
echo "Rating:</font></TD>";
echo "<TD align='left' valign='top' width='320'><font face='Verdana' size='2'>";
echo "$userratings</font></TD>";

}
mysql_close();
?>

</TR>
</table></div>

</html>
------------------------------------------------------

når jeg kalder en ..sti/index.php?id=1

så spytter den det her ud:

---------------------------------
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Dany Cheng's Hjemmeside</title>

<style type="text/css">
BODY {
    scrollbar-face-color: #ABBED1;
    scrollbar-arrow-color:  #46505E;
    scrollbar-track-color: #D1DCE7;
    scrollbar-highlight-color: #C8D3E1;
    scrollbar-3dlight-color: #EAEFF4;
    scrollbar-shadow-color: #7492B6;
    scrollbar-darkshadow-color: #3A5370;
}
</style>
</head>

<body bgcolor="#F0F0F0">
<div align="center">
<table border="0" width="760" cellspacing="0" cellpadding="0" background="images/mdb_bg.gif">
    <tr>
        <td rowspan="2">
        <img border="0" src="images/mdb_left.gif" width="69" height="69"></td>
        <td width="100%" height="41">
        <p align="center">
        <img border="0" src="images/mdb_logo.gif" width="400" height="40"></td>
        <td rowspan="2">
        <img border="0" src="images/mdb_right.gif" width="69" height="69"></td>
    </tr>
    <tr>
        <td width="100%">
        <p align="center">&nbsp;</td>
    </tr>
</table>
</div>
<div align="center">


</TR>
</table></div>

</html>
---------------------------------

hvorfor gør den det? og hvordan kan jeg få det korrekt echoet ud?

den mælder ikke fejl.. så ve ikke lige hvad jeg skal gøre

Når du sender en værdi i adressen kommer den ikke i $_POST men i $_GET. Du kan eventuelt bruge $_REQUEST i stedet, hvis du vil have mulighed for at bruge begge metoder.

jeg er rimelig ny til php men altså vil det virke hvis jeg bruger GET i Stedet for POST?

hvor finder jeg evt. dokumentation?

Det virker SANDBOX kom med et svar så fordeler jeg point... men kan du finde en dokumentations side?

http://dk.php.net/manual/en/language.variables.external.php

Hvis du bruger $_GET, virker det kun, hvis det kommer i en URL (eller en form med method='get' men den sender også i URL).

Tak for det sandbox... du får point + god karma... Du har gjort mig meget klogere... har siddet med det i over 4 timer...

Jamen selv tak.