php - Zip Code missing leading 0 when retrieved from mySQL tables -

-

i storing 5 digit zip codes in mysql tables char(5). when zip code leading zeroes (ie. 02138) retrieved tables, becomes 2138. since being stored in tables 02138 (checked phpmyadmin), has php stripping off leading 0? how can make sure retain leading 0?

i'm using quite long sql query string using activerecords in codeigniter.

foreach($q $row){         /// bunch of code adds more elements $row array          $data['rows'][] = $row;     } 

str_pad($zip, 5, 0, str_pad_left);

Comments

Post a Comment

Popular posts from this blog

iphone - Request for member 'uitextfield' in something not a structure or union? -

-
working through several other problems have found myself @ point. have learnt alot stuff trying 1 stumped on. i writing textfield format login have on app, , because apple don't have resembling textfield mask have decided write own custom cell looks has mask on doing concatenating textfields in background. however have struck problem. trying call textfield:shouldchangecharactersinrange:replacementstring: of uitextfield in subclassed uitableviewcell outlined in code below. im receiving request member 'uitextfield' in not structure or union error... appreciated. ////.h @interface registerdeviceviewcontroller : uiviewcontroller <uitableviewdelegate, uitextfielddelegate> { registerdeviceviewcontroller *registerdeviceviewcontroller; //uitextfields registration cell uitextfield *regfieldone; uitextfield *regfieldtwo; uitextfield *regfieldthree; uitextfield *regfieldfour; uitableviewcell *myregistrationfield; uitableviewcell *my...
Read more

haskell - Using filter on an item in a list? -

-
i trying filter item in list , print them line line. here's code: data car = car string [string] int [string] testdatabase :: [car] testdatabase = [car"casino royale" ["daniel craig"] 2006 ["garry", "dave", "zoe", "kevin", "emma"],car"blade runner" ["harrison ford", "rutger hauer"] 1982 ["dave", "zoe", "amy", "bill", "ian", "kevin", "emma", "sam", "megan"]] formatcarrow (car b c d) = show ++ " | " ++ concat [i ++ ", " | <- init b] ++ last b ++ " | " ++ show c ++ " | " ++ concat [j ++ ", " | j <- init d] ++ last d displayfilmsbyyear :: string -> io [()] displayfilmsbyyear chosenyear = mapm (putstrln.formatfilmrow) [putstrln(filter ((== chosenyear).y)) | (w x y z) <- testdatabase] -- code not working think why isnt work...
Read more

Cursor error with postgresql, pgpool and php -

-
hey, struggling bit determine exact cause of error has been popping in our release environment. there not seem dealing particular error on google. this error message getting: sqlstate[34000]: invalid cursor name: 7 error: portal "" not exist the error pops when using pdo prepared statements. this setup our release environment: pgpool 3.0.1 (the postgresql backend in streaming replication mode!) php 5.3.5 postgresql 9.0 edit: architecture 64bit. the same error not manifest in our test environment (edit: forgot mention, standard test environment uses postgresql 9.0 without pgpool). thus, led suspect pgpool @ least partly suspect. does know probable causes error are? edit: ok, here example of kind of code causes error. $sql = 'select * '; $sql .= 'from "mytable" "mystuff" '; $sql .= 'where "mytable"."status" = 1 '; $sql .= 'and "mytable"."mytableid" = :table...
Read more