I am looking for a way to combine multiple DB calls to one.
My current code is currently taking up space and will take up more if I continue to make one new "Statement" for every call.
CODE:
Code: Select all
$mydb = "SELECT * FROM economy";
$res = $db->dbquery($mydb);
while($array = $db->fetchArray($res)){
//Economi Table
//$id = mysql_real_escape_string($array['id']);
$money = mysql_real_escape_string($array['money']);
$income = mysql_real_escape_string($array['income']);
}
$mydb = "SELECT * FROM research, my_research WHERE id = $id";
$res = $db->dbquery($mydb);
while($array = $db->fetchArray($res)){
//My_Reasearch Table
$bet = mysql_real_escape_string($array['bet']);
$completed .= mysql_real_escape_string($array['completed']);
$lvl = mysql_real_escape_string($array['lvl']);
$tC = mysql_real_escape_string($array['timeComplete']);
$dC = mysql_real_escape_string($array['dateComplete']);
//Research Table
$ptf = mysql_real_escape_string($array['pointstofinish']);
}
The solution I have been trying to find is:
Have it all in one call. With no more than 40 rows no matter how many calls I got.
Have it all depending on the $mydb
Regards,
Thomas