Fix_DB.php

<?php
	/***************************************************************************/
	include_once("inc/config.php");
	include_once("inc/session.php");
	include_once("inc/functions.php");

	$db = mysql_connect($db_host, $db_user, $db_pass);
	mysql_select_db($db_db, $db);
	$fix_sch	=	"SELECT `score_scha`, `score_schb` FROM `sb_temp` ORDER BY `score_scha`, `score_schb`;";
	$fix_res	=	mysql_query($fix_sch);
	$row_ray	=	array();
	$val_cnt	=	0;
	while ($row = mysql_fetch_array($fix_res, MYSQL_NUM)) {
		$vlen	=	strlen ( trim ( $row[1] ) );
//		$ival	=	bin2hex ( trim ( $row[1] ) );
		$ival	=	substr ( trim ( $row[1] ),0, $vlen );
		echo "I=> $ival <br>\n";
		if ( is_string ( $ival ) ) {
			$val_cnt++;
			array_push($row_ray, "$val_cnt", "$ival");
		}	// end if is_string ( $ival )
	}		// end while
	array_unique ( sort ( $row_ray ) );
	foreach ( $row_ray as $key => $val ) {
//		$rval	=	trim ( substr ( $val,4 ) );
//		if ( is_numeric ( $rval ) ) { continue; }
		echo "K=> $key V=> $val <br>\n";
	}	// end foreach



?>
This is not trapping and eliminating the numeric values.

Results:

