[Resolvido] exportar query

boas. criei este recordset através do dw, acrescentei o código encontrado aqui no forum para poder exportar apenas os dados onde o filtro são 2 campos de data, ou seja, os dados apresentados na página onde aplico este mesmo filtro entre datas, é para ser exportado para csv. a tabela sei como exportar, mas atendendo que neste caso é o conjunto de 2 tabelas para formar a query, n sei como fazê-lo e tentei desta forma, mas dá-me este erro ao abrir a folha de excel:

**<br />**

<b>Warning</b>: mysql_num_fields() expects parameter 1 to be resource, boolean given in <b>C:\wamp\www\TMN\teste_exp2.php</b> on line <b>59</b><br />

<br />

<b>Warning</b>: mysql_fetch_array() expects parameter 1 to be resource, boolean given in <b>C:\wamp\www\TMN\teste_exp2.php</b> on line <b>71</b><br />

o código:

exporta.php

<?php

$host = 'localhost'; // MYSQL database host adress
$db = 'tool_tmn'; // MYSQL database name
$user = 'root'; // Mysql Database user
$pass = ''; // Mysql Database password

// Conexão com o bando de dados

$link = mysql_connect($host, $user, $pass);
mysql_select_db($db);

require 'exporta.inc.php';

$table="$query_Recordset1"; // aqui vai o nome da tabela que voce quer exportar

exportMysqlToCsv($table);

?>

exporta.inc.php

<?php require_once('Connections/tool_tmn.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

 if (PHP_VERSION < 6) {
 $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
 }

 $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

 switch ($theType) {
 case "text":
 $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
 break;
 case "long":
 case "int":
 $theValue = ($theValue != "") ? intval($theValue) : "NULL";
 break;
 case "double":
 $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
 break;
 case "date":
 $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
 break;
 case "defined":
 $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
 break;
 }
 return $theValue;
}
}

