Page 1 of 1

[solved] Table Code With ;

Posted: Wed Dec 06, 2006 11:07 am
by WanamakerStudios
I receive a data feed from a 3rd party company and they used AAC=; as a code for a dealer. How do I encase AAC=; so I can search against it without causing an error in my program?

Posted: Wed Dec 06, 2006 12:39 pm
by feyd
Do you mind explaining how you are searching?

Posted: Wed Dec 06, 2006 12:46 pm
by WanamakerStudios
This is the PHP/MySQL coding ...

Code: Select all

## SELECT DEALERS WITHIN ZIP CODES
	$dealer_sql = "SELECT DISTINCT CIDLOTD FROM `lotdata-temp` WHERE CZIP IN (". $zipcodes .")";
	$dealer_query = mysql_query($dealer_sql);
	while ($dealer = mysql_fetch_array($dealer_query)) {
		if($i!=0) {$dealers .= ", ";}
		$dealers .= "'". $dealer['CIDLOTD'] ."'";
		$i++;
	}
	unset($i);
echo $dealers;
This is what it outputs ...

'AACOL', 'AACXl', 'AACb[', 'AACg`', 'AACuJ', 'AAD;R', 'AAD

The end 'AAD should actually be 'AAD<0' with a few more dealer codes after it ...

Posted: Wed Dec 06, 2006 12:51 pm
by feyd
So where is this error coming in?

Posted: Wed Dec 06, 2006 12:54 pm
by WanamakerStudios
Im assuming that its coming in here ...

Code: Select all

$dealers .= "'". $dealer['CIDLOTD'] ."'";
Because I am supposed to have 6 more dealer codes after that and my while loop just seems to stop when it hits the dealer code AAD<0

Posted: Wed Dec 06, 2006 12:57 pm
by feyd
Is this happening in a browser? Have you looked at the source code? I'd imagine it's still there, just hidden because the < is understood to be an HTML tag by the browser.

htmlentities() and htmlspecialchars() may be of interest.

Posted: Wed Dec 06, 2006 1:04 pm
by WanamakerStudios
Ok. Thanks ... that fixes that ... but once I change up some of the parameters and rerun a vehicle query against the dealer data as shown:

Code: Select all

