0)
{
while($row = mysql_fetch_array($query))
{
$customer_id = $row['customer_id'];
$delivery_timing = $row['delivery_timing'];
$delivery_amount = $row['delivery_amount'];
$coupon_id = $row['coupon_id'];
$grand_total_discount = $coupon_discount = number_format($row['coupon_discount'],2);
$date = $row['date'];
}
$qry=mysql_query("select * from customer where id = '$customer_id' ");
while($res = mysql_fetch_assoc($qry))
{
$areacat = $res['area_catagory'];
$fullname = $res['title']." ".$res['name'];
$card_number = $res['card_number'];
$dfd = mysql_query("select * from area_details where id = '$areacat' ");
while($sdfsd = mysql_fetch_array($dfd))
{
$areaname = $sdfsd['areatitle']."(".$sdfsd['areacode'].")";
}
$subareacat = $res['area_sub_catagory'];
$subareaname = "";
$dfd = mysql_query("select * from sub_area_details where id = '$subareacat' ");
while($sdfsd = mysql_fetch_array($dfd))
{
$subareaname = $sdfsd['subareatitle'];
}
$address = $res['address'].'
'. $subareaname .'
'. $areaname;
}
?>
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
THANKS!! HAVE A NICE DAY & VISIT AGAIN |