Inserting session variables into a table

[182x]

Hey guys, I am using the following code to try to insert a record into a table but its not working and I was just wondering why and also it has to work with an older version of PHP 4.x so i was just wondering is this possible?

Thanks for any help.


[code]

<?php
session_start();
include('db.php');
$link_id = db_connect('');

$query="INSERT INTO c (cur) VALUES('$HTTP_SESSION_VARS['curr']')";

mysql_query($query, $link_id);

header("location:de.php");

?>

[/code]

[The Little Guy]

here is an example of how to insert into a mysql database
[code]
<?php
session_start();
$_SESSION['favcolor'] = "green"; // green
$_SESSION['animal'] = "cat";  // cat

$query="INSERT INTO c (`favcolor`,`animal`) VALUES('$_SESSION[favcolor]','$_SESSION[animal]')";

mysql_query($query, $link_id);
header("location:de.php");
?>
[/code]