Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: Odd MySQL Problem...

Posted on 2011-10-14 04:53:46 by Jason Pruim

--Apple-Mail-11-951209973
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=us-ascii

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:


Edit Inline Edit Copy Delete 212 200 0 =
6800001
Edit Inline Edit Copy Delete 212 200 1 =
6800002
Edit Inline Edit Copy Delete 212 200 2 =
6800003
Edit Inline Edit Copy Delete 212 200 3 =
6800004
Edit Inline Edit Copy Delete 212 200 4


echoed output from PHP:

SQL: INSERT INTO phonesite (areacode, exchange, subscriber) VALUES(212, =
200, 0001)=20
SQL: INSERT INTO phonesite (areacode, exchange, subscriber) VALUES(212, =
200, 0002)=20


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", "XXXXXX", "XXXXXX", "XXXXXX")or die("Unable to =
connect: " . mysql_error());


function number_pad($number,$n) {
return str_pad((int) $number,$n,"0",STR_PAD_LEFT);
}

if (($handle =3D fopen("newyorktest.csv", "r")) !== FALSE) {
while (($data =3D fgetcsv($handle, 1000, ",")) !== FALSE) {
print_r($data);

foreach( range(0, 9999) AS $n) {
//echo "<BR>DATA: " . $data[2] . "<BR>";
$padded_number =3D number_pad($n, "4");
$sql =3D "INSERT INTO phonesite (areacode, exchange, =
subscriber) ";
$sql .=3D "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 Pruim
lists@pruimphotography.com




--Apple-Mail-11-951209973
Content-Type: multipart/related;
type="text/html";
boundary=Apple-Mail-12-951209973


--Apple-Mail-12-951209973
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
charset=us-ascii

<html><head></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hey =
everyone,<div><br></div><div>Have a weird issue that I can't seem to =
figure out...</div><div><br></div><div>Using PHP to insert phone numbers =
into the site... I have the Area Code, &amp; Exchange, and then =
dynamically create the last 4 digits... Once it's inserted it's dropping =
the leading zero's... Here's some =
samples:</div><div><br></div><div>Copied from =
phpMySQL:</div><div><br></div><div><br></div><div><span =
class=3D"Apple-style-span" style=3D"font-family: sans-serif; font-size: =
13px; color: rgb(68, 68, 68); "><table id=3D"table_results" class=3D"data =
ajax" style=3D"border-collapse: collapse; margin-top: 0px; margin-right: =
0px; margin-bottom: 12px; margin-left: 0px; "><tbody><tr class=3D"odd" =
style=3D"background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(255, 255, 255); text-align: left; background-position: initial =
initial; background-repeat: initial initial; "><td align=3D"center" =
class=3D"" style=3D"padding-top: 0.3em; padding-right: 0.3em; =
padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0.1em; =
margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
"><input type=3D"checkbox" id=3D"id_rows_to_delete0_left" =
name=3D"rows_to_delete[%60phonesite%60.%60id%60+%3D+6800001] " =
class=3D"multi_checkbox" value=3D"DELETE FROM =
`pruimpho_test`.`phonesite` WHERE `phonesite`.`id` =3D 6800001" =
style=3D"font-size: 1em; vertical-align: middle; "></td><td class=3D"" =
align=3D"center" style=3D"padding-top: 0.3em; padding-right: 0.3em; =
padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0.1em; =
margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
"><span class=3D"nowrap" style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /tbl_change.ph=
p?db=3Dpruimpho_test&amp;table=3Dphonesite&amp;where_clause= 3D%60phonesite=
%60.%60id%60+%3D+6800001&amp;clause_is_unique=3D1&amp;sql_qu ery=3DSELECT+%=
2A+FROM+%60phonesite%60&amp;goto=3Dsql.php&amp;default_actio n=3Dupdate&amp=
;token=3D3d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: =
none; color: rgb(35, 90, 129); cursor: pointer; outline-style: none; =
outline-width: initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Edit" alt=3D"Edit" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"3a384582-411d-4827-aac7-dd30bb9dc85b" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:4EC5ED54-41B1-44D2-B94C-3161D481782A@Pride">&nbsp;Edit</span></=
a></span></td><td class=3D"inline_edit_anchor" align=3D"center" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /sql.php?db=3D=
pruimpho_test&amp;table=3Dphonesite&amp;token=3D3d7437a413c6 7c28f4c9961ee4=
0230e6&amp;pos=3D0#" style=3D"text-decoration: none; color: rgb(35, 90, =
129); cursor: pointer; outline-style: none; outline-width: initial; =
outline-color: initial; "><span class=3D"nowrap" style=3D"white-space: =
nowrap; "><img title=3D"Inline Edit" alt=3D"Edit" class=3D"icon" =
width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"abc088d4-5514-49ea-955a-d4d88448e9b2" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:6C3C62C9-2973-4BC5-BD15-CDD559F3F771@Pride">&nbsp;Inline =
Edit</span></a></span></td><td align=3D"center" class=3D"" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /tbl_change.ph=
p?db=3Dpruimpho_test&amp;table=3Dphonesite&amp;where_clause= 3D%60phonesite=
%60.%60id%60+%3D+6800001&amp;clause_is_unique=3D1&amp;sql_qu ery=3DSELECT+%=
2A+FROM+%60phonesite%60&amp;goto=3Dsql.php&amp;default_actio n=3Dinsert&amp=
;token=3D3d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: =
none; color: rgb(35, 90, 129); cursor: pointer; outline-style: none; =
outline-width: initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Copy" alt=3D"Copy" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"afc05b8c-d9d7-45fd-8e10-1e5430d353eb" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:57637D51-3059-4322-A083-2326E0AA955D@Pride">&nbsp;Copy</span></=
a></span></td><td align=3D"center" class=3D"" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; =
margin-left: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) =
0px 1px 0px; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /sql.php?db=3D=
pruimpho_test&amp;table=3Dphonesite&amp;sql_query=3DDELETE+F ROM+%60pruimph=
o_test%60.%60phonesite%60+WHERE+%60phonesite%60.%60id%60+%3D +6800001&amp;m=
essage_to_show=3DThe+row+has+been+deleted&amp;goto=3Dsql.php %3Fdb%3Dpruimp=
ho_test%26table%3Dphonesite%26sql_query%3DSELECT%2B%252A%2BF ROM%2B%2560pho=
nesite%2560%26message_to_show%3DThe%2Brow%2Bhas%2Bbeen%2Bdel eted%26goto%3D=
tbl_structure.php%26token%3D3d7437a413c67c28f4c9961ee40230e6 &amp;token=3D3=
d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: none; color: =
rgb(35, 90, 129); cursor: pointer; outline-style: none; outline-width: =
initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Delete" alt=3D"Delete" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"efe0e4a1-462f-4f40-b817-3fe131662d5f" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:273C015E-AED0-468E-9394-380D31270993@Pride">&nbsp;Delete</span>=
</a></td><td align=3D"right" class=3D"data inline_edit not_null odd =
nowrap" style=3D"padding-top: 0.3em; padding-right: 0.3em; =
padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0px; =
margin-right: 0px; margin-bottom: 12px; margin-left: 0px; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(255, 255, 255); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">212</td><td align=3D"right"=
class=3D"data inline_edit not_null odd nowrap" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: =
0px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(255, 255, 255); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">200</td><td class=3D"data =
inline_edit not_null odd" style=3D"padding-top: 0.3em; padding-right: =
0.3em; padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0px; =
margin-right: 0px; margin-bottom: 12px; margin-left: 0px; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(255, 255, 255); background-position: initial initial; =
background-repeat: initial initial; ">0</td><td align=3D"right" =
class=3D"data inline_edit not_null odd nowrap" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: =
0px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(255, 255, 255); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">6800001</td></tr><tr =
class=3D"even" style=3D"background-image: initial; =
background-attachment: initial; background-origin: initial; =
background-clip: initial; background-color: rgb(243, 243, 243); =
text-align: left; background-position: initial initial; =
background-repeat: initial initial; "><td align=3D"center" class=3D"" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; "><input type=3D"checkbox" =
id=3D"id_rows_to_delete1_left" =
name=3D"rows_to_delete[%60phonesite%60.%60id%60+%3D+6800002] " =
class=3D"multi_checkbox" value=3D"DELETE FROM =
`pruimpho_test`.`phonesite` WHERE `phonesite`.`id` =3D 6800002" =
style=3D"font-size: 1em; vertical-align: middle; "></td><td class=3D"" =
align=3D"center" style=3D"padding-top: 0.3em; padding-right: 0.3em; =
padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0.1em; =
margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
"><span class=3D"nowrap" style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /tbl_change.ph=
p?db=3Dpruimpho_test&amp;table=3Dphonesite&amp;where_clause= 3D%60phonesite=
%60.%60id%60+%3D+6800002&amp;clause_is_unique=3D1&amp;sql_qu ery=3DSELECT+%=
2A+FROM+%60phonesite%60&amp;goto=3Dsql.php&amp;default_actio n=3Dupdate&amp=
;token=3D3d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: =
none; color: rgb(35, 90, 129); cursor: pointer; outline-style: none; =
outline-width: initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Edit" alt=3D"Edit" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"34b17287-f675-42ac-b351-f3190b76d35e" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:4EC5ED54-41B1-44D2-B94C-3161D481782A@Pride">&nbsp;Edit</span></=
a></span></td><td class=3D"inline_edit_anchor" align=3D"center" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /sql.php?db=3D=
pruimpho_test&amp;table=3Dphonesite&amp;token=3D3d7437a413c6 7c28f4c9961ee4=
0230e6&amp;pos=3D0#" style=3D"text-decoration: none; color: rgb(35, 90, =
129); cursor: pointer; outline-style: none; outline-width: initial; =
outline-color: initial; "><span class=3D"nowrap" style=3D"white-space: =
nowrap; "><img title=3D"Inline Edit" alt=3D"Edit" class=3D"icon" =
width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"d4564880-3272-4662-9158-753adc0a5f57" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:6C3C62C9-2973-4BC5-BD15-CDD559F3F771@Pride">&nbsp;Inline =
Edit</span></a></span></td><td align=3D"center" class=3D"" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /tbl_change.ph=
p?db=3Dpruimpho_test&amp;table=3Dphonesite&amp;where_clause= 3D%60phonesite=
%60.%60id%60+%3D+6800002&amp;clause_is_unique=3D1&amp;sql_qu ery=3DSELECT+%=
2A+FROM+%60phonesite%60&amp;goto=3Dsql.php&amp;default_actio n=3Dinsert&amp=
;token=3D3d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: =
none; color: rgb(35, 90, 129); cursor: pointer; outline-style: none; =
outline-width: initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Copy" alt=3D"Copy" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"f6567544-9295-459a-93ba-5c3fa14a4373" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:57637D51-3059-4322-A083-2326E0AA955D@Pride">&nbsp;Copy</span></=
a></span></td><td align=3D"center" class=3D"" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; =
margin-left: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) =
0px 1px 0px; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /sql.php?db=3D=
pruimpho_test&amp;table=3Dphonesite&amp;sql_query=3DDELETE+F ROM+%60pruimph=
o_test%60.%60phonesite%60+WHERE+%60phonesite%60.%60id%60+%3D +6800002&amp;m=
essage_to_show=3DThe+row+has+been+deleted&amp;goto=3Dsql.php %3Fdb%3Dpruimp=
ho_test%26table%3Dphonesite%26sql_query%3DSELECT%2B%252A%2BF ROM%2B%2560pho=
nesite%2560%26message_to_show%3DThe%2Brow%2Bhas%2Bbeen%2Bdel eted%26goto%3D=
tbl_structure.php%26token%3D3d7437a413c67c28f4c9961ee40230e6 &amp;token=3D3=
d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: none; color: =
rgb(35, 90, 129); cursor: pointer; outline-style: none; outline-width: =
initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Delete" alt=3D"Delete" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"d2a0527f-bfcf-47f6-a01c-c1714374465c" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:273C015E-AED0-468E-9394-380D31270993@Pride">&nbsp;Delete</span>=
</a></td><td align=3D"right" class=3D"data inline_edit not_null even =
nowrap" style=3D"padding-top: 0.3em; padding-right: 0.3em; =
padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0px; =
margin-right: 0px; margin-bottom: 12px; margin-left: 0px; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(243, 243, 243); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">212</td><td align=3D"right"=
class=3D"data inline_edit not_null even nowrap" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: =
0px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(243, 243, 243); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">200</td><td class=3D"data =
inline_edit not_null even" style=3D"padding-top: 0.3em; padding-right: =
0.3em; padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0px; =
margin-right: 0px; margin-bottom: 12px; margin-left: 0px; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(243, 243, 243); background-position: initial initial; =
background-repeat: initial initial; ">1</td><td align=3D"right" =
class=3D"data inline_edit not_null even nowrap" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: =
0px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(243, 243, 243); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">6800002</td></tr><tr =
class=3D"odd" style=3D"background-image: initial; background-attachment: =
initial; background-origin: initial; background-clip: initial; =
background-color: rgb(255, 255, 255); text-align: left; =
background-position: initial initial; background-repeat: initial =
initial; "><td align=3D"center" class=3D"" style=3D"padding-top: 0.3em; =
padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; =
margin-left: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) =
0px 1px 0px; "><input type=3D"checkbox" id=3D"id_rows_to_delete2_left" =
name=3D"rows_to_delete[%60phonesite%60.%60id%60+%3D+6800003] " =
class=3D"multi_checkbox" value=3D"DELETE FROM =
`pruimpho_test`.`phonesite` WHERE `phonesite`.`id` =3D 6800003" =
style=3D"font-size: 1em; vertical-align: middle; "></td><td class=3D"" =
align=3D"center" style=3D"padding-top: 0.3em; padding-right: 0.3em; =
padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0.1em; =
margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
"><span class=3D"nowrap" style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /tbl_change.ph=
p?db=3Dpruimpho_test&amp;table=3Dphonesite&amp;where_clause= 3D%60phonesite=
%60.%60id%60+%3D+6800003&amp;clause_is_unique=3D1&amp;sql_qu ery=3DSELECT+%=
2A+FROM+%60phonesite%60&amp;goto=3Dsql.php&amp;default_actio n=3Dupdate&amp=
;token=3D3d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: =
none; color: rgb(35, 90, 129); cursor: pointer; outline-style: none; =
outline-width: initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Edit" alt=3D"Edit" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"e9113573-c2cb-4bd3-8585-896124e71df1" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:4EC5ED54-41B1-44D2-B94C-3161D481782A@Pride">&nbsp;Edit</span></=
a></span></td><td class=3D"inline_edit_anchor" align=3D"center" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /sql.php?db=3D=
pruimpho_test&amp;table=3Dphonesite&amp;token=3D3d7437a413c6 7c28f4c9961ee4=
0230e6&amp;pos=3D0#" style=3D"text-decoration: none; color: rgb(35, 90, =
129); cursor: pointer; outline-style: none; outline-width: initial; =
outline-color: initial; "><span class=3D"nowrap" style=3D"white-space: =
nowrap; "><img title=3D"Inline Edit" alt=3D"Edit" class=3D"icon" =
width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"23bd6e04-5b5c-45c5-b1e7-4b7630847f8b" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:6C3C62C9-2973-4BC5-BD15-CDD559F3F771@Pride">&nbsp;Inline =
Edit</span></a></span></td><td align=3D"center" class=3D"" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /tbl_change.ph=
p?db=3Dpruimpho_test&amp;table=3Dphonesite&amp;where_clause= 3D%60phonesite=
%60.%60id%60+%3D+6800003&amp;clause_is_unique=3D1&amp;sql_qu ery=3DSELECT+%=
2A+FROM+%60phonesite%60&amp;goto=3Dsql.php&amp;default_actio n=3Dinsert&amp=
;token=3D3d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: =
none; color: rgb(35, 90, 129); cursor: pointer; outline-style: none; =
outline-width: initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Copy" alt=3D"Copy" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"7d45cc0a-7f21-4b14-b5ff-ec76a5b91794" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:57637D51-3059-4322-A083-2326E0AA955D@Pride">&nbsp;Copy</span></=
a></span></td><td align=3D"center" class=3D"" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; =
margin-left: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) =
0px 1px 0px; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /sql.php?db=3D=
pruimpho_test&amp;table=3Dphonesite&amp;sql_query=3DDELETE+F ROM+%60pruimph=
o_test%60.%60phonesite%60+WHERE+%60phonesite%60.%60id%60+%3D +6800003&amp;m=
essage_to_show=3DThe+row+has+been+deleted&amp;goto=3Dsql.php %3Fdb%3Dpruimp=
ho_test%26table%3Dphonesite%26sql_query%3DSELECT%2B%252A%2BF ROM%2B%2560pho=
nesite%2560%26message_to_show%3DThe%2Brow%2Bhas%2Bbeen%2Bdel eted%26goto%3D=
tbl_structure.php%26token%3D3d7437a413c67c28f4c9961ee40230e6 &amp;token=3D3=
d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: none; color: =
rgb(35, 90, 129); cursor: pointer; outline-style: none; outline-width: =
initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Delete" alt=3D"Delete" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"aeef90df-6c23-4e61-86fc-c809ff284b75" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:273C015E-AED0-468E-9394-380D31270993@Pride">&nbsp;Delete</span>=
</a></td><td align=3D"right" class=3D"data inline_edit not_null odd =
nowrap" style=3D"padding-top: 0.3em; padding-right: 0.3em; =
padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0px; =
margin-right: 0px; margin-bottom: 12px; margin-left: 0px; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(255, 255, 255); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">212</td><td align=3D"right"=
class=3D"data inline_edit not_null odd nowrap" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: =
0px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(255, 255, 255); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">200</td><td class=3D"data =
inline_edit not_null odd" style=3D"padding-top: 0.3em; padding-right: =
0.3em; padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0px; =
margin-right: 0px; margin-bottom: 12px; margin-left: 0px; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(255, 255, 255); background-position: initial initial; =
background-repeat: initial initial; ">2</td><td align=3D"right" =
class=3D"data inline_edit not_null odd nowrap" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: =
0px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(255, 255, 255); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">6800003</td></tr><tr =
class=3D"even" style=3D"background-image: initial; =
background-attachment: initial; background-origin: initial; =
background-clip: initial; background-color: rgb(243, 243, 243); =
text-align: left; background-position: initial initial; =
background-repeat: initial initial; "><td align=3D"center" class=3D"" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; "><input type=3D"checkbox" =
id=3D"id_rows_to_delete3_left" =
name=3D"rows_to_delete[%60phonesite%60.%60id%60+%3D+6800004] " =
class=3D"multi_checkbox" value=3D"DELETE FROM =
`pruimpho_test`.`phonesite` WHERE `phonesite`.`id` =3D 6800004" =
style=3D"font-size: 1em; vertical-align: middle; "></td><td class=3D"" =
align=3D"center" style=3D"padding-top: 0.3em; padding-right: 0.3em; =
padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0.1em; =
margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
"><span class=3D"nowrap" style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /tbl_change.ph=
p?db=3Dpruimpho_test&amp;table=3Dphonesite&amp;where_clause= 3D%60phonesite=
%60.%60id%60+%3D+6800004&amp;clause_is_unique=3D1&amp;sql_qu ery=3DSELECT+%=
2A+FROM+%60phonesite%60&amp;goto=3Dsql.php&amp;default_actio n=3Dupdate&amp=
;token=3D3d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: =
none; color: rgb(35, 90, 129); cursor: pointer; outline-style: none; =
outline-width: initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Edit" alt=3D"Edit" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"ffd6d11a-5373-44ef-8ae6-f2d8f4777e0d" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:4EC5ED54-41B1-44D2-B94C-3161D481782A@Pride">&nbsp;Edit</span></=
a></span></td><td class=3D"inline_edit_anchor" align=3D"center" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /sql.php?db=3D=
pruimpho_test&amp;table=3Dphonesite&amp;token=3D3d7437a413c6 7c28f4c9961ee4=
0230e6&amp;pos=3D0#" style=3D"text-decoration: none; color: rgb(35, 90, =
129); cursor: pointer; outline-style: none; outline-width: initial; =
outline-color: initial; "><span class=3D"nowrap" style=3D"white-space: =
nowrap; "><img title=3D"Inline Edit" alt=3D"Edit" class=3D"icon" =
width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"fdf2bcee-c392-4723-b0c2-21decc319c32" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:6C3C62C9-2973-4BC5-BD15-CDD559F3F771@Pride">&nbsp;Inline =
Edit</span></a></span></td><td align=3D"center" class=3D"" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /tbl_change.ph=
p?db=3Dpruimpho_test&amp;table=3Dphonesite&amp;where_clause= 3D%60phonesite=
%60.%60id%60+%3D+6800004&amp;clause_is_unique=3D1&amp;sql_qu ery=3DSELECT+%=
2A+FROM+%60phonesite%60&amp;goto=3Dsql.php&amp;default_actio n=3Dinsert&amp=
;token=3D3d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: =
none; color: rgb(35, 90, 129); cursor: pointer; outline-style: none; =
outline-width: initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Copy" alt=3D"Copy" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"1e8a2ede-8212-42a1-893e-d590785e07ee" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:57637D51-3059-4322-A083-2326E0AA955D@Pride">&nbsp;Copy</span></=
a></span></td><td align=3D"center" class=3D"" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; =
margin-left: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) =
0px 1px 0px; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /sql.php?db=3D=
pruimpho_test&amp;table=3Dphonesite&amp;sql_query=3DDELETE+F ROM+%60pruimph=
o_test%60.%60phonesite%60+WHERE+%60phonesite%60.%60id%60+%3D +6800004&amp;m=
essage_to_show=3DThe+row+has+been+deleted&amp;goto=3Dsql.php %3Fdb%3Dpruimp=
ho_test%26table%3Dphonesite%26sql_query%3DSELECT%2B%252A%2BF ROM%2B%2560pho=
nesite%2560%26message_to_show%3DThe%2Brow%2Bhas%2Bbeen%2Bdel eted%26goto%3D=
tbl_structure.php%26token%3D3d7437a413c67c28f4c9961ee40230e6 &amp;token=3D3=
d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: none; color: =
rgb(35, 90, 129); cursor: pointer; outline-style: none; outline-width: =
initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Delete" alt=3D"Delete" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"b3939331-6452-4028-9ac1-4b8b7cfc9f87" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:273C015E-AED0-468E-9394-380D31270993@Pride">&nbsp;Delete</span>=
</a></td><td align=3D"right" class=3D"data inline_edit not_null even =
nowrap" style=3D"padding-top: 0.3em; padding-right: 0.3em; =
padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0px; =
margin-right: 0px; margin-bottom: 12px; margin-left: 0px; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(243, 243, 243); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">212</td><td align=3D"right"=
class=3D"data inline_edit not_null even nowrap" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: =
0px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(243, 243, 243); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">200</td><td class=3D"data =
inline_edit not_null even" style=3D"padding-top: 0.3em; padding-right: =
0.3em; padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0px; =
margin-right: 0px; margin-bottom: 12px; margin-left: 0px; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(243, 243, 243); background-position: initial initial; =
background-repeat: initial initial; ">3</td><td align=3D"right" =
class=3D"data inline_edit not_null even nowrap" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: =
0px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: initial; background-attachment: initial; =
background-origin: initial; background-clip: initial; background-color: =
rgb(243, 243, 243); white-space: nowrap; background-position: initial =
initial; background-repeat: initial initial; ">6800004</td></tr><tr =
class=3D"odd hover" style=3D"background-image: =
url(http://pruimphotography.com:2082/3rdparty/phpMyAdmin/the mes/pmahomme/i=
mg/marked_bg.png); background-attachment: initial; background-origin: =
initial; background-clip: initial; background-color: rgb(182, 198, 215); =
color: rgb(0, 0, 0); text-align: left; background-position: initial =
initial; background-repeat: repeat no-repeat; "><td align=3D"center" =
class=3D"hover" style=3D"padding-top: 0.3em; padding-right: 0.3em; =
padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0.1em; =
margin-right: 0.1em; margin-bottom: 0.1em; margin-left: 0.1em; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: =
url(http://pruimphotography.com:2082/3rdparty/phpMyAdmin/the mes/pmahomme/i=
mg/marked_bg.png); background-attachment: initial; background-origin: =
initial; background-clip: initial; background-color: rgb(182, 198, 215); =
color: rgb(0, 0, 0); background-position: initial initial; =
background-repeat: repeat no-repeat; "><input type=3D"checkbox" =
id=3D"id_rows_to_delete4_left" =
name=3D"rows_to_delete[%60phonesite%60.%60id%60+%3D+6800005] " =
class=3D"multi_checkbox" value=3D"DELETE FROM =
`pruimpho_test`.`phonesite` WHERE `phonesite`.`id` =3D 6800005" =
style=3D"font-size: 1em; vertical-align: middle; "></td><td =
class=3D"hover" align=3D"center" style=3D"padding-top: 0.3em; =
padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; =
margin-left: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) =
0px 1px 0px; background-image: =
url(http://pruimphotography.com:2082/3rdparty/phpMyAdmin/the mes/pmahomme/i=
mg/marked_bg.png); background-attachment: initial; background-origin: =
initial; background-clip: initial; background-color: rgb(182, 198, 215); =
color: rgb(0, 0, 0); background-position: initial initial; =
background-repeat: repeat no-repeat; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /tbl_change.ph=
p?db=3Dpruimpho_test&amp;table=3Dphonesite&amp;where_clause= 3D%60phonesite=
%60.%60id%60+%3D+6800005&amp;clause_is_unique=3D1&amp;sql_qu ery=3DSELECT+%=
2A+FROM+%60phonesite%60&amp;goto=3Dsql.php&amp;default_actio n=3Dupdate&amp=
;token=3D3d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: =
none; color: rgb(35, 90, 129); cursor: pointer; outline-style: none; =
outline-width: initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Edit" alt=3D"Edit" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"d6f1c07a-3ab1-4ea1-94b5-6acee63c3a62" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:4EC5ED54-41B1-44D2-B94C-3161D481782A@Pride">&nbsp;Edit</span></=
a></span></td><td class=3D"inline_edit_anchor hover" align=3D"center" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; background-image: =
url(http://pruimphotography.com:2082/3rdparty/phpMyAdmin/the mes/pmahomme/i=
mg/marked_bg.png); background-attachment: initial; background-origin: =
initial; background-clip: initial; background-color: rgb(182, 198, 215); =
color: rgb(0, 0, 0); background-position: initial initial; =
background-repeat: repeat no-repeat; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /sql.php?db=3D=
pruimpho_test&amp;table=3Dphonesite&amp;token=3D3d7437a413c6 7c28f4c9961ee4=
0230e6&amp;pos=3D0#" style=3D"text-decoration: none; color: rgb(35, 90, =
129); cursor: pointer; outline-style: none; outline-width: initial; =
outline-color: initial; "><span class=3D"nowrap" style=3D"white-space: =
nowrap; "><img title=3D"Inline Edit" alt=3D"Edit" class=3D"icon" =
width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"2943eaf3-7207-406c-a4fb-e67ebe562f7a" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:6C3C62C9-2973-4BC5-BD15-CDD559F3F771@Pride">&nbsp;Inline =
Edit</span></a></span></td><td align=3D"center" class=3D"hover" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0.1em; margin-right: 0.1em; =
margin-bottom: 0.1em; margin-left: 0.1em; vertical-align: top; =
text-shadow: rgb(255, 255, 255) 0px 1px 0px; background-image: =
url(http://pruimphotography.com:2082/3rdparty/phpMyAdmin/the mes/pmahomme/i=
mg/marked_bg.png); background-attachment: initial; background-origin: =
initial; background-clip: initial; background-color: rgb(182, 198, 215); =
color: rgb(0, 0, 0); background-position: initial initial; =
background-repeat: repeat no-repeat; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /tbl_change.ph=
p?db=3Dpruimpho_test&amp;table=3Dphonesite&amp;where_clause= 3D%60phonesite=
%60.%60id%60+%3D+6800005&amp;clause_is_unique=3D1&amp;sql_qu ery=3DSELECT+%=
2A+FROM+%60phonesite%60&amp;goto=3Dsql.php&amp;default_actio n=3Dinsert&amp=
;token=3D3d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: =
none; color: rgb(35, 90, 129); cursor: pointer; outline-style: none; =
outline-width: initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Copy" alt=3D"Copy" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"ae61b2e5-4cb3-4f2c-90dc-24f53db48e38" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:57637D51-3059-4322-A083-2326E0AA955D@Pride">&nbsp;Copy</span></=
a></span></td><td align=3D"center" class=3D"hover" style=3D"padding-top: =
0.3em; padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0.1em; margin-right: 0.1em; margin-bottom: 0.1em; =
margin-left: 0.1em; vertical-align: top; text-shadow: rgb(255, 255, 255) =
0px 1px 0px; background-image: =
url(http://pruimphotography.com:2082/3rdparty/phpMyAdmin/the mes/pmahomme/i=
mg/marked_bg.png); background-attachment: initial; background-origin: =
initial; background-clip: initial; background-color: rgb(182, 198, 215); =
color: rgb(0, 0, 0); background-position: initial initial; =
background-repeat: repeat no-repeat; "><a =
href=3D"http://pruimphotography.com:2082/3rdparty/phpMyAdmin /sql.php?db=3D=
pruimpho_test&amp;table=3Dphonesite&amp;sql_query=3DDELETE+F ROM+%60pruimph=
o_test%60.%60phonesite%60+WHERE+%60phonesite%60.%60id%60+%3D +6800005&amp;m=
essage_to_show=3DThe+row+has+been+deleted&amp;goto=3Dsql.php %3Fdb%3Dpruimp=
ho_test%26table%3Dphonesite%26sql_query%3DSELECT%2B%252A%2BF ROM%2B%2560pho=
nesite%2560%26message_to_show%3DThe%2Brow%2Bhas%2Bbeen%2Bdel eted%26goto%3D=
tbl_structure.php%26token%3D3d7437a413c67c28f4c9961ee40230e6 &amp;token=3D3=
d7437a413c67c28f4c9961ee40230e6" style=3D"text-decoration: none; color: =
rgb(35, 90, 129); cursor: pointer; outline-style: none; outline-width: =
initial; outline-color: initial; "><span class=3D"nowrap" =
style=3D"white-space: nowrap; "><img title=3D"Delete" alt=3D"Delete" =
class=3D"icon" width=3D"16" height=3D"16" style=3D"vertical-align: -3px; =
border-top-width: 0px; border-right-width: 0px; border-bottom-width: =
0px; border-left-width: 0px; border-style: initial; border-color: =
initial; margin-right: 0px; margin-left: 0px; margin-top: 0px; =
margin-bottom: 0px; " id=3D"9434b1e1-2b00-413b-9eb9-060855f669ee" =
apple-width=3D"yes" apple-height=3D"yes" =
src=3D"cid:273C015E-AED0-468E-9394-380D31270993@Pride">&nbsp;Delete</span>=
</a></td><td align=3D"right" class=3D"data inline_edit not_null odd =
nowrap hover" style=3D"padding-top: 0.3em; padding-right: 0.3em; =
padding-bottom: 0.3em; padding-left: 0.3em; margin-top: 0px; =
margin-right: 0px; margin-bottom: 12px; margin-left: 0px; =
vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: =
url(http://pruimphotography.com:2082/3rdparty/phpMyAdmin/the mes/pmahomme/i=
mg/marked_bg.png); background-attachment: initial; background-origin: =
initial; background-clip: initial; background-color: rgb(182, 198, 215); =
color: rgb(0, 0, 0); white-space: nowrap; background-position: initial =
initial; background-repeat: repeat no-repeat; ">212</td><td =
align=3D"right" class=3D"data inline_edit not_null odd nowrap hover" =
style=3D"padding-top: 0.3em; padding-right: 0.3em; padding-bottom: =
0.3em; padding-left: 0.3em; margin-top: 0px; margin-right: 0px; =
margin-bottom: 12px; margin-left: 0px; vertical-align: top; text-shadow: =
rgb(255, 255, 255) 0px 1px 0px; background-image: =
url(http://pruimphotography.com:2082/3rdparty/phpMyAdmin/the mes/pmahomme/i=
mg/marked_bg.png); background-attachment: initial; background-origin: =
initial; background-clip: initial; background-color: rgb(182, 198, 215); =
color: rgb(0, 0, 0); white-space: nowrap; background-position: initial =
initial; background-repeat: repeat no-repeat; ">200</td><td class=3D"data =
inline_edit not_null odd hover" style=3D"padding-top: 0.3em; =
padding-right: 0.3em; padding-bottom: 0.3em; padding-left: 0.3em; =
margin-top: 0px; margin-right: 0px; margin-bottom: 12px; margin-left: =
0px; vertical-align: top; text-shadow: rgb(255, 255, 255) 0px 1px 0px; =
background-image: =
url(http://pruimphotography.com:2082/3rdparty/phpMyAdmin/the mes/pmahomme/i=
mg/marked_bg.png); background-attachment: initial; background-origin: =
initial; background-clip: initial; background-color: rgb(182, 198, 215); =
color: rgb(0, 0, 0); background-position: initial initial; =
background-repeat: repeat no-repeat; =
">4</td></tr></tbody></table></span><div><br></div></div><div><br></div><d=
iv>echoed output from PHP:</div><div><br></div><div><span =
class=3D"Apple-style-span" style=3D"font-family: Times; ">SQL: INSERT =
INTO phonesite (areacode, exchange, subscriber) VALUES(212, 200, =
0001)</span><span class=3D"Apple-style-span" style=3D"font-family: =
Times; ">&nbsp;</span><span class=3D"Apple-style-span" =
style=3D"font-family: Times; "><br></span><span class=3D"Apple-style-span"=
style=3D"font-family: Times; ">SQL: INSERT INTO phonesite (areacode, =
exchange, subscriber) VALUES(212, 200, 0002)</span><span =
class=3D"Apple-style-span" style=3D"font-family: Times; =
">&nbsp;</span></div><div><font class=3D"Apple-style-span" =
face=3D"Times"><br></font></div><div><font class=3D"Apple-style-span" =
face=3D"Times"><br></font></div><div><font class=3D"Apple-style-span" =
face=3D"Times">Actual PHP code:</font></div><div><font =
class=3D"Apple-style-span" face=3D"Times"><br></font></div><div><font =
class=3D"Apple-style-span" face=3D"Times"><div>&lt;?PHP</div><div>// =
&nbsp; &nbsp;ini_set('display_errors', =
1);</div><div>//error_log(-1);</div><div>set_time_limit(0);</div><div><br>=
</div><div>//set_time_limit("120");</div><div>include =
"includes.php";</div><div>include =
"databaseabstraction.php";</div><div>include =
"authentication.php";</div><div><br></div><div>dbconnect("localhost", =
"XXXXXX", "XXXXXX", "XXXXXX")or die("Unable to connect: " . =
mysql_error());</div><div><br></div><div><br></div><div>function =
number_pad($number,$n) {</div><div>return str_pad((int) =
$number,$n,"0",STR_PAD_LEFT);</div><div>}</div><div><br></div><div>if =
(($handle =3D fopen("newyorktest.csv", "r")) !== FALSE) =
{</div><div>&nbsp;&nbsp; &nbsp;while (($data =3D fgetcsv($handle, 1000, =
",")) !== FALSE) =
{</div><div>print_r($data);</div><div><br></div><div>&nbsp;&nbsp; &nbsp; =
&nbsp; &nbsp;foreach( range(0, 9999) AS $n) {</div><div>&nbsp;&nbsp; =
&nbsp; &nbsp; &nbsp;//echo "&lt;BR&gt;DATA: " . $data[2] . =
"&lt;BR&gt;";</div><div>&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =
$padded_number =3D number_pad($n, "4");</div><div>&nbsp;&nbsp; &nbsp; =
&nbsp; &nbsp; &nbsp; &nbsp; $sql =3D "INSERT INTO phonesite (areacode, =
exchange, subscriber) ";</div><div>&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; =
&nbsp; &nbsp; $sql .=3D "VALUES({$data[1]}, {$data[2]}, =
{$padded_number}) ";</div><div>&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =
&nbsp; //mysql_query($sql) or die("Didn't insert you dumb ass.... FIX IT =
NOW CLOWN!!!! " . mysql_error());</div><div>echo "SQL: " . $sql . =
"&lt;BR&gt;";</div><div><br></div><div>&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; =
&nbsp; &nbsp; }</div><div><br></div><div>&nbsp;&nbsp; =
&nbsp;}</div><div>&nbsp;&nbsp; &nbsp;echo "File =
Bitches!";</div><div>&nbsp;&nbsp; =
&nbsp;fclose($handle);</div><div>}</div><div><br></div><div><br></div><div=
><br></div><div>?&gt;</div></font></div><div><font =
class=3D"Apple-style-span" face=3D"Times"><br></font></div><div><font =
class=3D"Apple-style-span" face=3D"Times"><br></font></div><div><font =
class=3D"Apple-style-span" face=3D"Times">Any ideas on what I'm =
missing?</font></div><div><font class=3D"Apple-style-span" =
face=3D"Times"><br></font></div><div><font class=3D"Apple-style-span" =
face=3D"Times">Thanks everyone!</font></div><div><font =
class=3D"Apple-style-span" face=3D"Times"><br></font><div>
<span class=3D"Apple-style-span" style=3D"border-collapse: separate; =
color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; =
font-variant: normal; font-weight: normal; letter-spacing: normal; =
line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; =
text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; =
-webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: =
0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: =
auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div>Jason =
Pruim</div><div><a =
href=3D"mailto:lists@pruimphotography.com">lists@pruimphotog raphy.com</a><=
/div><div><br></div></span><br class=3D"Apple-interchange-newline">
</div>

