( $NewV ) "; echo$trainer['vtimes'];?> "; } ?> " WIDTH="120" HEIGHT="140" BORDER=0 ALT="">   Phone   Fax   Mobile   Training Cities Training Cities: "; while($cityrow=mysql_fetch_array($cityres)){ echo "".$cityrow[city_name_e].", "; } }// end of if(1) ?> Trainer Rank =current_date() order by start_date ASC limit 5"; $sch_res=mysql_query($schedule_q); echo mysql_error(); $num=mysql_num_rows($sch_res); if(mysql_num_rows($sch_res)){ ?> "; } // end of while ($sch_row) //echo "num".$num; if ($num>=5){ $more=$trainer['more']; echo " "; } ?>   $sch_row[course_id] $sch_row[course_name] $sch_row[start_date] $sch_row[city_name_e] "; if($sch_row[start_time]){ echo "$sch_row[start_time]  $sch_row[time]"; }else{ echo $trainer['-']; } echo" "; if($sch_row[fees]){ echo""; $cu_q="select short,name_e from currency where short='$sch_row[currency]'"; $c_res=mysql_query($cu_q); while ($c_row=mysql_fetch_array($c_res)){ //echo " ".$c_row[name_e]; echo " $sch_row[fees]  $c_row[name_e]  ";} // while end } else{ echo $trainer['contact_us']; } $Register=$trainer['register']; echo" $more

0){ ?> "; $i++; if ($i>4){ $more=$trainer['more']; echo " "; break; } // end of if($i>4) } // end of while // some information $EventCount="select count(event_id)as ECount from this_event_trainer where user_id='$id'"; $EC_res=mysql_query($EventCount); echo mysql_error(); while ($EC_row=mysql_fetch_array($EC_res)){ $EC=$EC_row[ECount];} // Events Count ////////////// THis Trainer Trainee Count $TraineeCount="select count(this_event_trainer.user_id) as TCount,this_event_trainer.event_id from this_event_trainee inner join this_event_trainer on this_event_trainee.event_id=this_event_trainer.event_id where this_event_trainer.user_id='$id' group by this_event_trainee.event_id"; $TC_res=mysql_query($TraineeCount); echo mysql_error(); while($TC_row=mysql_fetch_array($TC_res)){ $TC+=$TC_row[TCount];} $Trainees_no=$shared['Trainees_no']; $event_no=$shared['event_no']; echo " "; ?>

$events_row[event_id]	$events_row[course_id]	$events_row[course_name]	$events_row[end_date]	$events_row[city_name_e]	$EventTrainee	$details
$more
$Trainees_no ($TC) || $event_no ($EC)

0) // checking 4 comments $com_q="select comments_e.*,users_e.fname_e,users_e.lname_e,training_events.event_id, training_events.end_date,training_events.course_id, this_event_trainer.user_id,course_e.course_name from training_events inner join comments_e on training_events.event_id=comments_e.event_id inner join users_e on comments_e.user_id=users_e.user_id inner join course_e on training_events.course_id=course_e.course_id inner join this_event_trainer on training_events.event_id=this_event_trainer.event_id where this_event_trainer.user_id='$id' and this_event_trainer.is_main=1 order by end_date DESC limit 5"; $com_res=mysql_query($com_q); echo mysql_error(); $com_num=mysql_num_rows($com_res); if($com_num>0){ ?> "; ?>

::
$more

".stripslashes($row['title'])." "; }// while loop end } // if(mysql_num_rows) end ?>