You are close. The select tag needs the id "from_date" if you want to use
that selector in the jQuery:
<select name="from_date" id="from_date">
Also, one of the options in the list needs to be set as the default option.
Perhaps this would work for you:
$first = true;
while ($row = mysql_fetch_array($result)){
$default = ($first) ? 'selected="selected"' : '';
$first = false;
echo "<option value=\"{$row['from_date']}\" $default
>{$row['from_date']}</option>";
}
which sets the first result returned in the query as the default.
Give that a try and see how it does for you.
On Sunday, January 13, 2013 3:51:12 AM UTC-5, triple_6 wrote:
>
> in attach new files.
> Can you see is this is correct:)
> Many many thanks :)
>
> W dniu niedziela, 13 stycznia 2013 04:24:53 UTC+1 użytkownik asgallant
> napisał:
>>
>> You're not sending the "from_date" in the AJAX call. You need to add
>> that, like this:
>>
>> var jsonData =$.ajax({
>> url: "goo2.php",
>> data: {
>> // pick anything you want here, or grab from the form
>> // the form's date select doesn't have the values set
>> // and doesn't have a default selection, so setting that on load wouldn't
>> work as is
>> from_date: '2011-01-01'
>> },
>> dataType:"json",
>> async: false
>> }).responseText;
>>
>> If you want to change the chart based on the user's selection, then you
>> will have to hook an "onchange" event listener for the select dropdown to
>> pull the newly selected value and requery.
>> On Saturday, January 12, 2013 7:28:16 PM UTC-5, triple_6 wrote:
>>>
>>> Hi,
>>> i have still problem with post data...
>>> in attach my files.
>>> when i set "date from" and click submit, files "goo2.php" generates
>>> correct array, but this array is not import back to "index.php".
>>> Please could somebody help me? :(
>>>
>>>
>>> W dniu czwartek, 13 grudnia 2012 08:22:00 UTC+1 użytkownik Chrystopher
>>> Medina napisał:
>>>>
>>>>
>>>>
>>>> i didn´t understand very well ... excuse me. but
>>>> this is my new json array :
>>>>
>>>> {"cols":[{"label":"Type","type":"string"},{"label":"Count","type":"number"},{"label":"Aspecto","type":"number"}],"rows":[{"c":[{"v":"excelent"},{"v":1}]},{"c":[{"v":"good"},{"v":2}]},{"c":[{"v":"fair"},{"v":1}]},{"c":[{"v":"poor"},{"v":1}]},{"c":[{"v":"word
>>>>
>>>> of mouth recomendation"},{"v":3}]},{"c":[{"v":"magazine
>>>> advertisement"},{"v":1}]},{"c":[{"v":"roadside
>>>> advertisement"},{"v":1}]},{"c":[{"v":"google"},{"v":3}]}]}.
>>>>
>>>> this is my php file:
>>>>
>>>> <?php
>>>> $var1="$_POST[fecha1]";
>>>>
>>>> $var2= "$_POST[fecha2]";
>>>>
>>>> $server="localhost";
>>>> $username="root";
>>>> $password="chrystopher";
>>>> $databasename="encuestasavandaro";
>>>>
>>>> $con = mysql_connect($server,$username,$password) or die ('Error
>>>> connecting to server');
>>>> mysql_select_db($databasename,$con);
>>>>
>>>> $query = "SELECT b.id_respuesta , COUNT(b.id_respuesta) AS cnt,
>>>> b.id_aspecto
>>>> FROM huesped a, rompe_encuesta b
>>>> WHERE
>>>> b.id_huesped = a.id_huesped AND
>>>> ((b.id_aspecto = 1 AND b.id_respuesta >= 8 AND b.id_respuesta <= 11)
>>>> OR
>>>> (b.id_aspecto = 2 AND b.id_respuesta >= 1 AND b.id_respuesta <= 4))
>>>> AND
>>>> a.fecha BETWEEN '2012-12-01' AND '2012-12-12'
>>>> GROUP BY b.id_respuesta;";
>>>>
>>>>
>>>> $table = array();
>>>>
>>>> $table['cols']=array(
>>>> array('label' => 'Type' , 'type' => 'string'),
>>>> array('label' => 'Count' , 'type' => 'number'),
>>>> array('label' => 'Aspecto', 'type' => 'number')
>>>> );
>>>>
>>>> $rows = array();
>>>> if (!mysql_query($query,$con))
>>>> {
>>>> die('Error: ' . mysql_error());
>>>> }else{
>>>>
>>>> $sqlquery= mysql_query($query);
>>>> while($r = mysql_fetch_assoc($sqlquery)){
>>>> $temp = array();
>>>> // using (int) $variable typecasts the variable as an integer, usefull
>>>> when the SQL is returning numbers as strings
>>>>
>>>> switch ((int) $r['id_respuesta']) {
>>>>
>>>> case 1:
>>>> $type='excelent';
>>>> break;
>>>> case 2:
>>>> $type='good';
>>>> break;;
>>>> case 3:
>>>> $type='fair';
>>>> break;
>>>> case 4:
>>>> $type='poor';
>>>> break;
>>>>
>>>> case 8:
>>>> $type = 'word of mouth recomendation';
>>>> break;
>>>> case 9:
>>>> $type = 'magazine advertisement';
>>>> break;
>>>> case 10:
>>>> $type = 'roadside advertisement';
>>>> break;
>>>> case 11:
>>>> $type = 'google';
>>>> break;
>>>> default:
>>>> die('{"error":"Error in SQL query: unknown \'id_respuesta\'"}');
>>>> }
>>>>
>>>> $temp[] = array('v' => $type);
>>>> $temp[] = array('v' => (int) $r['cnt']);
>>>> $rows[] = array('c' => $temp);
>>>> }
>>>> }
>>>> $table['rows'] = $rows;
>>>>
>>>> $jsonTable = json_encode($table);
>>>> echo $jsonTable;
>>>>
>>>> ?>
>>>>
>>>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/-j_ZB1jDhVgJ.
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.