<br></div></body></html>=

--Apple-Mail-12-951209973
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename=b_edit.png
Content-Type: image/png;
name="b_edit.png"
Content-Id: <4EC5ED54-41B1-44D2-B94C-3161D481782A@Pride>

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAMAAAAoLQ9TAAAABGdBTUEAAK/I NwWK6QAAABl0RVh0
U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAADAUExURf///+S6L96k NZhjILqLO8KCMdKd
L9uqT8uTU8mQT8qTUFhAE1lCEl5CFZNtHpxpJapgFrR2LLV9NLmJJr+QJ8GL SMJnFcOZMceDNMiQ
TsipZ8mRT8qVQs+cStCdWdScXdilatmPO9moUNzEbd2rc92ubOHLsOS6L+a0 XeiYQOyqYezPqfLh
yPLmvvPPb/TPpfTUp/TWRPXPpvXZaPXcYPfbvffhyfjhxfjiqPjjy/jtw/nj y/njzPrn0frujvz0
sywdqF4AAAALdFJOUwAJGSCtrt/q9/398YDkqQAAAGtJREFUGJVjYMANGNm5 JNmYkASUFMwsZVgR
fHUDcxsbU04E38pCVV/flAPBtzfWk1ORRuKbGNppKOLii6DxhXVR+MzCalIo 8nw6tkLiyrIScAfw
WWtpigkIIlzII2+kLYrEZ+Dm5RdkweNnADOjDvQ6wh73AAAAAElFTkSuQmCC

