Can't find what is wrong with my syntax using an if statement in a query

Can someone see what is wrong with my syntax (it may be completely obvious or for some reason impossible to do. I'm not particularly good at this)

I'm trying to say more or less:
if the Session variable: switch_user_id has a value, use it, otherwise use the session variable user_id value instead. Below is part of a constructed query using datatables.net.

$sWhere .= " AND subscribers.account_id=".
if (isset($_SESSION['switch_user_id']))
{ 
$_SESSION['switch_user_id'];
} else { 
$_SESSION['user_id'];
};

Open in new window


I am using session_start(); at the top of my page.
Get this error in my logs:
PHP Parse error: syntax error, unexpected T_IF
LVL 1
tjyoungAsked:
Who is Participating?
 
COBOLdinosaurConnect With a Mentor Commented:
$id=(isset($_SESSION['switch_user_id'])) ? $_SESSION['switch_user_id'] : $_SESSION['user_id'];
$sWhere .= " AND subscribers.account_id=".$id;


Cd&
0
 
tjyoungAuthor Commented:
much nicer. Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.