Jump to content

help with syntax for including Session Variable in SQL Query


webguync

Recommended Posts

I am storing a session variable and want to use that variable in a SQL Query. I think my syntax is a bit off, so need some help with this. I currently have

$_SESSION['user_id'];
$user_id='user_id'; 
print_r($_SESSION);
//DELETE QUERY TO SELECT RECORD TO DELETE BASED ON LOGIN INFO.
$query_delete = "DELETE FROM log_April2010
USING April2010 INNER JOIN roster_April2010
WHERE April2010.user_id = roster_April2010.user_id
AND roster_April2010.user_id = '"{$_SESSION['user_id']}"'"; 
echo $query_delete; //for debugging test

 

any assistance is greatly appreciated.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.