--Apple-Mail-12-951209973
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename=b_inline_edit.png
Content-Type: image/png;
name="b_inline_edit.png"
Content-Id: <6C3C62C9-2973-4BC5-BD15-CDD559F3F771@Pride>

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/I NwWK6QAAABl0RVh0
U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAH8SURBVDjLjZPfS1Nh GMdXf0VEQhDUhdCN
4X0IYT8ghIJQM0KoC4vushZddLELKyRhQQkSFIKEGEkUCI2oxVhepG5zi1xb c0u3cDs7Z+ec/ezT
+x62scmmHvhwDrzP93Pe57znsQE2cR0SdAm6d+GwYL/M1LBVBV35fF4plUqV crlMK8Q6TqdzYruk
JuiW4Vwuh67rdbLZLJlMhmQyaUnigVlC05f4+dbB0tQplp92DsnwPimQBaZp UigUrLtE0zQURSGV
SqHF37DhGkVZeQdagszKLJ7HvZtNAhmuIQWGYaCqKps/ZkivPqCwPs/Gp0cY vjnKUTe+F9fMJoFo
o96zfJZ9K+sLpP33qRhujPANtr7dJPhqmO/PBxX3+PljTYLtqImPpH13qZge 9LUrmLEB1FU7sZd9
jJw5MljNthYk/KLnxdFqeAjzdz9Z/z3Ck2fRE36qx9pakAjME1y4Lbb9GTMy TD52GUXsZO3ZadTk
L6umrSD4ZZrAezvLH54Q915EjwywtXSH8FQf+t+I9V12FLwe6wE1SmjyAi77 Qb6Kt3rGe9H+hKzw
rgLH9eMUPE4K3gm8jpPMjRwlHfNTLBbr7Cjo7znA2NVOXA/PsThzi2wyah1p I+0E/9rNQQsqMtM4
CyfE36fLhb2ERa0mB7BR0CElexjnGnL0O2T2PyFunSz8jchwAAAAAElFTkSu QmCC

