this was what i had. this is the query that u help me to do it . $query = "SELECT b.id_respuesta , COUNT(b.id_respuesta) AS cnt FROM huesped a, rompe_encuesta b WHERE b.id_huesped = a.id_huesped AND b.id_aspecto = 1 AND b.id_respuesta >= 8 AND //u remember that 8=word of mouth recomendation and 9=magazine advertisement etc b.id_respuesta <= 11 AND a.fecha BETWEEN '$var1' AND '$var2' GROUP BY b.id_respuesta;";
and the second query is this .....is practycaly the same: I just change the aspect to evaluate $query = "SELECT b.id_respuesta , COUNT(b.id_respuesta) AS cnt FROM huesped a, rompe_encuesta b WHERE b.id_huesped = a.id_huesped AND b.id_aspecto = 2 AND //here b.id_respuesta >= 12 AND //here 12=excelent 13=goog 14=fair 15=poor b.id_respuesta <= 15 AND a.fecha BETWEEN '$var1' AND '$var2' GROUP BY b.id_respuesta;"; -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