$colname_Recordset1 = "-1";
if (isset($_GET['liga'])) {
 $colname_Recordset1 = $_GET['liga'];
}
$colname1_Recordset1 = "-1";
if (isset($_GET['colname1'])) {
 $colname1_Recordset1 = $_GET['colname1'];
}
mysql_select_db($database_tool_tmn, $tool_tmn);
$query_Recordset1 = sprintf("SELECT in_rfplansite_tble1.dataa, in_rfplansite_tble2.datad, in_rfplansite_tble1.BSS_NAME, in_rfplansite_tble1.SITE_NUMBER, IF(in_rfplansite_tble1.fm_site_type=in_rfplansite_tble2.fm_site_type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.fm_site_type)) AS fm_site_type, IF(in_rfplansite_tble1.bts_type=in_rfplansite_tble2.bts_type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bts_type)) AS bts_type, IF(in_rfplansite_tble1.siteGeneration=in_rfplansite_tble2.siteGeneration,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.siteGeneration)) AS siteGeneration, IF(in_rfplansite_tble1.lcf_id=in_rfplansite_tble2.lcf_id,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.lcf_id)) AS lcf_id, IF(in_rfplansite_tble1.bsp_lcf_type=in_rfplansite_tble2.bsp_lcf_type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bsp_lcf_type)) AS bsp_lcf_type, IF(in_rfplansite_tble1.carrierDisableTm=in_rfplansite_tble2.carrierDisableTm,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.carrierDisableTm)) AS carrierDisableTm, IF(in_rfplansite_tble1.carriersInsPwrFl=in_rfplansite_tble2.carriersInsPwrFl,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.carriersInsPwrFl)) AS carriersInsPwrFl, IF(in_rfplansite_tble1.csfp_alg=in_rfplansite_tble2.csfp_alg,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.csfp_alg)) AS csfp_alg, IF(in_rfplansite_tble1.csfp_flow=in_rfplansite_tble2.csfp_flow,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.csfp_flow)) AS csfp_flow, IF(in_rfplansite_tble1.phase_lock_gclk=in_rfplansite_tble2.phase_lock_gclk,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.phase_lock_gclk)) AS phase_lock_gclk, IF(in_rfplansite_tble1.clkSrcFailResPer=in_rfplansite_tble2.clkSrcFailResPer,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.clkSrcFailResPer)) AS clkSrcFailResPer, IF(in_rfplansite_tble1.gproc_slots=in_rfplansite_tble2.gproc_slots,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.gproc_slots)) AS gproc_slots, IF(in_rfplansite_tble1.lta_alarm_range=in_rfplansite_tble2.lta_alarm_range,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.lta_alarm_range)) AS lta_alarm_range, IF(in_rfplansite_tble1.num_audit_retries=in_rfplansite_tble2.num_audit_retries,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.num_audit_retries)) AS num_audit_retries, IF(in_rfplansite_tble1.poorInitialAssign=in_rfplansite_tble2.poorInitialAssign,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.poorInitialAssign)) AS poorInitialAssign, IF(in_rfplansite_tble1.rach_load_type=in_rfplansite_tble2.rach_load_type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.rach_load_type)) AS rach_load_type, IF(in_rfplansite_tble1.rf_res_ind_period=in_rfplansite_tble2.rf_res_ind_period,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.rf_res_ind_period)) AS rf_res_ind_period, IF(in_rfplansite_tble1.rsl_rate=in_rfplansite_tble2.rsl_rate,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.rsl_rate)) AS rsl_rate, IF(in_rfplansite_tble1.tchBusyCrtThrshd=in_rfplansite_tble2.tchBusyCrtThrshd,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.tchBusyCrtThrshd)) AS tchBusyCrtThrshd, IF(in_rfplansite_tble1.tchBusyNrmThrshd=in_rfplansite_tble2.tchBusyNrmThrshd,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.tchBusyNrmThrshd)) AS tchBusyNrmThrshd, IF(in_rfplansite_tble1.waitForReselect=in_rfplansite_tble2.waitForReselect,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.waitForReselect)) AS waitForReselect, IF(in_rfplansite_tble1.mms_config_type=in_rfplansite_tble2.mms_config_type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.mms_config_type)) AS mms_config_type, IF(in_rfplansite_tble1.ts_alloc_flag=in_rfplansite_tble2.ts_alloc_flag,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ts_alloc_flag)) AS ts_alloc_flag, IF(in_rfplansite_tble1.gclk_qwarm_flag=in_rfplansite_tble2.gclk_qwarm_flag,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.gclk_qwarm_flag)) AS gclk_qwarm_flag, IF(in_rfplansite_tble1.phase_lock_retry=in_rfplansite_tble2.phase_lock_retry,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.phase_lock_retry)) AS phase_lock_retry, IF(in_rfplansite_tble1.Calibrate_flag=in_rfplansite_tble2.Calibrate_flag,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Calibrate_flag)) AS Calibrate_flag, IF(in_rfplansite_tble1.Configtypelastcal=in_rfplansite_tble2.Configtypelastcal,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Configtypelastcal)) AS Configtypelastcal, IF(in_rfplansite_tble1.ber_loss_daily=in_rfplansite_tble2.ber_loss_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ber_loss_daily)) AS ber_loss_daily, IF(in_rfplansite_tble1.ber_loss_hourly=in_rfplansite_tble2.ber_loss_hourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ber_loss_hourly)) AS ber_loss_hourly, IF(in_rfplansite_tble1.red_loss_daily=in_rfplansite_tble2.red_loss_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_loss_daily)) AS red_loss_daily, IF(in_rfplansite_tble1.red_loss_hourly=in_rfplansite_tble2.red_loss_hourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_loss_hourly)) AS red_loss_hourly, IF(in_rfplansite_tble1.red_loss_oos=in_rfplansite_tble2.red_loss_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_loss_oos)) AS red_loss_oos, IF(in_rfplansite_tble1.red_loss_restore=in_rfplansite_tble2.red_loss_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_loss_restore)) AS red_loss_restore, IF(in_rfplansite_tble1.red_time_oos=in_rfplansite_tble2.red_time_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_time_oos)) AS red_time_oos, IF(in_rfplansite_tble1.red_time_restore=in_rfplansite_tble2.red_time_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.red_time_restore)) AS red_time_restore, IF(in_rfplansite_tble1.remoteLossRestore=in_rfplansite_tble2.remoteLossRestore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remoteLossRestore)) AS remoteLossRestore, IF(in_rfplansite_tble1.slip_loss_daily=in_rfplansite_tble2.slip_loss_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.slip_loss_daily)) AS slip_loss_daily, IF(in_rfplansite_tble1.slip_loss_hourly=in_rfplansite_tble2.slip_loss_hourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.slip_loss_hourly)) AS slip_loss_hourly, IF(in_rfplansite_tble1.slip_loss_oos=in_rfplansite_tble2.slip_loss_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.slip_loss_oos)) AS slip_loss_oos, IF(in_rfplansite_tble1.slip_loss_restore=in_rfplansite_tble2.slip_loss_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.slip_loss_restore)) AS slip_loss_restore, IF(in_rfplansite_tble1.sync_loss_restore=in_rfplansite_tble2.sync_loss_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_loss_restore)) AS sync_loss_restore, IF(in_rfplansite_tble1.sms_dl_allowed=in_rfplansite_tble2.sms_dl_allowed,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sms_dl_allowed)) AS sms_dl_allowed, IF(in_rfplansite_tble1.sms_tch_chan=in_rfplansite_tble2.sms_tch_chan,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sms_tch_chan)) AS sms_tch_chan, IF(in_rfplansite_tble1.sms_ul_allowed=in_rfplansite_tble2.sms_ul_allowed,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sms_ul_allowed)) AS sms_ul_allowed, IF(in_rfplansite_tble1.cbs_outage_cntr=in_rfplansite_tble2.cbs_outage_cntr,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.cbs_outage_cntr)) AS cbs_outage_cntr, IF(in_rfplansite_tble1.carrierFreeImmed=in_rfplansite_tble2.carrierFreeImmed,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.carrierFreeImmed)) AS carrierFreeImmed, IF(in_rfplansite_tble1.add_access_class=in_rfplansite_tble2.add_access_class,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.add_access_class)) AS add_access_class, IF(in_rfplansite_tble1.emerg_reserved=in_rfplansite_tble2.emerg_reserved,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.emerg_reserved)) AS emerg_reserved, IF(in_rfplansite_tble1.register_exp=in_rfplansite_tble2.register_exp,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.register_exp)) AS register_exp, IF(in_rfplansite_tble1.cbch_1=in_rfplansite_tble2.cbch_1,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.cbch_1)) AS cbch_1, IF(in_rfplansite_tble1.cbch_2=in_rfplansite_tble2.cbch_2,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.cbch_2)) AS cbch_2, IF(in_rfplansite_tble1.cbch_3=in_rfplansite_tble2.cbch_3,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.cbch_3)) AS cbch_3, IF(in_rfplansite_tble1.cipher_comp_ms=in_rfplansite_tble2.cipher_comp_ms,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.cipher_comp_ms)) AS cipher_comp_ms, IF(in_rfplansite_tble1.ho_complete=in_rfplansite_tble2.ho_complete,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ho_complete)) AS ho_complete, IF(in_rfplansite_tble1.channel_teardown=in_rfplansite_tble2.channel_teardown,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.channel_teardown)) AS channel_teardown, IF(in_rfplansite_tble1.bts_audit=in_rfplansite_tble2.bts_audit,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bts_audit)) AS bts_audit, IF(in_rfplansite_tble1.modeRRModifyAck=in_rfplansite_tble2.modeRRModifyAck,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.modeRRModifyAck)) AS modeRRModifyAck, IF(in_rfplansite_tble1.bssmap_t8=in_rfplansite_tble2.bssmap_t8,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bssmap_t8)) AS bssmap_t8, IF(in_rfplansite_tble1.bssmap_t10=in_rfplansite_tble2.bssmap_t10,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bssmap_t10)) AS bssmap_t10, IF(in_rfplansite_tble1.bssmap_t11=in_rfplansite_tble2.bssmap_t11,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bssmap_t11)) AS bssmap_t11, IF(in_rfplansite_tble1.ms_sapi3_est=in_rfplansite_tble2.ms_sapi3_est,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ms_sapi3_est)) AS ms_sapi3_est, IF(in_rfplansite_tble1.btsAuditResponse=in_rfplansite_tble2.btsAuditResponse,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.btsAuditResponse)) AS btsAuditResponse, IF(in_rfplansite_tble1.bssmap_t14=in_rfplansite_tble2.bssmap_t14,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bssmap_t14)) AS bssmap_t14, IF(in_rfplansite_tble1.bcch_info=in_rfplansite_tble2.bcch_info,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.bcch_info)) AS bcch_info, IF(in_rfplansite_tble1.sacch_info=in_rfplansite_tble2.sacch_info,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sacch_info)) AS sacch_info, IF(in_rfplansite_tble1.channel_act=in_rfplansite_tble2.channel_act,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.channel_act)) AS channel_act, IF(in_rfplansite_tble1.mode_modify=in_rfplansite_tble2.mode_modify,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.mode_modify)) AS mode_modify, IF(in_rfplansite_tble1.initSyncTimer=in_rfplansite_tble2.initSyncTimer,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.initSyncTimer)) AS initSyncTimer, IF(in_rfplansite_tble1.ulSyncTimer=in_rfplansite_tble2.ulSyncTimer,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ulSyncTimer)) AS ulSyncTimer, IF(in_rfplansite_tble1.dlSyncTimer=in_rfplansite_tble2.dlSyncTimer,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.dlSyncTimer)) AS dlSyncTimer, IF(in_rfplansite_tble1.hdsl_snr_hourly=in_rfplansite_tble2.hdsl_snr_hourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_hourly)) AS hdsl_snr_hourly, IF(in_rfplansite_tble1.hdsl_snr_daily=in_rfplansite_tble2.hdsl_snr_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_daily)) AS hdsl_snr_daily, IF(in_rfplansite_tble1.hdsl_snr_hrly_prd=in_rfplansite_tble2.hdsl_snr_hrly_prd,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_hrly_prd)) AS hdsl_snr_hrly_prd, IF(in_rfplansite_tble1.hdsl_snr_daly_prd=in_rfplansite_tble2.hdsl_snr_daly_prd,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_daly_prd)) AS hdsl_snr_daly_prd, IF(in_rfplansite_tble1.hdsl_snr_oos=in_rfplansite_tble2.hdsl_snr_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_oos)) AS hdsl_snr_oos, IF(in_rfplansite_tble1.hdsl_snr_restore=in_rfplansite_tble2.hdsl_snr_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_snr_restore)) AS hdsl_snr_restore, IF(in_rfplansite_tble1.hdsl_losw_oos=in_rfplansite_tble2.hdsl_losw_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_losw_oos)) AS hdsl_losw_oos, IF(in_rfplansite_tble1.hdsl_losw_restore=in_rfplansite_tble2.hdsl_losw_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.hdsl_losw_restore)) AS hdsl_losw_restore, IF(in_rfplansite_tble1.static_sync_timer=in_rfplansite_tble2.static_sync_timer,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.static_sync_timer)) AS static_sync_timer, IF(in_rfplansite_tble1.percent_traf_cs=in_rfplansite_tble2.percent_traf_cs,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.percent_traf_cs)) AS percent_traf_cs, IF(in_rfplansite_tble1.ts_sharing=in_rfplansite_tble2.ts_sharing,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.ts_sharing)) AS ts_sharing, IF(in_rfplansite_tble1.dynet_retry_time=in_rfplansite_tble2.dynet_retry_time,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.dynet_retry_time)) AS dynet_retry_time, IF(in_rfplansite_tble1.longitude=in_rfplansite_tble2.longitude,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.longitude)) AS longitude, IF(in_rfplansite_tble1.latitude=in_rfplansite_tble2.latitude,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.latitude)) AS latitude, IF(in_rfplansite_tble1.guiState=in_rfplansite_tble2.guiState,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.guiState)) AS guiState, IF(in_rfplansite_tble1.remote_loss_daily=in_rfplansite_tble2.remote_loss_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remote_loss_daily)) AS remote_loss_daily, IF(in_rfplansite_tble1.remoteLossHourly=in_rfplansite_tble2.remoteLossHourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remoteLossHourly)) AS remoteLossHourly, IF(in_rfplansite_tble1.remote_loss_oos=in_rfplansite_tble2.remote_loss_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remote_loss_oos)) AS remote_loss_oos, IF(in_rfplansite_tble1.remote_time_oos=in_rfplansite_tble2.remote_time_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remote_time_oos)) AS remote_time_oos, IF(in_rfplansite_tble1.remoteTimeRestore=in_rfplansite_tble2.remoteTimeRestore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.remoteTimeRestore)) AS remoteTimeRestore, IF(in_rfplansite_tble1.sync_loss_daily=in_rfplansite_tble2.sync_loss_daily,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_loss_daily)) AS sync_loss_daily, IF(in_rfplansite_tble1.sync_loss_hourly=in_rfplansite_tble2.sync_loss_hourly,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_loss_hourly)) AS sync_loss_hourly, IF(in_rfplansite_tble1.sync_loss_oos=in_rfplansite_tble2.sync_loss_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_loss_oos)) AS sync_loss_oos, IF(in_rfplansite_tble1.sync_time_oos=in_rfplansite_tble2.sync_time_oos,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_time_oos)) AS sync_time_oos, IF(in_rfplansite_tble1.sync_time_restore=in_rfplansite_tble2.sync_time_restore,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.sync_time_restore)) AS sync_time_restore, IF(in_rfplansite_tble1.SW_Loadversion=in_rfplansite_tble2.SW_Loadversion,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.SW_Loadversion)) AS SW_Loadversion, IF(in_rfplansite_tble1.Cabinet_Count=in_rfplansite_tble2.Cabinet_Count,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Cabinet_Count)) AS Cabinet_Count, IF(in_rfplansite_tble1.Cabinet_Type=in_rfplansite_tble2.Cabinet_Type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Cabinet_Type)) AS Cabinet_Type, IF(in_rfplansite_tble1.Frequency_Type=in_rfplansite_tble2.Frequency_Type,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Frequency_Type)) AS Frequency_Type, IF(in_rfplansite_tble1.Path_Count=in_rfplansite_tble2.Path_Count,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Path_Count)) AS Path_Count, IF(in_rfplansite_tble1.RSL_Count=in_rfplansite_tble2.RSL_Count,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.RSL_Count)) AS RSL_Count, IF(in_rfplansite_tble1.RTF_Count_Per_Site=in_rfplansite_tble2.RTF_Count_Per_Site,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.RTF_Count_Per_Site)) AS RTF_Count_Per_Site, IF(in_rfplansite_tble1.Cell_Count_Per_Site=in_rfplansite_tble2.Cell_Count_Per_Site,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.Cell_Count_Per_Site)) AS Cell_Count_Per_Site, IF(in_rfplansite_tble1.RTF_Count_Per_Cell=in_rfplansite_tble2.RTF_Count_Per_Cell,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.RTF_Count_Per_Cell)) AS RTF_Count_Per_Cell, IF(in_rfplansite_tble1.n_900=in_rfplansite_tble2.n_900,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.n_900)) AS n_900, IF(in_rfplansite_tble1.n_1800=in_rfplansite_tble2.n_1800,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.n_1800)) AS n_1800, IF(in_rfplansite_tble1.DualBand_Enabled=in_rfplansite_tble2.DualBand_Enabled,' ',CONCAT(in_rfplansite_tble1.fm_site_type,' -- ', in_rfplansite_tble2.DualBand_Enabled)) AS DualBand_Enabled FROM in_rfplansite_tble1 INNER JOIN in_rfplansite_tble2 ON (in_rfplansite_tble1.SITE_NUMBER=in_rfplansite_tble2.SITE_NUMBER) AND (in_rfplansite_tble1.BSS_NAME=in_rfplansite_tble2.BSS_NAME) WHERE in_rfplansite_tble1.dataa=%s and in_rfplansite_tble2.datad=%s GROUP BY in_rfplansite_tble1.dataa, in_rfplansite_tble2.datad, in_rfplansite_tble1.BSS_NAME, in_rfplansite_tble1.SITE_NUMBER", GetSQLValueString($colname_Recordset1, "date"),GetSQLValueString($colname1_Recordset1, "date"));
$Recordset1 = mysql_query($query_Recordset1, $tool_tmn) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

