Accountid from user session id

Scheduler
#1

Hi guys,

I can’t get the events on the scheduler when i try to use the accountid in the render_sql sentence:

When i run this code, scheduler does work ok

$accountId = “03968j0k4t9x1614723”;

$rooms->render_sql(“select *, id as value, label as label from rooms where accountid=’$accountId’”,“id”,“id(value),label(label),type(type),status(status)”);

But if i want to assign to $accountId the data session login value, it won’t work

$accountId = $_SESSION[‘accountId’];

$rooms->render_sql(“select *, id as value, label as label from rooms where accountid=’$accountId’”,“id”,“id(value),label(label),type(type),status(status)”);

If i test the session connection, it given the right value:

$accountId = $_SESSION[‘accountid’];

echo ‘<pre>’;

print_r ($accountId);

echo "</pre>”;

What can be happening?

Regards,

Mariano