Hey everyone,Have a weird issue that I can't seem to figure out...Using PHP to insert phone numbers into the site... I have the Area Code, Exchange, and then dynamically create the last 4 digits... Once it's inserted it's dropping the leading zero's... Here's some samples:Copied from phpMySQL:EditInline EditCopyDelete2122000681EditInline EditCopyDelete2122001682EditInline EditCopyDelete2122002683EditInline EditCopyDelete2122003684EditInline EditCopyDelete2122004echoed output from PHP:SQL: INSERT INTO phonesite (areacode, exchange, subscriber) VALUES(212, 200, 0001)SQL: INSERT INTO phonesite (areacode, exchange, subscriber) VALUES(212, 200, 0002)Actual PHP code:?PHP// ini_set('display_errors', 1);//error_log(-1);set_time_limit(0);//set_time_limit("120");include "includes.php";include "databaseabstraction.php";include "authentication.php";dbconnect("localhost", "XX", "XX", "XX")or die("Unable to connect: " . mysql_error());function number_pad($number,$n) {return str_pad((int) $number,$n,"0",STR_PAD_LEFT);}if (($handle = fopen("newyorktest.csv", "r")) !== FALSE) { while (($data = "" 1000, ",")) !== FALSE) {print_r($data); foreach( range(0, ) AS $n) { //echo "BRDATA: " . $data[2] . "BR"; $padded_number = number_pad($n, "4"); $sql = "INSERT INTO phonesite (areacode, exchange, subscriber) "; $sql .= "VALUES({$data[1]}, {$data[2]}, {$padded_number}) "; //mysql_query($sql) or die("Didn't insert you dumb ass FIX IT NOW CLOWN " . mysql_error());echo "SQL: " . $sql . "BR"; } } echo "File Bitches!"; fclose($handle);}?Any ideas on what I'm missing?Thanks everyone!
Jason Pruimli...@pruimphotography.com
