While Loop Issue + Array

obrienkev

Hi all,

How do I get $class_time value into the array in the 2nd while loop?

$query = "SELECT class_date, time_start, time_end ".
		"FROM class ".
		"WHERE course_ID = '$course' ".
		"AND location_ID = '$location'";  

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{
$class_time = $row['time_start'].'-'.$row['time_end'];
echo '<br /><br />TIME:'.$class_time.'<br /><br />';

while($row = mysql_fetch_object($result))
{
  $selectorData[] = array(
     CS_SOURCE_ID=>$row->class_date, 
     CS_SOURCE_LABEL=>$row->class_date, 
     CS_TARGET_ID=>$class_time, 
     CS_TARGET_LABEL=>$row->$class_time);
} }

imi_99

try like this if it works but not sure

while($row = mysql_fetch_array($result))
{
$class_time = $row['time_start'].'-'.$row['time_end'];
echo ' TIME:'.$class_time.' ';

while($row = mysql_fetch_object($result))
{
$class_time = $row['time_start'].'-'.$row['time_end'];
$selectorData[] = array(
CS_SOURCE_ID=>$row->class_date,
CS_SOURCE_LABEL=>$row->class_date,
CS_TARGET_ID=>$class_time,
CS_TARGET_LABEL=>$row->$class_time);
} }

imi_99

sorry like this, hopefully be ok.

while($row = mysql_fetch_object($result))
{
$class_time = $row['time_start'].'-'.$row['time_end'];
echo ' TIME:'.$class_time.' ';

$selectorData[] = array(
CS_SOURCE_ID=>$row->class_date,
CS_SOURCE_LABEL=>$row->class_date,
CS_TARGET_ID=>$class_time,
CS_TARGET_LABEL=>$row->$class_time);
}

devinemke

is there a specific reason you need to nest your while loops like that? wouldn't this be simpler?

$result = mysql_query("SELECT class_date, time_start, time_end FROM class WHERE course_ID = '$course' AND location_ID = '$location'") or die(mysql_error()); 
while ($row = mysql_fetch_assoc($result))
{ 
	$class_time = $row['time_start'] . '-' . $row['time_end'];
	$array['class_date'] = $row['class_date'];
	$array['class_time'] = $class_time;
	$selectorData[] = $array;
}

print_r($selectorData);

obrienkev

Hi devinemke,

Thanks for that. However, where do I set the below id, label values?

$selectorData[] = array(
        CS_SOURCE_ID=>$row->class_date, 
        CS_SOURCE_LABEL=>$row->class_date, 
        CS_TARGET_ID=>$class_time, 
     	CS_TARGET_LABEL=>$class_time);