include("../private/conexion.php"); $db = new MySQL(''); $result = $db->consulta("SELECT distinct modelo, replace(modelo,' ','_') as id from forfaits where active=1 and modelo<>'TODOS' order by modelo"); if($db->num_rows($result)>0){ //$resultados = $db->fetch_array($consulta); while ($row = mysql_fetch_array($result)) { $eventsArray['id'] = utf8_encode($row['id']); $eventsArray['name'] = 'CITROËN '.utf8_encode($row['modelo']); $events[] = $eventsArray; } //print_r($events); } $result2 = $db->consulta("SELECT id,name from provinces where name not in ('Andorra','Ceuta') order by name"); if($db->num_rows($result2)>0){ //$resultados = $db->fetch_array($consulta); while ($row2 = mysql_fetch_array($result2)) { $eventsArray['id'] = utf8_encode($row2['id']); $eventsArray['name'] = utf8_encode($row2['name']); $events2[] = $eventsArray; } //print_r($events); } ?>