[denNorske]

Hello there

I noticed something weird using MySQL, and I can assume this has something to do with the cache handling?

Here is a short example code of what im doing:

PHP код:

function DoThisFirst()
{
    //code
    //Parse info i need to call the "DoThisSecond"
    mysql_format(connectionHandle, string, sizeof(string), "");
    mysql_tquery(connectionHandle, string, "DoThisSecond", "i", parameter);
    return 1;
}
function DoThisSecond(parameter)
{
    if(cache_get_row_count())
    {
        //parse info i need for next one (third)
        //...
        mysql_format(connectionHandle, string, sizeof(string), "");
        mysql_tquery(connectionHandle, string, "DoThisThird", "i", parameter); //this crashes the server. 
    }
    else
        //return an error
}
function DoThisThird(parameter)
{
    if(cache_get_row_count())
    {
        //and so on
    }
    else
        //return an error
} 


If you look at the code, i am trying to do a select statement inside a call for the first select statement, which makes me believe the cache is still active when a new one is called. Shouldn't the plugin be able to differ between those two?
Why does this happen, is it why I think it is?
And how could i get around this issue?

Thanks for explanations