[SOLVED] Help posting data to table using id from 2nd table

[sanderphp]

Looks like it is there.

 

Array

(

    [status] => 1

    [date] => 2008/5/1

    [total_distance] => 20

    [total_time] => 10

    [Ave_Speed] => 10

)

 

Array

(

    [username] => sl

    [password] => password

    [login_id] => 1

)

 

 

[Barand]

But you have

 

$rider_id = $_SESSION['login'];

[sanderphp]

I fixed that earlier.

 

// Pick up the form data and assign it to variables (if it was submitted)
if ($_POST['Status'] == '1') {
$date = $_POST['date'];
$total_distance = $_POST['total_distance'];
$total_time = $_POST['total_time'];
$ave_speed = $_POST['ave_speed'];
$rider_id = $_SESSION['login_id'];


// Insert data
$query = "INSERT INTO info (`date`, `total_time`, `total_distance`,`ave_speed`,`rider_id`)
  VALUES ('$date', '$total_time', '$total_distance', '$ave_speed', '$rider_id')";
mysql_query($query) or die(mysql_error());