dod

bloody hell that worked pefeatly, i hope!

here my function function select($array){ $last_item = end($array); $last_item = each($array); reset($array); foreach($array as $key => $value){ $returnValue .= $value.','; $value; } return($returnValue); } i need $returnValue to be a string for the site or it will not work and also fr the last item to not have a comma

but i need the last item to have now comma

why implode?

foreach($array as $key => $value){ $returnValue .= $value.','; $value; } how do you make a loop like this, but the last item doesnt have a comma at the end?

thank you, you fixed it

i was talking about the var $value. it only outputs 1 value :S

why down my code ony return one item instead of all the items selected. $arr = array($date,$time,$latandlong,$satdata,$MCC,$MNC,$MCCMNC,$name,$callid,$lac,$bsic,$arfcn,$relvl,$c1,$c2,$rxq,$timing,$numres,$audio,$video,$image); foreach ($arr as $key => $value) { if (is_null($value)) { unset($arr[$key]); } } function select($array){ $last_item = end($array); $last_item = each($array); reset($array); foreach($array as $key => $value){ if($value == $last_item['value'] && $key == $last_item['key']){ echo ','; } return $value; } } if (isset($datebetween, $dateand)){$datesearch=' AND DATE(gps.date) BETWEEN '.$datebetween.' AND '.$dateand.'';} if (isset($timebetween, $timeand)){$timesearch=' AND DATE(gps.time) BETWEEN '.$timebetween.' AND '.$timeand.'';} if (isset($timebetween, $timeand)){$timesearch=' AND DATE(gps.time) BETWEEN '.$timebetween.' AND '.$timeand.'';} if (isset($lat, $long)){$latandlongsearch=' AND DATE(gps.time) BETWEEN '.$lat.' AND '.$long.'';} $query = 'SELECT '.select($arr).' FROM '.$fromdefault1.$namefrom.$fromdefault2.$fromdefault3.$numresform1.$numresform2.$audiofrom.$videofrom.$imagefrom.' WHERE '.$wheredefault.$datesearch.$timesearch.$latandlongsearch . ' '; /* Query */ echo $query; } thank you!!!!!

so how do i fix it?

This is my Mysql gen. can anyone tell me why this echos MID(networkset.networkid, 3, 3) AS "MNC" SELECT FROM scan JOIN gps ON scan.gpsid = gps.gpsid JOIN gsmscanset ON scan.scanid = gsmscanset.scanidJOIN gsmcell ON gsmscanset.cellid = gsmcell.cellid WHERE scan.typeid = 4 AND gsmcell.cellid = gsmcell.servingcellid and not SELECT MID(networkset.networkid, 3, 3) AS "MNC" FROM scan JOIN gps ON scan.gpsid = gps.gpsid JOIN gsmscanset ON scan.scanid = gsmscanset.scanidJOIN gsmcell ON gsmscanset.cellid = gsmcell.cellid WHERE scan.typeid = 4 AND gsmcell.cellid = gsmcell.servingcellid heres the code: $arr = array($date,$time,$latandlong,$satdata,$MCC,$MNC,$MCCMNC,$name,$callid,$lac,$bsic,$arfcn,$relvl,$c1,$c2,$rxq,$timing,$numres,$audio,$video,$image); function select($arr){ foreach ($arr as $key => $value) { if (is_null($value)) { unset($arr[$key]); } } $last_item = end($arr); $last_item = each($arr); reset($arr); foreach($arr as $key => $value){ if($value == $last_item['value'] && $key == $last_item['key']){ echo ','; } print $value; } } //echo '<br>'; /* FROM */ $fromdefault1=" scan JOIN gps ON scan.gpsid = gps.gpsid"; $fromdefault2=" JOIN gsmscanset ON scan.scanid = gsmscanset.scanid"; $fromdefault3="JOIN gsmcell ON gsmscanset.cellid = gsmcell.cellid"; /* WHERE */ $wheredefault="scan.typeid = 4 AND gsmcell.cellid = gsmcell.servingcellid"; if (isset($datebetween, $dateand)){$datesearch=' AND DATE(gps.date) BETWEEN '.$datebetween.' AND '.$dateand.'';} if (isset($timebetween, $timeand)){$timesearch=' AND DATE(gps.time) BETWEEN '.$timebetween.' AND '.$timeand.'';} if (isset($timebetween, $timeand)){$timesearch=' AND DATE(gps.time) BETWEEN '.$timebetween.' AND '.$timeand.'';} if (isset($lat, $long)){$latandlongsearch=' AND DATE(gps.time) BETWEEN '.$lat.' AND '.$long.'';} /* Query */ $query = " SELECT ".select($arr)." FROM ".$fromdefault1.$namefrom.$fromdefault2.$fromdefault3.$numresform1.$numresform2.$audiofrom.$videofrom.$imagefrom." WHERE ".$wheredefault.$datesearch.$timesearch.$latandlongsearch . " "; echo $query; } Thank you!!!!