Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

udp high ports, d-link extract firmware dsl-2750u, wwwwxxxxx.2G, yxxxcom, WWWXXX, ftp://192.168.100.100, wwwxxx 100, www.xxxcon, wwwxxx, oom killer misbehaves postgresql

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