database query of a booking with image upload field

$db = JFactory::getDbo(); $query = "Select a.* from #__app_sch_order_items as a"         ." inner join #__app_sch_orders as b on b.id = a.order_id"         ." where b.order_status = 'A'"; $query = "Select c.*,d.fvalue from #__app_sch_fields as c inner join #__app_sch_field_data as d on d.fid = c.id  where d.order_id = '17'"; $db->setQuery($query); $rows = $db->loadObjectList(); if(count($rows) > 0){     for($i=0;$i<count($rows);$i++){         $row = $rows[$i];             echo $row->id . '<br />';             echo $row->order_name . '<br />';             echo $row->order_notes . '<br />';             echo $row->booking_date . '<br />';             echo $row->start_time . '<br />';             echo '<img src="' . Uri::root() . 'images/' .  $folder . '/fields/' . $row->fvalue . '">' . '<br />';     } }

$db->setQuery($query); $rows = $db->loadObjectList(); if(count($rows) > 0){     for($i=0;$i<count($rows);$i++){         $row = $rows[$i];             echo $row->id . '<br />';             echo $row->order_name . '<br />';             echo $row->order_notes . '<br />';             echo $row->booking_date . '<br />';             echo $row->start_time . '<br />';             echo '<img src="' . Uri::root() . 'images/' .  $folder . '/fields/' . $row->fvalue . '">' . '<br />';     } }

$query = "Select a.* from #__app_sch_order_items as a"         ." inner join #__app_sch_orders as b on b.id = a.order_id"         ." where b.order_status = 'A'";

$query = "Select * from #__app_sch_orders where order_status = 'A'";

foreach($rows as $row) { $db->setQuery("Select fvalue from #__app_sch_field_data where order_id = '$row->id' and fid = '17'"); $fieldValue = $db->loadResult(); if($fieldValue != "") { /** ..... **/ } }