prepare($sql); $query->execute(); $result=$query->fetchAll(PDO::FETCH_OBJ); $cnt=1; foreach($result as $value) { ?>

Sl.No.	LOCATION	DEALER NAME	CONTACT NUMBER
	dealer_name; ?>	mobile; ?>	alt_mobile; ?>	location; ?>