--Apple-Mail-12-951209973
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename=b_insrow.png
Content-Type: image/png;
name="b_insrow.png"
Content-Id: <57637D51-3059-4322-A083-2326E0AA955D@Pride>

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQBAMAAADt3eJSAAAABGdBTUEAAK/I NwWK6QAAABl0RVh0
U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAAPUExURf/MMzMzM8zM zGZmzAAAANwpnsUA
AAAFdFJOU/////8A+7YOUwAAAEpJREFUCFs9jcENwDAMAnl0AUuZwO0GzgJO bv+Z+khsXggdIK6U
ZgM2Wu4DYmq5f5XMy7zHQEzShtgRkXpElOmkmG71zlmmvvodfng4GisHj5mv AAAAAElFTkSuQmCC

--Apple-Mail-12-951209973
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename=b_drop.png
Content-Type: image/png;
name="b_drop.png"
Content-Id: <273C015E-AED0-468E-9394-380D31270993@Pride>

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/I NwWK6QAAABl0RVh0
U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAJdSURBVDjLpZP7S1Nh GMf9W7YfogSJboSE
UVCY8zJ31trcps6zTI9bLGJpjp1hmkGNxVz4Q6ildtXKXzJNbJRaRmrXoeWx 8tJOTWptnrNryre5
YCYuI3rh+8vL+/m8PA/PkwIg5X+y5mJWrxfOUBXm91QZM6UluUmthntHqplx Uml2lciF6wrmdHri
I0Wx3xw2hAediLwZRWRkCPzdDswaSvGqkGCfq8VEUsEyPF1O8Qu3O7A09RbR vjuIttsRbT6HHzeb
sDjcB4/JgFFlNv9MnkmsEszodIIY7Oaut2OJcSF68Qx8dgv8tmqEL1gQaaAR tp5A+N4NzB0lMXxo
n/uxbI8gIYjB9HytGYuusfiPIQcN71kjgnW6VeFOkgh3XcHLvAwMSDPohOAD dYQJdF1FtLMZPmsl
vhZJk2ahkgRvq4HHUoWHRDqTEDDl2mDkfheiDgt8pw340/EocuClCuFvboQz b0cwIZgki4KhzlaE
6w0InipbVzBfqoK/qRH94i0rgokSFeO11iBkp8EdV8cfJo0yD75aE2ZNRvSJ 0lZKcBXLaUYmQrCz
DT6tDN5SyRqYlWeDLZAg0H4JQ+Jt6M3atNLE10VSwQsN4Z6r0CBwqzXesHmV +BeoyAUri8EyMfi2
FowXS5dhd7doo2DVII0V5BAjigP89GEVAtda8b2ehodU4rNaAW+dGfzlFkyo 89GTlcrHYCLpKD+V
7yeeHNzLjkp24Uu1Ed6G8/F8qjqGRzlbl2H2dzjpMg1KdwsHxOlmJ7GTeZC/ nesXbeZ6c9OYnuxU
c3fmBuFft/Ff8xMd0s65SXIb/gAAAABJRU5ErkJggg==

