UPDATE `Customers` SET Name='Western Grove Water Association', Contact1Name='Joyce Sweet', Contact1Email='cityofwg@ritternet.com', Phone1='870-429-6686', MailToAddress1='PO Box 106', MailToAddress2='', MailToCity='Western Grove', MailToState='AR', MailToZip='72685', ShipToAddress1='28659 Hwy US 65', ShipToAddress2='Office 1', ShipToCity='Western Grove', ShipToState='AR', ShipToZipName='72685', LastUpDate='2017-05-17 12:16:29' WHERE cstID = 8278
SELECT * FROM `Customers` where instr(Name, 'Western')>0

	<form action="e_cst_update.php<?php	echo '?CstID='.$mcstID.'&AsnCode='.$mAsnCode.'&AsnName='.$arrCst[0];?>" method="post">
		<p2><label for="a0">Utility:</label><input id="a0" type="text" name="a0" value=<?php echo '"'.$arrCst[0].'"';?>></p2>
		<p2><label for="a1">Contact:</label><input id="a1" type="text" value=<?php echo '"'.$arrCst[1].'"';?>></p2>
		<p2><label for="a2">email:</label><input id="a2" type="text" value=<?php echo '"'.$arrCst[2].'"';?>></p2>
		<p2><label for="a3">Phone:</label><input id="a3" type="text" value=<?php echo '"'.$arrCst[3].'"';?>></p2>
		<p2><label for="a4">Line1 Mail:</label><input id="a4" type="text" value=<?php echo '"'.$arrCst[4].'"';?>></p2>
		<p2><label for="a5">Line2 Mail:</label><input id="a5" type="text" value=<?php echo '"'.$arrCst[5].'"';?>></p2>
		<p2><label for="a6">CSZ Mail:</label><input id="a6" type="text" value=<?php  echo '"'.$arrCst[6].' '.$arrCst[7].' '.$arrCst[8].'"'; ?>></p2>
		<p2><label for="a9">Line1-Ship:</label><input id="a9" type="text" value=<?php echo '"'.$arrCst[9].'"';?>></p2>
		<p2><label for="a10">Line2-Ship:</label><input id="a10" type="text" value=<?php echo '"'.$arrCst[10].'"';?>></p2>
		<p2><label for="a11">CSZ-Ship:</label><input id="a11" type="text" value=<?php  echo '"'.$arrCst[11].' '.$arrCst[12].' '.$arrCst[13].'"'; ?>></p2>
		<br>
		<p2><label for="a"></label><input type="submit" id="submitUpdate" value="Update Customer"></p2>
		
  </form>

  	<form action="e_cst_update.php<?php	echo '?CstID='.$mcstID.'&AsnCode='.$mAsnCode.'&AsnName='.$arrCst[0];?>" method="post">
		<p2><label for="a0">Utility:</label><input id="a0" type="text" name="a0" value=<?php echo '"'.$arrCst[0].'"';?>></p2>
		<p2><label for="a1">Contact:</label><input id="a1" type="text" value=<?php echo '"'.$arrCst[1].'"';?>></p2>
		<p2><label for="a2">email:</label><input id="a2" type="text" value=<?php echo '"'.$arrCst[2].'"';?>></p2>
		<p2><label for="a3">Phone:</label><input id="a3" type="text" value=<?php echo '"'.$arrCst[3].'"';?>></p2>
		<p2><label for="a4">Line1 Mail:</label><input id="a4" type="text" value=<?php echo '"'.$arrCst[4].'"';?>></p2>
		<p2><label for="a5">Line2 Mail:</label><input id="a5" type="text" value=<?php echo '"'.$arrCst[5].'"';?>></p2>

		<p2>
		<label for="a6">CSZ Mail:</label>
		<input id="a6" type="text" value=<?php  echo '"'.$arrCst[6].' "'; ?>>
		<input id="a7" type="text" value=<?php  echo '"'.$arrCst[7].' "'; ?>>
		<input id="a8" type="text" value=<?php  echo '"'.$arrCst[8].'"'; ?>>
		</p2>

		<p2><label for="a9">Line1-Ship:</label><input id="a9" type="text" value=<?php echo '"'.$arrCst[9].'"';?>></p2>
		<p2><label for="a10">Line2-Ship:</label><input id="a10" type="text" value=<?php echo '"'.$arrCst[10].'"';?>></p2>
		<p2><label for="a11">CSZ-Ship:</label><input id="a11" type="text" value=<?php  echo '"'.$arrCst[11].' '.$arrCst[12].' '.$arrCst[13].'"'; ?>></p2>
		<br>
		<p2><label for="a"></label><input type="submit" id="submitUpdate" value="Update Customer"></p2>
		
  </form>

  

	public $cstID = 0;
	public $GopherID = 0;
	public $FAsn_Code = "xX";
	public $Name = "xX";
	public $MailToAddress1 = "xX";
	public $MailToAddress2 = "xX";
	public $MailToCity = "xX";
	public $MailToState = "xX";
	public $MailToZip = "xX";
	public $ShipToAddress1 = "xX";
	public $ShipToAddress2 = "xX";
	public $ShipToCity = "xX";
	public $ShipToState = "xX";
	public $ShipToZip = "xX";
	public $Contact1Name = "xX";
	public $Contact1Email = "xX";
	public $Contact2Name = "xX";
	public $Contact2Email = "xX";
	public $Phone1 = "xX";
	public $Phone2 = "xX";
	public $LookUp = "xX";
	public $TypeCst1 = "xX";
	public $TypeCst2 = "xX";
	public $UDvarchar10 = "xX";
	public $UDvarchar20 = "xX";
	public $UDvarchar30 = "xX";

		public $cstID = 0;
	public $GopherID = 0;
	public $FAsn_Code = "xX";
	public $Name = "xX";
	public $MailToAddress1 = "xX";
	public $MailToAddress2 = "xX";
	public $MailToCity = "xX";
	public $MailToState = "xX";
	public $MailToZip = "xX";
	public $ShipToAddress1 = "xX";
	public $ShipToAddress2 = "xX";
	public $ShipToCity = "xX";
	public $ShipToState = "xX";
	public $ShipToZip = "xX";
	public $Contact1Name = "xX";
	public $Contact1Email = "xX";
	public $Contact2Name = "xX";
	public $Contact2Email = "xX";
	public $Phone1 = "xX";
	public $Phone2 = "xX";
	public $LookUp = "xX";
	public $TypeCst1 = "xX";
	public $TypeCst2 = "xX";
	public $UDvarchar10 = "xX";
	public $UDvarchar20 = "xX";
	public $UDvarchar30 = "xX";