Checkbox data

Development
1

hi all,

i have checkboxes on my odk phone, data is saved in the aggregate
database...i would now like to retrieve ALL checkboxes which were selected,
from the aggreagate...i have the code below:

$query="select * from follow_up_oral_medicine_location";
$result = mysql_query($query) or die("Error 1" . mysql_error());
$num_rows = mysql_num_rows($result) or die(mysql_error());

while($info=mysql_fetch_array($result))
{
$location=$info['VALUE'];
}

BUT with this query, i get only one value from this table, other values
selected are not displayed; though all values are displayed in the odk
aggregate database...how do i get the same values [ALL] out of aggregate?
PLEASE HELP

2

hi all,

i have checkboxes on my odk phone, data is saved in the aggregate
database...i would now like to retrieve ALL checkboxes which were selected,
from the aggreagate...i have the code below:

$query="select * from follow_up_oral_medicine_location";
$result = mysql_query($query) or die("Error 1" . mysql_error());
$num_rows = mysql_num_rows($result) or die(mysql_error());

while($info=mysql_fetch_array
($result))
{
$location=$info['VALUE'];
}

BUT with this query, i get only one value from this table, other values
selected are not displayed; though all values are displayed in the odk
aggregate database...how do i get the same values [ALL] out of aggregate?
PLEASE HELP

3

Hi all,

i need to retrieve all values above...BUT i get only the first value with
the following code, PLEASE HELP:

$query="select * from follow_up_oral_medicine_location";
$result = mysql_query($query) or die("Error 1" . mysql_error());
$num_rows = mysql_num_rows($result) or die(mysql_error());

IF($info=mysql_fetch_array($result))
{
$location=$info['VALUE'];
}

4

Thapelo,

These questions are not appropriate for this group.

If you have question about how ODK Aggregate stores data, I can assist, but
we cannot help you debug your own application code.

Mitch

ยทยทยท On Mon, Jan 16, 2012 at 11:56 PM, Thapelo Khumomotse < thapelo.khumomotse@gmail.com> wrote:

Hi all,

i need to retrieve all values above...BUT i get only the first value with
the following code, PLEASE HELP:

$query="select * from follow_up_oral_medicine_location";
$result = mysql_query($query) or die("Error 1" . mysql_error());
$num_rows = mysql_num_rows($result) or die(mysql_error());

IF($info=mysql_fetch_array($result))
{
$location=$info['VALUE'];
}

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com