[RESOLVED] ob_start() + $_SESSION setting problems

Sykoi

For some reason when I set a $SESSION after a mysql statement, the $SESSION ends up being assigned before anything before it has a chance to run...
I have no idea what is going on here, all I have is an inkling... I'm afraid that ob_start() is responsible for this, and its become a major thorn in my side, and my temporary solution is causing more trouble then it is worth....

So,
a) What could be causing this, if not ob_start()
b) Regardless of the answer to (a), how can I fix this?

Example of it (This is obviously not the actual code, just pseudo code as the actual code is nearly 1000 lines long):

if ($action == this) {
$mysql->query(add the session into the database);
//Done with the session
$_SESSION['blah'] = 0;
redirect to new page();
}

bradgrafelman

So you're saying, in your coding snippet, the $_SESSION variable would be set to 0 when the query was actually executed?

Have you tried debuggint this, e.g.

if ($action == this) { 
echo 'Before query: ' . $_SESSION['blah'] . "<br/>\n";
$mysql->query(add the session into the database); 
//Done with the session 
$_SESSION['blah'] = 0; 
echo 'After query: ' . $_SESSION['blah'] . "<br/>\n";
redirect to new page(); 
}

Sykoi

No, as I said the session is executed before the sql statement even though it is clearly called afterwards in the actual file.
And yes, I have already fully debugged, I am well aware of the problem, hence my post. I thought it was pretty clear but:

$_SESSION['blah'] = "something";
$mysql->query(insert the $_SESSION{'blah']);
$_SESSION['blah'] = 0;

For some "0" is inserted into the database, even if the session reassignment is called much further along the line in the code.

bradgrafelman

Can you copy & paste the actual query() call from your script?

Also, try putting the query in a variable and echo'ing it out - what does it say?

Sykoi

The query is unimportant, the $SESSION isn't set correctly regardless of where its being called from. Whether it be a print, a query or a logic statement - if any of these things are in the same scope as the $SESSION reassignment, they will have the new value.

bradgrafelman

Well, I was only moderately interested in the query itself - what I was hoping to see was the exact way in which it was formed.

Also - you've theorized that ob_start() might be the culprit. Have you tried removing the ob_start() call in your script and seeing if that works? Is there a need for ob_start() ?

Sykoi

Well I can't remove it, theres a need for it as I send/check cookies, headers, etc. multiple different times in multiple places.