SELECT DISTINCT CVIN FROM `vehicles-temp` WHERE CIDLOTD IN ('AAAUE', 'AAAUG', 'AAAUK', 'AAAUO', 'AAAUS', 'AAAUU', 'AAAUY', 'AAAUZ', 'AAAU\', 'AAAU^', 'AAAWs', 'AAAX7', 'AAAX:', 'AAAX=', 'AAAX>', 'AAAYO', 'AAAYU', 'AAAY[', 'AAA^b', 'AAA^c', 'AAA_B', 'AAA_d', 'AAAio', 'AAAm_', 'AAAme', 'AAAmw', 'AAAmz', 'AAAn1', 'AAAo4', 'AAAop', 'AAAov', 'AAAox', 'AAAp0', 'AAAp7', 'AAAp9', 'AAAp:', 'AAAp;', 'AAAw5', 'AAAw7', 'AAAw:', 'AAAw=', 'AAAwB', 'AAAwD', 'AAAwG', 'AAB2:', 'AAB2G', 'AAB2N', 'AAB6T', 'AABBx', 'AABC0', 'AABC6', 'AABCG', 'AABPL', 'AABPp', 'AABX=', 'AABXB', 'AABZ[', 'AABZd', 'AAB`i', 'AABeZ', 'AABk@', 'AABsi', 'AABup', 'AABvn', 'AABwB', 'AAByS', 'AAC0A', 'AAC0D', 'AAC0]', 'AAC2H', 'AAC4p', 'AAC55', 'AAC5]', 'AAC8:', 'AAC9p', 'AAC<]', 'AAC=;', 'AAC=<', 'AAC=J', 'AAC@p', 'AACAO', 'AACB1', 'AACB^', 'AACCl', 'AACE3', 'AACFq', 'AACG3', 'AACG4', 'AACI1', 'AACKR', 'AACKS', 'AACNP', 'AACNQ', 'AACOL', 'AACOc', 'AACOo', 'AACOv', 'AACOw', 'AACP1', 'AACPM', 'AACP_', 'AACSc', 'AACUL', 'AACVn', 'AACW1', 'AACXk', 'AACXl', 'AACYn', 'AAC[q', 'AAC^j', 'AAC_6', 'AAC_7', 'AACbF', 'AACbG', 'AACb[', 'AACb]', 'AACg7', 'AACgD', 'AACgE', 'AACg`', 'AACga', 'AAChq', 'AAChr', 'AAClx', 'AACma', 'AACnj', 'AACrz', 'AACth', 'AACuJ', 'AAD3O', 'AAD3a', 'AAD5E', 'AAD8j', 'AAD8x', 'AAD:<', 'AAD:f', 'AAD;R', 'AAD<R', 'AAD<e', 'AAD=0', 'AAD=U', 'AAD=d', 'AADAK', 'AADBC', 'AADBT', 'AADCD', 'AADCS', 'AADEa', 'AADEb', 'AADEe', 'AADEf', 'AADI:', 'AADIM', 'AADIT', 'AADJK', 'AADJ^', 'AADKo', 'AADL8', 'AADPf', 'AADPx', 'AADQL', 'AADR8', 'AADS_', 'AADS`', 'AADSa', 'AADSb', 'AADSc', 'AADSt', 'AADTk', 'AADU5', 'AADVP', 'AADVQ', 'AADVR', 'AADWH', 'AADWL', 'AADXD', 'AADXE', 'AADY2', 'AADYV', 'AADZg', 'AAD[3', 'AAD[4', 'AAD[s', 'AAD]:', 'AAD]W', 'AAD]z', 'AAD^L', 'AAD^[', 'AAD`U', 'AAD`y', 'AADaf', 'AADc7', 'AADca', 'AADd;', 'AADdq', 'AADdr', 'AADfk', 'AADgx', 'AADh0', 'AADh1', 'AADh9', 'AADh:', 'AADiA', 'AADiO', 'AADl:', 'AADnn', 'AADpa', 'AADpm', 'AADs:', 'AADt<', 'AADtA', 'AADtB', 'AADtS', 'AADt[', 'AADuI', 'AADuM', 'AADu]', 'AADu^', 'AADuy', 'AAE24', 'AAE5i', 'AAE9;', 'AAE9=', 'AAE9t', 'AAE9w', 'AAE9x', 'AAE=y', 'AAE><', 'AAE>F', 'AAE>R', 'AAE@8', 'AAEBZ', 'AAEEV', 'AAEEd', 'AAEFs', 'AAEHV', 'AAEH`', 'AAEJ<', 'AAER<', 'AAER>', 'AAERD', 'AAERU', 'AAERY', 'AAER^', 'AAERb', 'AAERc', 'AAERm', 'AAERo', 'AAERp', 'AAERr', 'AAES1', 'AAES3', 'AAES7', 'AAES;', 'AAESK', 'AAESL', 'AAEST', 'AAESU', 'AAESX', 'AAESY', 'AAES[', 'AAES_', 'AAESa', 'AAESc', 'AAESd', 'AAESf', 'AAESg', 'AAESh', 'AAESi', 'AAESm', 'AAESn', 'AAESo', 'AAET2', 'AAET3', 'AAET4', 'AAET7', 'AAET8', 'AAET;', 'AAET<', 'AAET@', 'AAETE', 'AAETG', 'AAETI', 'AAETL', 'AAETM', 'AAETP', 'AAETQ', 'AAETS', 'AAETT', 'AAETU', 'AAETV', 'AAETY', 'AAET[', 'AAET`', 'AAETc', 'AAETd', 'AAETh', 'AAETk', 'AAETn', 'AAETo', 'AAETw', 'AAEU1', 'AAEU2', 'AAEU3', 'AAEU5', 'AAEU6', 'AAEU7', 'AAEU8', 'AAEU;', 'AAEU@', 'AAEUA', 'AAEUD', 'AAEUF', 'AAEUI', 'AAEUJ', 'AAEUL', 'AAEUM', 'AAEUN', 'AAEUO', 'AAEUX', 'AAEUY', 'AAEUZ', 'AAEU[', 'AAEUb', 'AAEUk', 'AAEUq', 'AAEUr', 'AAEUs', 'AAEUu', 'AAEUw', 'AAEV0', 'AAEV3', 'AAEVF', 'AAEVI', 'AAEVJ', 'AAEVL', 'AAEVP', 'AAEVQ', 'AAEVR', 'AAEVS', 'AAEVc', 'AAEVh', 'AAEVm', 'AAEVu', 'AAEVv', 'AAEW2', 'AAEW9', 'AAEW:', 'AAEW>', 'AAEWE', 'AAEWL', 'AAEWO', 'AAEWS', 'AAEWT', 'AAEWY', 'AAEW[', 'AAEWa', 'AAEWb', 'AAEWc', 'AAEWh', 'AAEWm', 'AAEWu', 'AAEWx', 'AAEX0', 'AAEX4', 'AAEX5', 'AAEX6', 'AAEX8', 'AAEYK', 'AAEZQ', 'AAE[T', 'AAE]B', 'AAE]H', 'AAE^_', 'AAE_`', 'AAEa^', 'AAEbt', 'AAEc^', 'AAEc`', 'AAEca', 'AAEce', 'AAEch', 'AAEci', 'AAEcj', 'AAEck', 'AAEco', 'AAEcr', 'AAEcv', 'AAEcy', 'AAEd0', 'AAEd1', 'AAEd2', 'AAEd:', 'AAEdB', 'AAEdC', 'AAEd`', 'AAEeF', 'AAEew', 'AAEfC', 'AAEfM', 'AAEgR', 'AAEgb', 'AAEgg', 'AAEiA', 'AAEiK', 'AAEjK', 'AAEjP', 'AAEjq', 'AAEk9', 'AAEl4', 'AAElk', 'AAEm7', 'AAEmm', 'AAEmr', 'AAEn`', 'AAEna', 'AAEnq', 'AAEnz', 'AAEoA', 'AAEoi', 'AAEp4', 'AAEqp', 'AAErQ', 'AAEs^', 'AAEsb', 'AAEt0', 'AAEt1', 'AAEv5', 'AAEv<', 'AAEwJ', 'AAExV', 'AAExb', 'AAExo', 'AAExp', 'AAEyp', 'AAEyq', 'AAEyu', 'AAF0L', 'AAF3D', 'AAF4@', 'AAF4l', 'AAF5>', 'AAF5b', 'AAF6N', 'AAF80', 'AAF8e', 'AAF90', 'AAF9W', 'AAF;0', 'AAF=w', 'AAF@u', 'AAFA^', 'AAFB@', 'AAFBu', 'AAFC6', 'AAFC:', 'AAFDG', 'AAFEC', 'AAFFy', 'AAFG8', 'AAFGH', 'AAFGL', 'AAFGY', 'AAFHH', 'AAFHx', 'AAFJ6', 'AAFJ]', 'AAFJ`', 'AAFJd', 'AAFK4', 'AAFK8', 'AAFKF', 'AAFLI', 'AAFLN', 'AAFLZ', 'AAFLr', 'AAFMd', 'AAFMf', 'AAFMg', 'AAFN=', 'AAFOx', 'AAFPk', 'AAFQ7', 'AAFQ_', 'AAFR4', 'AAFR8', 'AAFR9', 'AAFRz', 'AAFS2', 'AAFT=', 'AAFTP', 'AAFTQ', 'AAFTu', 'AAFU6', 'AAFVl', 'AAFWC', 'AAFW]', 'AAFX8', 'AAFXF', 'AAFXH', 'AAFY1', 'AAFY@', 'AAFYa', 'AAFYm', 'AAFZp', 'AAF[9', 'AAF[c', 'AAF^>', 'AAF^F', 'AAF_`', 'AAF_n', 'AAF_y', 'AAF`Q', 'AAF`U', 'AAF`j', 'AAFaG', 'AAFaH', 'AAFbj', 'AAFbk', 'AAFc3', 'AAFc8', 'AAFcX', 'AAFcg', 'AAFdB', 'AAFf8', 'AAFg7', 'AAFhA', 'AAFhY', 'AAFhm', 'AAFjj', 'AAFjw', 'AAFl=', 'AAFlV', 'AAFmQ', 'AAFn@', 'AAFnC', 'AAFnn', 'AAFok', 'AAFp2', 'AAFpY', 'AAFq8', 'AAFqE', 'AAFrn', 'AAFs=', 'AAFsE', 'AAFsP', 'AAFsr', 'AAFss', 'AAFt3', 'AAFtz', 'AAFuO', 'AAFuR', 'AAFuY', 'AAFue', 'AAFv0', 'AAFw9', 'AAFwE', 'AAFwb', 'AAFx0', 'AAFx;', 'AAFxJ', 'AAFxS', 'AAFzF', 'AAFz_', 'AAFza', 'AAG0J', 'AAG0_', 'AAG0`', 'AAG0b', 'AAG0v', 'AAG1a', 'AAG1b', 'AAG2=', 'AAG2Z', 'AAG2c', 'AAG3e', 'AAG3f', 'AAG3z', 'AAG40', 'AAG49', 'AAG4u', 'AAG5;', 'AAG5K', 'AAG5R', 'AAG5X', 'AAG63', 'AAG6@', 'AAG7b', 'AAG7q', 'AAG7y', 'AAG;s', 'AAG;w', 'AAG<7', 'AAG<=', 'AAG<K', 'AAG<d', 'AAG=N', 'AAG=f', 'AAG=p', 'AAG=q', 'AAG>1', 'AAG><', 'AAG>F', 'AAG@C', 'AAG@L', 'AAG@M', 'AAG@N', 'AAG@]', 'AAG@`', 'AAG@a', 'AAG@d', 'AAG@e', 'AAG@f', 'AAG@g', 'AAG@h', 'AAGAF', 'AAGAP', 'AAIzm', 'AAO=3', 'AAO=<', 'AAO=e', 'AAO=k', 'AAOFu', 'AAOGH', 'AAOGT', 'AAOGi', 'AAOGl', 'AAOGm', 'AAOGy', 'AAOHU', 'AAQ30', 'AAQ3C', 'AAQ3]', 'AAQ3j', 'AAQ4C', 'AAQ4t', 'AAQ4u', 'AAQ4z', 'AAQ50', 'AAQ5_', 'AAQ6H', 'AAQ6I', 'AAQ6S', 'AAQ6q', 'AAQ6w', 'AAQ7B', 'AAQ7z', 'AAQ87', 'AAQ8p', 'AAQ9:', 'AAQ9;', 'AAQ9D', 'AAQ9E', 'AAQ9F', 'AAQ9]', 'AAQ9c', 'AAQ9m', 'AAQ9o', 'AAQ9q', 'AAQ:1', 'AAQ:8', 'AAQ:J', 'AAQ:R', 'AAQ:d', 'AARP7', 'AARPS', 'AARPT', 'AARP^', 'AARPk', 'AARQ8', 'AARQG', 'AARQN', 'AARQm', 'AARRR', 'AARRm', 'AARS@', 'AARSL', 'AA^Ao', 'AA^Au', 'AA^BF', 'AA^Bz', 'AA^C8', 'AA^C;', 'AA^CA', 'AA^C_', 'AA^Co', 'AA^D;', 'AA^DE', 'AA^Db', 'AA^Dz', 'AA^E5', 'AA^EN', 'AA^ER', 'AA^E`', 'AA^F1', 'AA^F;', 'AA^FS', 'AA^Ff', 'AA^Fn', 'AA^GC', 'AA^Gi', 'AA^H:', 'AA^HB', 'AA^HF', 'AA^HV', 'AA^Hg', 'AA^I8', 'AA^I;', 'AA^IW', 'AA^Il', 'AA^Ip', 'AA^J5', 'AA^JL', 'AA^JS', 'AA^Jn', 'AA^KS', 'AA^KU', 'AA^KX', 'AA^KY', 'AA^K`', 'AA^Kh', 'AA^Ki', 'AA^Kq', 'AA^L8', 'AA^LP', 'AA^LV', 'AA^La', 'AA^Lq', 'AA^M:', 'AA^M;', 'AA^MR', 'AA^MT', 'AA^MU', 'AA^MV', 'AA^M^', 'AA^Me', 'AA^Mf', 'AA^Mg', 'AA^Ml', 'AA^Mn', 'AA^Mo', 'AA^N1', 'AA^N<', 'AA^N=', 'AA^NS', 'AA^N`', 'AA^Nm')
I get the following message:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AAAU^', 'AAAWs', 'AAAX7', 'AAAX:', 'AAAX=', 'AAAX>', 'AAAYO', 'AAAYU', 'AAAY[', ' at line 1

Posted: Wed Dec 06, 2006 1:05 pm
by feyd
mysql_real_escape_string() may be of interest.

Posted: Wed Dec 06, 2006 1:09 pm
by WanamakerStudios
Thanks! That in conjunction with some extra quotes did the job! Thanks for the help!