Hi All,
I hope somebody can help.
I would like to make 1 large query from a mysql database. Once called I want to get whatever i want from that stored array, which is where im having trouble.
What i have so far is the following code, but each time the page reloads it is running the query again.
<?php
session_start();
ob_start();
include 'dbconnect.php';
if ($_SESSION['mainquery'] == ''){
$SQL = "SELECT * FROM accounts a, callhistory c JOIN callhistory ON a.client_id = c.crm_reference WHERE date(c.timestamp_dtm) = '2011-05-17' ORDER BY c.timestamp_dtm DESC";
$_SESSION['mainquery'] = mysql_query($SQL);
} else if ($_SESSION['mainquery'] != '') {
$data = $_SESSION['mainquery'];
}
while ($row = mysql_fetch_array($data)){
echo "hello";
}
?>