Here's the code I have and I think I shorten it by using an array but not 100% sure how that would work.
$wc1 = "AMTY";
$wc2 = "AR";
$wc3 = "BEVL";
$wc4 = "BGLW";
$wc5 = "BRDN";
$wc6 = "COVE";
$wc7 = "CRST";
$wc8 = "CRTH";
$wc9 = "DASY";
$wc10 = "DEQN";
$wc11 = "DLGH";
$wc12 = "DLRK";
$wc13 = "DMSC";
$wc14 = "DRCK";
$wc15 = "DRKS";
$wc16 = "EKNS";
$wc17 = "ELAN";
$wc18 = "ENOL";
$wc19 = "FRDY";
$wc20 = "GLHM";
$wc21 = "GLWD";
$wc22 = "GNBR";
$wc23 = "GRFR";
$wc24 = "H743";
$wc25 = "HORT";
$wc26 = "HRSN";
$wc27 = "HTFD";
$wc28 = "LCBG";
$wc29 = "LEOL";
$wc30 = "LESL";
$wc31 = "LTRK";
$wc32 = "MGTN";
$wc33 = "MLBY";
$wc34 = "MMLL";
$wc35 = "MRBO";
$wc36 = "MRSH";
$wc37 = "MTID";
$wc38 = "NMRD";
$wc39 = "NRMN";
$wc40 = "ODEN";
$wc41 = "OKGV";
$wc42 = "OKLN";
$wc43 = "PNGB";
$wc44 = "PRRY";
$wc45 = "PRVI";
$wc46 = "PRVL";
$wc47 = "QTMN";
$wc48 = "RSBD";
$wc49 = "RUDD";
$wc50 = "SFRC";
$wc51 = "SHRD";
$wc52 = "SPRK";
$wc53 = "STPL";
$wc54 = "SWTN";
$wc55 = "TCMN";
$wc56 = "UMPR";
$wc57 = "VILN";
$wc58 = "WCKS";
$wc59 = "WFRK";
$wc60 = "WLMT";
$wc61 = "WTSP";
$wc62 = "WYE";
$stmt = OCIParse($connection, "select '$wc1' LOCATION, $query TOTAL from $wc1$table union
select '$wc2' LOCATION, $query TOTAL from $wc2$table union
select '$wc3' LOCATION, $query TOTAL from $wc3$table union
select '$wc4' LOCATION, $query TOTAL from $wc4$table union
select '$wc5' LOCATION, $query TOTAL from $wc5$table union
select '$wc6' LOCATION, $query TOTAL from $wc6$table union
select '$wc7' LOCATION, $query TOTAL from $wc7$table union
select '$wc8' LOCATION, $query TOTAL from $wc8$table union
select '$wc9' LOCATION, $query TOTAL from $wc9$table union
select '$wc10' LOCATION, $query TOTAL from $wc10$table union
select '$wc11' LOCATION, $query TOTAL from $wc11$table union
select '$wc12' LOCATION, $query TOTAL from $wc12$table union
select '$wc13' LOCATION, $query TOTAL from $wc13$table union
select '$wc14' LOCATION, $query TOTAL from $wc14$table union
select '$wc15' LOCATION, $query TOTAL from $wc15$table union
select '$wc16' LOCATION, $query TOTAL from $wc16$table union
select '$wc17' LOCATION, $query TOTAL from $wc17$table union
select '$wc18' LOCATION, $query TOTAL from $wc18$table union
select '$wc19' LOCATION, $query TOTAL from $wc19$table union
select '$wc20' LOCATION, $query TOTAL from $wc20$table union
select '$wc21' LOCATION, $query TOTAL from $wc21$table union
select '$wc22' LOCATION, $query TOTAL from $wc22$table union
select '$wc23' LOCATION, $query TOTAL from $wc23$table union
select '$wc24' LOCATION, $query TOTAL from $wc24$table union
select '$wc25' LOCATION, $query TOTAL from $wc25$table union
select '$wc26' LOCATION, $query TOTAL from $wc26$table union
select '$wc27' LOCATION, $query TOTAL from $wc27$table union
select '$wc28' LOCATION, $query TOTAL from $wc28$table union
select '$wc29' LOCATION, $query TOTAL from $wc29$table union
select '$wc30' LOCATION, $query TOTAL from $wc30$table union
select '$wc31' LOCATION, $query TOTAL from $wc31$table union
select '$wc32' LOCATION, $query TOTAL from $wc32$table union
select '$wc33' LOCATION, $query TOTAL from $wc33$table union
select '$wc34' LOCATION, $query TOTAL from $wc34$table union
select '$wc35' LOCATION, $query TOTAL from $wc35$table union
select '$wc36' LOCATION, $query TOTAL from $wc36$table union
select '$wc37' LOCATION, $query TOTAL from $wc37$table union
select '$wc38' LOCATION, $query TOTAL from $wc38$table union
select '$wc39' LOCATION, $query TOTAL from $wc39$table union
select '$wc40' LOCATION, $query TOTAL from $wc40$table union
select '$wc41' LOCATION, $query TOTAL from $wc41$table union
select '$wc42' LOCATION, $query TOTAL from $wc42$table union
select '$wc43' LOCATION, $query TOTAL from $wc43$table union
select '$wc44' LOCATION, $query TOTAL from $wc44$table union
select '$wc45' LOCATION, $query TOTAL from $wc45$table union
select '$wc46' LOCATION, $query TOTAL from $wc46$table union
select '$wc47' LOCATION, $query TOTAL from $wc47$table union
select '$wc48' LOCATION, $query TOTAL from $wc48$table union
select '$wc49' LOCATION, $query TOTAL from $wc49$table union
select '$wc50' LOCATION, $query TOTAL from $wc50$table union
select '$wc51' LOCATION, $query TOTAL from $wc51$table union
select '$wc52' LOCATION, $query TOTAL from $wc52$table union
select '$wc53' LOCATION, $query TOTAL from $wc53$table union
select '$wc54' LOCATION, $query TOTAL from $wc54$table union
select '$wc55' LOCATION, $query TOTAL from $wc55$table union
select '$wc56' LOCATION, $query TOTAL from $wc56$table union
select '$wc57' LOCATION, $query TOTAL from $wc57$table union
select '$wc58' LOCATION, $query TOTAL from $wc58$table union
select '$wc59' LOCATION, $query TOTAL from $wc59$table union
select '$wc60' LOCATION, $query TOTAL from $wc60$table union
select '$wc61' LOCATION, $query TOTAL from $wc61$table union
select '$wc62' LOCATION, $query TOTAL from $wc62$table");
Can I put those variables into an array and then loop through it for the query or will that work?
