[text]
"Notice: Undefined offset: 4 in C:\wamp\www\tsLive\mfQuery3.php on line 41"[/text]
and also line 63 and line 78 (marked below)
But I can't see where it is getting the offset of 4 from, as there are only 3 queries (0,1,2), and 4 customers (0,1,2,3).
Code: Select all
<?php
// Query3 - LIVE
//queries
$q1 = "SELECT COUNT(*) AS 'count' FROM jobs WHERE LEFT(`starttime`,10) = CURDATE() AND `customerid` =";
$q2 = "SELECT COUNT(*) AS 'closed' FROM jobs WHERE LEFT(`starttime`,10) = CURDATE() AND `closed` IS NOT NULL AND `customerid` =";
$q3 = "SELECT COUNT(*) AS 'open' FROM jobs WHERE LEFT(`starttime`,10) = CURDATE() AND `closed` IS NULL AND `customerid` =";
//mfO query_array
$mfOquery_array = array();
$mfOquery_array[] = array( 'query1' => $q1,
'query2' => $q2,
'query3' => $q3
);
//list of Customers
$Oarray[] = array( 'name' => "Cust1",
'id' => "117");
$Oarray[] = array( 'name' => "Cust2",
'id' => "404");
$Oarray[] = array( 'name' => "Cust3",
'id' => "255");
$Oarray[] = array( 'name' => "Cust4",
'id' => "466");
//mf connections
$mfO_array = $connections_array[7];
//
$con = mysql_connect($mfO_array['server'], $mfO_array['user'], $mfO_array['password']);
mysql_select_db($mfO_array['default'], $con);
foreach($mfOquery_array as $Oquery) {
for($b = 0; $b <sizeof($Oarray); $b++) {
// QUERY 1
$mfOquery = $Oquery['query1'].$Oarray[$b]['id']; // --> this is line 41
$mfOres1 = mysql_query($mfOquery);
if ( !$mfOres1 ) { $error = mysql_error();
print "<table style=\"width:98%; border: 5px solid black; align: center; text-align: center; font-size:14px; color:black; ><tr><th>ERROR HAS OCCURRED</th></tr>\"";
print "<tr><td>".$error."</td></tr></table>";
}
while($mfOrow1 = mysql_fetch_assoc($mfOres1)) {
$OtotalJobs[$db['database']] = $mfOrow1;
$Oarray[$b]['count'] = $mfOrow1['count'];
}
// QUERY 2
$mfOquery = $Oquery['query2'].$Oarray[$b]['id']; // --> this is line 63
$mfOres2 = mysql_query($mfOquery);
if ( !$mfOres2 ) { $error = mysql_error();
print "<table style=\"width:98%; border: 5px solid black; align: center; text-align: center; font-size:14px; color:black; ><tr><th>ERROR HAS OCCURRED</th></tr>\"";
print "<tr><td>".$error."</td></tr></table>";
}
while($mfOrow2 = mysql_fetch_assoc($mfOres2)) {
$OcloseJobs[$db['database']] = $mfOrow2;
$Oarray[$a]['closed'] = $mfOrow1['closed'];
}
// QUERY 3
$mfOquery = $Oquery['query3'].$Oarray[$b]['id']; // --> this is line 78
$mfOres3 = mysql_query($mfOquery);
if ( !$mfOres3 ) { $error = mysql_error();
print "<table style=\"width:98%; border: 5px solid black; align: center; text-align: center; font-size:14px; color:black; ><tr><th>ERROR HAS OCCURRED</th></tr>\"";
print "<tr><td>".$error."</td></tr></table>";
}
while($mfOrow3 = mysql_fetch_assoc($mfOres3)) {
$OopenJobs[$db['database']] = $mfOrow3;
$Oarray[$a]['open'] = $mfOrow3['open'];
}
}
}
mysql_close($con);
?>