stroing session ID into database

[raffael3d]

I have a session

<?session_start();


  $sessionId = session_id();

now I want to write that id into the database, but nothing is stored! why? how can I solved it? I need the id so I can recognize a customer.

$query = "INSERT INTO shop (qty,sessionid) VALUES ('1','$sessionId')";

thanks!

[The_Chancer]

Why not do it all in the query ?

session_start();
$query=mysql_query("INSERT INTO `tablename` (qty,id) VALUES ('".$qty."','".session_id()."')");

[raffael3d]

well I tried that both this also doesn't work...

[The_Chancer]

That code will work... however without being psychic I can't see it....

Can you post your code to help relieve this problem ?

Thanks,