mysql_free_result($Recordset1);

function exportMysqlToCsv($table,$filename = 'exportado.csv')

{

 $csv_terminated = "\n";
 $csv_separator = ";";
 $csv_enclosed = '"';
 $csv_escaped = "\\";
 $sql_query = '$query_Recordset1'; //Modifique aqui para gerar a consulta desejada
 // Buscando os dados do BD
 $result = mysql_query($sql_query);
 $fields_cnt = mysql_num_fields($result);
 $schema_insert = '';
 for ($i = 0; $i < $fields_cnt; $i++)
 {
 $l = $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed,
 stripslashes(mysql_field_name($result, $i))) . $csv_enclosed;
 $schema_insert .= $l;
 $schema_insert .= $csv_separator;
 }
 $out = trim(substr($schema_insert, 0, -1));
 $out .= $csv_terminated;

 while ($row = mysql_fetch_array($result))
 {
 $schema_insert = '';
 for ($j = 0; $j < $fields_cnt; $j++)
 {
 if ($row[$j] == '0' || $row[$j] != '')
 {
 if ($csv_enclosed == '')
 {
 $schema_insert .= $row[$j];
 } else
 {
 $schema_insert .= $csv_enclosed .
 str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $row[$j]) . $csv_enclosed;
 }
 } else
 {
 $schema_insert .= '';
 }
 if ($j < $fields_cnt - 1)
 {
 $schema_insert .= $csv_separator;
 }
 } // end for
 $out .= $schema_insert;
 $out .= $csv_terminated;
 } // end while
 header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
 header("Content-Length: " . strlen($out));

 //header("Content-type: text/x-csv");
 //header("Content-type: text/csv");
 header("Content-type: application/csv");
 header("Content-Disposition: attachment; filename=$filename");
 echo $out;
 exit;
}

?>