"; echo " CODE COMPANY NAME ADDRESS CITY STATUS "; while($row=mysql_fetch_array($result)){ echo ""; echo "".$row['comp_code'].""; echo "".$row['comp_name'].""; echo "".$row['comp_address'].""; echo "".$row['comp_city'].""; echo ""; if($row['comp_status']==1){echo 'Active';}else{echo 'InActive';} echo ""; echo ""; } echo ""; exit(); } ?>