How PHP displays data from phpMyAdmin through mySQL connection
<p>Hi there I was just wondering how PHP prioritizes the order of displaying data through a mySQL connection via mySQL connect().</p>

<p>Here is my sample code:</p>

<pre><code>mysql_select_db("globetosmac_db");

        $nowrequest=date("Y-m-d G:i:s");
        $requestsql="SELECT xml FROM g2s_api_logs WHERE functioncode='MQX' AND cardnumber= '$cardnumber' AND        direction='out' AND datetime='$nowrequest'";
        $requestquery= mysql_query($requestsql)or die(mysql_error().$requestsql);
        $requestarray=mysql_fetch_array($requestquery,MYSQL_ASSOC);
        $requestresult= htmlentities($requestarray['xml']);

        $nowresponse=date("Y-m-d G:i:s");
        $responsesql="SELECT xml FROM g2s_api_logs WHERE functioncode='MQX' AND cardnumber='$cardnumber' AND    
        direction='in' AND datetime='$nowresponse'";
        $responsequery= mysql_query($responsesql)or die(mysql_error().$responsesql);
        $responsearray=mysql_fetch_array($responsequery,MYSQL_ASSOC);
        $responseresult= htmlentities($responsearray['xml']);
        mysql_close();
</code></pre>

<p>This works fine but for some reason the SQL display to PHP is a bit delayed until I press F5(refresh).</p>

<p>Does anyone have any idea what's causing this delay?</p>
