OT: Text in and number out?

i building array of zip codes, , writing temporary
data table following markup -

foreach($ziparray $key => $value) {
$ziparray[$i]=substr($value,0,5);
mysql_select_db($database_selectdata, $selectdata);
mysql_query("insert tbltemp (tempzip,recordid) values
($ziparray[$i],$i.)");
$i++;
}

the tempzip field has been created text field. why data come
out numeric? causes "09475" read "9475", example....

--
murray --- icq 71997575
adobe community expert
(if *must* email me, don't laugh when so!)
==================
http://www.dreamweavermx-templates.com - template triage!
http://www.projectseven.com/go - dw faqs, tutorials & resources
http://www.dwfaq.com - dw faqs, tutorials & resources
http://www.macromedia.com/support/search/ - macromedia (mm) technotes
==================

on 26 sep 2006 in macromedia.dreamweaver.appdev, murray *ace* wrote:

> building array of zip codes, , writing
> temporary data table following markup -

- how building $ziparray?
- print_r($ziparray); like?

--
joe makowiec
http://makowiec.net/
email: http://makowiec.net/email.php

More discussions in Develop server-side applications in Dreamweaver

adobe