select @pivot_sql;select t.title, MONTH(ts.date_close) as test_month, YEAR(ts.date_close) as test_year, count(ts.*) as test_count
FROM
test_selected as ts
LEFT JOIN test as t ON ts.id_test = t.id
WHERE ts.date_close BETWEEN :date_begin AND :date_end
GROUP BY t.title, MONTH(ts.date_close),YEAR(ts.date_close)
ORDER BY test_year, test_montherror_log('BEGIN_while ');
while ( $rel-- ) {
error_log('while_rel: '.$rel);
$result = 'SELECT `mode` FROM `xuan` WHERE `id` = 1';
if ( $mysqli -> query($result) -> num_rows > 0 ) {
curl_setopt($ch, CURLOPT_URL, $url.'/mode/s/view/test-1');
$result = curl_exec($ch);
$mode = 1;
error_log('while_mode: '.$mode);
} else {
curl_setopt($ch, CURLOPT_URL, $url.'/mode/s/view/test-2');
$result = curl_exec($ch);
$mode = 2;
error_log('while_mode: '.$mode);
}
error_log('while_if_after');
curl_setopt($ch, CURLOPT_URL, $url.'/mode/s/confirm/test-'.$mode);
$result = curl_exec($ch);
sleep(1);
}
error_log('END_while ');
https://developers.google.com/custom-search/docs/e...