small problem

[Anonymous]

hallo everybody !

I have text box. When I enter a number string (ex:123456789123456789) , mysql will review "123456767+4e".
However, I just used "(string) (123456789123456789)".

please explain me

thks

best regrads

 

[Anonymous]

what data type u have used?

 

[Alexej Kubarev]

i suggest you using TEXT type in the my sql database. by default most programs and phpMyAdmin will use INT

 

[Anonymous]

ok
data type is varchar()
thks
best regards

 

[Anonymous]

try this one

$a = "123456789123456789";

I mean put quotes around number-string.

 

[Alexej Kubarev]

Shouldn't really make any difference... but you should try...
I still dont get why in some times it changes... i think i should make a call to MySQL soon

 

[Anonymous]

okie

if (is_numeric($value)) $value= $valule." ";

thks

best regards

 

[Alexej Kubarev]

Okej... hehe