--Apple-Mail-12-951209973--

--Apple-Mail-11-951209973--

Report this message

#2: Re: Odd MySQL Problem...

Posted on 2011-10-14 06:09:22 by Karl DeSaulniers

--Apple-Mail-1-955746280
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit

Its looking for an integer not a string for the number of characters.
I think..

Eg : number_pad($n, 4);


On Oct 13, 2011, at 9:53 PM, Jason Pruim wrote:

> number_pad($n, "4");


Best,

Karl DeSaulniers
Design Drumm
http://designdrumm.com


--Apple-Mail-1-955746280--

Report this message

#3: Re: Odd MySQL Problem...

Posted on 2011-10-14 09:36:47 by David Robley

Jason Pruim wrote:

> 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:
>
>
> Edit Inline Edit Copy Delete 212 200 0 6800001
> Edit Inline Edit Copy Delete 212 200 1 6800002
> Edit Inline Edit Copy Delete 212 200 2 6800003
> Edit Inline Edit Copy Delete 212 200 3 6800004
> Edit Inline Edit Copy Delete 212 200 4
>
>
> echoed 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", "XXXXXX", "XXXXXX", "XXXXXX")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 = fgetcsv($handle, 1000, ",")) !== FALSE) {
> print_r($data);
>
> foreach( range(0, 9999) AS $n) {
> //echo "<BR>DATA: " . $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 Pruim
> lists@pruimphotography.com
SQL: INSERT INTO phonesite (areacode, exchange, subscriber) VALUES(212, 200,
0001)
SQL: INSERT INTO phonesite (areacode, exchange, subscriber) VALUES(212, 200,
0002)

Note the lack of single quotes on the third value; mysql will treat those as
integers - especially if subscriber is an integer type :-)

If you absolutely have to store the leading zeros you'll need to store them
in a char type and quote them when INSERTing or UPDATEing



Cheers
--
David Robley

<-------- The information went data way --------
Today is Boomtime, the 68th day of Bureaucracy in the YOLD 3177.


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Report this message