RE: [PHP] Trying to insert a large number from php to mysql

2006-12-20 Thread WeberSites LTD
berSites LTD Cc: php-general@lists.php.net Subject: Re: [PHP] Trying to insert a large number from php to mysql WeberSites LTD wrote: > I'm trying to insert the number 1970324970930197 into a mysql > BigInt(20) field. > If I do a direct insert from mysql command prompt and select the

Re: [PHP] Trying to insert a large number from php to mysql

2006-12-20 Thread Robert Cummings
On Wed, 2006-12-20 at 10:58 -0500, Jon Anderson wrote: > WeberSites LTD wrote: > > I'm trying to insert the number 1970324970930197 into a mysql BigInt(20) > > field. > > If I do a direct insert from mysql command prompt and select the record I > > get > > back the same number. > > > > If I do th

Re: [PHP] Trying to insert a large number from php to mysql

2006-12-20 Thread Jon Anderson
WeberSites LTD wrote: I'm trying to insert the number 1970324970930197 into a mysql BigInt(20) field. If I do a direct insert from mysql command prompt and select the record I get back the same number. If I do this from PHP I get back 197032497093. Notice that the 197 at the end is not 000

[PHP] Trying to insert a large number from php to mysql

2006-12-20 Thread WeberSites LTD
Hi I'm trying to insert the number 1970324970930197 into a mysql BigInt(20) field. If I do a direct insert from mysql command prompt and select the record I get back the same number. If I do this from PHP I get back 197032497093. Notice that the 197 at the end is not 000. When echoing the