$sender_email = 'info@aep.com.my';
$sender_name = 'Asia Executive Programs Sdn Bhd';
$prospectus_email = 'rayner@ablenet.com.my';
$prospectus_name = 'Rayner';
?>
Asia Executive Programs
if(isset($_GET[ttid])) {
$ttid = $_GET[ttid];
}
$connection=mysql_connect("$server", "$username", "$password")
or die("Could not establish connection");
mysql_select_db($database_name, $connection)
or die ("Could not select database");
$query = "select master_event.* ,
(DATE_FORMAT(event_datefrom, '%d %M %Y')) as datefrom,
(DATE_FORMAT(event_dateto, '%d %M %Y')) as dateto,
ucase(event_name) as eventname
from master_event
where master_event.event_id = '$ttid '";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)){
$eventname = $row['eventname'];
$eventdesc = $row['event_desc'];
$eventvenue = $row['event_venue'];
$eventfee = $row['event_fee'];
$datefrom = $row['datefrom'];
$dateto = $row['dateto'];
echo " $eventname
";
echo "Date : $datefrom - $dateto
";
echo "Venue : $eventvenue
";
echo "
";
echo "
";
$i= 0;
$querytesm = "select *
from master_testimonial
where master_testimonial.event_id = '$ttid' order by testimonial_id";
$resulttesm=mysql_query($querytesm);
while($rowtesm = mysql_fetch_array($resulttesm)){
$testimonial = $rowtesm['testimonial_desc'];
$person = $rowtesm['givenperson'];
$i = $i + 1;
echo "$testimonial
";
echo "- $person -
";
}
}
?>