Kan ikke overføre fra en form til en anden php fil
Jeg vil gerne sende et tal fra en php fil til en anden. Dette tal har jeg nu gemt i en skjult html form, men jeg syntes ikke at jeg kan fat i den på den anden side.Her er koden til den fil som har formen:
<a href="index.php"><img src="/image/logo.gif" align="center" border="0"></a>
<hr>
<?PHP
$myconnection=mysql_connect("localhost","thumbsup_dk","51202410") or die("cannot connect to server");
mysql_select_db("thumbsup_dk") or die("cannot connect to database");
$sql="SELECT make, model, year, price, carstatus, car_id FROM car AS a INNER JOIN carstatus AS b ON a.carstatus_id=b.carstatus_id WHERE a.carstatus_id=1";
$result=mysql_query($sql);
while($myrow=mysql_fetch_row($result))
{
echo "<B>$myrow[0] $myrow[1]</B> fra $myrow[2] koster $myrow[3] og er $myrow[4]";
global $car_id;
$car_id=$myrow[5];
echo "<form method=POST action='cardetail.php'>";
echo "<input type=HIDDEN name=car_id value='$car_id'>";
echo "<input type=SUBMIT name=send value='Se detailer'>";
echo "</form>";
$sqlextra="SELECT description FROM car_extra AS a INNER JOIN extra AS b ON a.extra_id=b.extra_id WHERE a.car_id=$car_id";
$extraresult=mysql_query($sqlextra);
while($row=mysql_fetch_row($extraresult))
{
echo "$row[0] <br>";
}
echo "<hr>";
}
echo "<hr>";
?>
Her er koden til den anden fil som skal modtage fra formen.
Tallet fra formen skal helst gemmes i $car_id
<a href="index.php"><img src="/image/logo.gif" align="center" border="0"></a>
<hr>
<?PHP
$myconnection=mysql_connect("localhost","thumbsup_dk","51202410") or die("cannot connect to server");
mysql_select_db("thumbsup_dk") or die("cannot connect to database");
$sql="SELECT description, price, reference
FROM expence AS a
INNER JOIN car_expence AS b
ON b.expence_id=a.expence_id
WHERE b.car_id=$car_id";
$result=mysql_query($sql);
while ($row=mysql_fetch_row($result))
{
echo "$row[0] $row[1] $row[2]<br>";
}
?>