K=> 0 V=> row=1 <br>
K=> 1 V=> row=10 <br>
K=> 2 V=> row=100 <br>
K=> 3 V=> row=101 <br>
K=> 4 V=> row=102 <br>
K=> 5 V=> row=103 <br>
K=> 6 V=> row=104 <br>
K=> 7 V=> row=105 <br>
K=> 8 V=> row=106 <br>
K=> 9 V=> row=107 <br>
K=> 10 V=> row=108 <br>
K=> 11 V=> row=109 <br>
K=> 12 V=> row=11 <br>
K=> 13 V=> row=110 <br>
K=> 14 V=> row=111 <br>
K=> 15 V=> row=112 <br>
K=> 16 V=> row=113 <br>
K=> 17 V=> row=114 <br>
K=> 18 V=> row=115 <br>
K=> 19 V=> row=116 <br>
K=> 20 V=> row=117 <br>
K=> 21 V=> row=118 <br>
K=> 22 V=> row=119 <br>
K=> 23 V=> row=12 <br>
K=> 24 V=> row=120 <br>
K=> 25 V=> row=121 <br>
K=> 26 V=> row=122 <br>
K=> 27 V=> row=123 <br>
K=> 28 V=> row=124 <br>
K=> 29 V=> row=125 <br>
K=> 30 V=> row=126 <br>
K=> 31 V=> row=127 <br>
K=> 32 V=> row=128 <br>
K=> 33 V=> row=129 <br>
K=> 34 V=> row=13 <br>
K=> 35 V=> row=130 <br>
K=> 36 V=> row=131 <br>
K=> 37 V=> row=132 <br>
K=> 38 V=> row=133 <br>
K=> 39 V=> row=134 <br>
K=> 40 V=> row=135 <br>
K=> 41 V=> row=136 <br>
K=> 42 V=> row=137 <br>
K=> 43 V=> row=138 <br>
K=> 44 V=> row=139 <br>
K=> 45 V=> row=14 <br>
K=> 46 V=> row=140 <br>
K=> 47 V=> row=141 <br>
K=> 48 V=> row=142 <br>
K=> 49 V=> row=143 <br>
K=> 50 V=> row=144 <br>
K=> 51 V=> row=145 <br>
K=> 52 V=> row=146 <br>
K=> 53 V=> row=147 <br>
K=> 54 V=> row=148 <br>
K=> 55 V=> row=149 <br>
K=> 56 V=> row=15 <br>
K=> 57 V=> row=150 <br>
K=> 58 V=> row=151 <br>
K=> 59 V=> row=152 <br>
K=> 60 V=> row=153 <br>
K=> 61 V=> row=154 <br>
K=> 62 V=> row=155 <br>
K=> 63 V=> row=156 <br>
K=> 64 V=> row=157 <br>
K=> 65 V=> row=158 <br>
K=> 66 V=> row=159 <br>
K=> 67 V=> row=16 <br>
K=> 68 V=> row=160 <br>
K=> 69 V=> row=161 <br>
K=> 70 V=> row=162 <br>
K=> 71 V=> row=163 <br>
K=> 72 V=> row=164 <br>
K=> 73 V=> row=165 <br>
K=> 74 V=> row=166 <br>
K=> 75 V=> row=167 <br>
K=> 76 V=> row=168 <br>
K=> 77 V=> row=169 <br>
K=> 78 V=> row=17 <br>
K=> 79 V=> row=18 <br>
K=> 80 V=> row=19 <br>
K=> 81 V=> row=2 <br>
K=> 82 V=> row=20 <br>
K=> 83 V=> row=21 <br>
K=> 84 V=> row=22 <br>
K=> 85 V=> row=23 <br>
K=> 86 V=> row=24 <br>
K=> 87 V=> row=25 <br>
K=> 88 V=> row=26 <br>
K=> 89 V=> row=27 <br>
K=> 90 V=> row=28 <br>
K=> 91 V=> row=29 <br>
K=> 92 V=> row=3 <br>
K=> 93 V=> row=30 <br>
K=> 94 V=> row=31 <br>
K=> 95 V=> row=32 <br>
K=> 96 V=> row=33 <br>
K=> 97 V=> row=34 <br>
K=> 98 V=> row=35 <br>
K=> 99 V=> row=36 <br>
K=> 100 V=> row=37 <br>
K=> 101 V=> row=38 <br>
K=> 102 V=> row=39 <br>
K=> 103 V=> row=4 <br>
K=> 104 V=> row=40 <br>
K=> 105 V=> row=41 <br>
K=> 106 V=> row=42 <br>
K=> 107 V=> row=43 <br>
K=> 108 V=> row=44 <br>
K=> 109 V=> row=45 <br>
K=> 110 V=> row=46 <br>
K=> 111 V=> row=47 <br>
K=> 112 V=> row=48 <br>
K=> 113 V=> row=49 <br>
K=> 114 V=> row=5 <br>
K=> 115 V=> row=50 <br>
K=> 116 V=> row=51 <br>
K=> 117 V=> row=52 <br>
K=> 118 V=> row=53 <br>
K=> 119 V=> row=54 <br>
K=> 120 V=> row=55 <br>
K=> 121 V=> row=56 <br>
K=> 122 V=> row=57 <br>
K=> 123 V=> row=58 <br>
K=> 124 V=> row=59 <br>
K=> 125 V=> row=6 <br>
K=> 126 V=> row=60 <br>
K=> 127 V=> row=61 <br>
K=> 128 V=> row=62 <br>
K=> 129 V=> row=63 <br>
K=> 130 V=> row=64 <br>
K=> 131 V=> row=65 <br>
K=> 132 V=> row=66 <br>
K=> 133 V=> row=67 <br>
K=> 134 V=> row=68 <br>
K=> 135 V=> row=69 <br>
K=> 136 V=> row=7 <br>
K=> 137 V=> row=70 <br>
K=> 138 V=> row=71 <br>
K=> 139 V=> row=72 <br>
K=> 140 V=> row=73 <br>
K=> 141 V=> row=74 <br>
K=> 142 V=> row=75 <br>
K=> 143 V=> row=76 <br>
K=> 144 V=> row=77 <br>
K=> 145 V=> row=78 <br>
K=> 146 V=> row=79 <br>
K=> 147 V=> row=8 <br>
K=> 148 V=> row=80 <br>
K=> 149 V=> row=81 <br>
K=> 150 V=> row=82 <br>
K=> 151 V=> row=83 <br>
K=> 152 V=> row=84 <br>
K=> 153 V=> row=85 <br>
K=> 154 V=> row=86 <br>
K=> 155 V=> row=87 <br>
K=> 156 V=> row=88 <br>
K=> 157 V=> row=89 <br>
K=> 158 V=> row=9 <br>
K=> 159 V=> row=90 <br>
K=> 160 V=> row=91 <br>
K=> 161 V=> row=92 <br>
K=> 162 V=> row=93 <br>
K=> 163 V=> row=94 <br>
K=> 164 V=> row=95 <br>
K=> 165 V=> row=96 <br>
K=> 166 V=> row=97 <br>
K=> 167 V=> row=98 <br>
K=> 168 V=> row=99 <br>
K=> 169 V=> val= S & S CONS <br>
K=> 170 V=> val=ALBA-GOLDEN <br>
K=> 171 V=> val=ALL SAINTS EPISCOPAL <br>
K=> 172 V=> val=ALL SAINTS EPISCOPAL <br>
K=> 173 V=> val=ALTO <br>
K=> 174 V=> val=ALTO <br>
K=> 175 V=> val=ANNA <br>
K=> 176 V=> val=ARGYLE <br>
K=> 177 V=> val=ARKANSAS HIGH <br>
K=> 178 V=> val=ARKANSAS HIGH <br>
K=> 179 V=> val=ARKANSAS HIGH <br>
K=> 180 V=> val=ATLANTA <br>
K=> 181 V=> val=ATLANTA <br>
K=> 182 V=> val=ATLANTA <br>
K=> 183 V=> val=BECKVILLE <br>
K=> 184 V=> val=BROOK HILL SCHOOL <br>
K=> 185 V=> val=BROWNSBORO <br>
K=> 186 V=> val=BROWNSBORO <br>
K=> 187 V=> val=BULLARD <br>
K=> 188 V=> val=CADDO MILLS <br>
K=> 189 V=> val=CANTON <br>
K=> 190 V=> val=CANTON <br>
K=> 191 V=> val=CANTON <br>
K=> 192 V=> val=CELINA <br>
K=> 193 V=> val=CENTERVILLE <br>
K=> 194 V=> val=CHAPEL HILL <br>
K=> 195 V=> val=CHAPEL HILL <br>
K=> 196 V=> val=CHINA SPRING <br>
K=> 197 V=> val=CLARKSVILLE <br>
K=> 198 V=> val=COMMERCE <br>
K=> 199 V=> val=COMMERCE <br>
K=> 200 V=> val=COMMUNITY <br>
K=> 201 V=> val=CRANDALL <br>
K=> 202 V=> val=CRANDALL <br>
K=> 203 V=> val=CRANDALL <br>
K=> 204 V=> val=CROCKETT <br>
K=> 205 V=> val=DAINGERFIELD <br>
K=> 206 V=> val=DANGERFIELD <br>
K=> 207 V=> val=DANGERFIELD <br>
K=> 208 V=> val=DAWSON <br>
K=> 209 V=> val=DETROIT <br>
K=> 210 V=> val=DIBOLL <br>
K=> 211 V=> val=EDGEWOOD <br>
K=> 212 V=> val=ELYSIAN FIELDS <br>
K=> 213 V=> val=FARMERSVILLE <br>
K=> 214 V=> val=FARMERSVILLE <br>
K=> 215 V=> val=FLOUR BLUFF <br>
K=> 216 V=> val=FORD <br>
K=> 217 V=> val=FORD <br>
K=> 218 V=> val=FORNEY <br>
K=> 219 V=> val=FOSSIL RIDGE <br>
K=> 220 V=> val=FRANKSTON <br>
K=> 221 V=> val=GAINESVILLE <br>
K=> 222 V=> val=GARRISON <br>
K=> 223 V=> val=GILMER <br>
K=> 224 V=> val=GILMER <br>
K=> 225 V=> val=GILMER <br>
K=> 226 V=> val=GLADEWATER <br>
K=> 227 V=> val=GLADEWATER <br>
K=> 228 V=> val=GRACE COMMUNITY <br>
K=> 229 V=> val=GRAND SALINE <br>
K=> 230 V=> val=GRAND SALINE <br>
K=> 231 V=> val=GRAPELAND <br>
K=> 232 V=> val=GREENVILLE <br>
K=> 233 V=> val=GROESBECK <br>
K=> 234 V=> val=GROVETON <br>
K=> 235 V=> val=HALLSVILLE <br>
K=> 236 V=> val=HALLSVILLE <br>
K=> 237 V=> val=HARDEN JEFFERSON <br>
K=> 238 V=> val=HARLETON <br>
K=> 239 V=> val=HAWKINS <br>
K=> 240 V=> val=HOOKS <br>
K=> 241 V=> val=HOOKS <br>
K=> 242 V=> val=JACKSONVILLE <br>
K=> 243 V=> val=JAOQUIN <br>
K=> 244 V=> val=JEFFERSON <br>
K=> 245 V=> val=KEMP <br>
K=> 246 V=> val=KENNEDALE <br>
K=> 247 V=> val=KILGORE <br>
K=> 248 V=> val=KILGORE <br>
K=> 249 V=> val=KILGORE <br>
K=> 250 V=> val=LEE <br>
K=> 251 V=> val=LEE <br>
K=> 252 V=> val=LEGACY CHRISTIAN <br>
K=> 253 V=> val=LIBERTY CHRISTIAN <br>
K=> 254 V=> val=LIBERTY-EYLAU <br>
K=> 255 V=> val=LIBERTY-EYLAU <br>
K=> 256 V=> val=LIBERTY-EYLAU <br>
K=> 257 V=> val=LINDALE <br>
K=> 258 V=> val=LINDALE <br>
K=> 259 V=> val=LONGVIEW <br>
K=> 260 V=> val=LUFKIN <br>
K=> 261 V=> val=MALAKOFF <br>
K=> 262 V=> val=MAUD <br>
K=> 263 V=> val=MINEOLA <br>
K=> 264 V=> val=MINEOLA <br>
K=> 265 V=> val=MINEOLA <br>
K=> 266 V=> val=MOUNT ENTERPRISE <br>
K=> 267 V=> val=MOUNT PLEASANT <br>
K=> 268 V=> val=MOUNT PLEASANT <br>
K=> 269 V=> val=MOUNT VERNON <br>
K=> 270 V=> val=MOUNT VERNON <br>
K=> 271 V=> val=NACOGDOCHES <br>
K=> 272 V=> val=NACOGDOCHES <br>
K=> 273 V=> val=NEW BOSTON <br>
K=> 274 V=> val=NEW BOSTON <br>
K=> 275 V=> val=NEW BOSTON <br>
K=> 276 V=> val=NEWTON <br>
K=> 277 V=> val=NORTH LAMAR <br>
K=> 278 V=> val=ORE CITY <br>
K=> 279 V=> val=OVERTON <br>
K=> 280 V=> val=PALESTINE <br>
K=> 281 V=> val=PALESTINE <br>
K=> 282 V=> val=PALESTINE <br>
K=> 283 V=> val=PAUL PEWITT <br>
K=> 284 V=> val=PLANO <br>
K=> 285 V=> val=PLEASANT GROVE <br>
K=> 286 V=> val=PLEASANT GROVE <br>
K=> 287 V=> val=PRINCETON <br>
K=> 288 V=> val=PRINCETON <br>
K=> 289 V=> val=PT. NECHES-GROVES <br>
K=> 290 V=> val=QUITMAN <br>
K=> 291 V=> val=QUITMAN <br>
K=> 292 V=> val=ROBINSON <br>
K=> 293 V=> val=ROYSE CITY <br>
K=> 294 V=> val=RUSK <br>
K=> 295 V=> val=RUSK <br>
K=> 296 V=> val=RUSK <br>
K=> 297 V=> val=RUSK <br>
K=> 298 V=> val=SHELBYVILLE <br>
K=> 299 V=> val=SHELBYVILLE <br>
K=> 300 V=> val=SHERMAN <br>
K=> 301 V=> val=SPLENDORA <br>
K=> 302 V=> val=SPRING HILL <br>
K=> 303 V=> val=SPRING HILL <br>
K=> 304 V=> val=SPRING HILL <br>
K=> 305 V=> val=SULPHER SPRINGS <br>
K=> 306 V=> val=SULPHER SPRINGS <br>
K=> 307 V=> val=SUNNYVALE <br>
K=> 308 V=> val=TATUM <br>
K=> 309 V=> val=TATUM <br>
K=> 310 V=> val=TATUM <br>
K=> 311 V=> val=TERRELL <br>
K=> 312 V=> val=TIMPSON <br>
K=> 313 V=> val=TROUP <br>
K=> 314 V=> val=TYLER <br>
K=> 315 V=> val=TYLER <br>
K=> 316 V=> val=UNION GROVE <br>
K=> 317 V=> val=UNION GROVE <br>
K=> 318 V=> val=VAN <br>
K=> 319 V=> val=VAN <br>
K=> 320 V=> val=VAN <br>
K=> 321 V=> val=VAN <br>
K=> 322 V=> val=VIDOR <br>
K=> 323 V=> val=WARREN <br>
K=> 324 V=> val=WASKOM <br>
K=> 325 V=> val=WASKOM <br>
K=> 326 V=> val=WEST HARDIN <br>
K=> 327 V=> val=WEST MONROE <br>
K=> 328 V=> val=WEST ORANGE-STARK <br>
K=> 329 V=> val=WESTWOOD <br>
K=> 330 V=> val=WHITE OAK <br>
K=> 331 V=> val=WHITE OAK <br>
K=> 332 V=> val=WHITEHOUSE <br>
K=> 333 V=> val=WHITEHOUSE <br>
K=> 334 V=> val=WHITESBORO <br>
K=> 335 V=> val=WILLIS POINT <br>
K=> 336 V=> val=WOODVILLE <br>
K=> 337 V=> val=WORTHAM <br>