I have code looks like this:
Code: Select all
//start with extarcion
$comm = payment_getCommission($userid, $date);
$trans = payment_getTransaction($userid, $date);
//create one array with all details
$data = array();
$data = array_merge($comm, $trans);
//crate tmp table
// var_dump($data); exit;
$sql = "CREATE TEMPORARY TABLE select_tbl (date VARCHAR(255), paid DATETIME, amount varchar(255), Reason VARCHAR(255), UTS INT(11)) TYPE=HEAP;";
for($i = 0; $i<count($data); $i++)
{
$sql .= "INSERT INTO select_tbl SET";
$sql .= " date = '".$data[$i]["date"]."'" ;
// $sql .= ", total = '".$data[$i]["total"]."'";
//$sql .= ", ProductID = '".$data[$i]["ProductID"]."'";
//$sql .= ", paid = '".$data[$i]["paid"]."'";
$sql .= ", amount = '".$data[$i]["amount"]."'";
$sql .= ", Reason = '".$data[$i]["ReasonLabel"]."'";
$sql .= ", UTS = '".$data[$i]["UTS"]."';";
}
$sql .= "SELECT * FROM select_tbl ORDER BY UTS DESC";
$result = mysql_query($sql);
$tmp_array = array();
while($tmp = mysql_fetch_assoc($result))
{
$tmp_array[] = $tmp;
}
var_dump($tmp_array);Code: Select all
CREATE TEMPORARY TABLE select_tbl (date VARCHAR(255), paid DATETIME, amount varchar(255), Reason VARCHAR(255), UTS INT(11)) TYPE=HEAP;
INSERT INTO select_tbl SET date = '12/11/2006 12:00 AM', amount = '250.00', Reason = 'Check Mailout', UTS = '1165816800';
INSERT INTO select_tbl SET date = '12/14/2006 1:13 PM', amount = '497.00', Reason = 'The Copywriting Secret Package', UTS = '1166123622';
INSERT INTO select_tbl SET date = '12/14/2006 10:03 AM', amount = '271.99', Reason = 'Make1Million Package', UTS = '1166112237';
INSERT INTO select_tbl SET date = '12/12/2006 1:38 PM', amount = '67.00', Reason = 'Resale-Rights-Solution membership', UTS = '1165952289';
SELECT * FROM select_tbl ORDER BY UTS DESCand it works like it should in phpMyAdmin (u can try query),I get results, but I the rest of code:
$result = mysql_query($sql)...etc returns nothing, I get :
mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
Any help or advice how can I get result from working query