simple php/mysql questions

Placebo

When injecting an integer like 0024, mysql or perhaps php omitts the first two 0's and enters 24,
tried using varchar/text, no luck.

Chardee MacDennis

just cast it as a string first...

Webmonkey

or if you printing and it will always be 4 digits:

[php]printf("The number is %04d", 24);[/php]

But it looks like you mean when storing in a DB. Having 0's before an integer has no meaning to an integer type so they are ommitted. As above, use a char/string instead.

Placebo

doesnt work ? varchar data type...

tried


$code1 = "$code[0]";

and

$code1 = (string)$code[0];

//its an array value.




Just gonna use zerofill in type INT, and limit it to 4, so 24 will be 0024, this field will always be 4 digits max so it works out
but not sure why other stuff didnt work, annoying...

Liam Byrne

str_pad_left ?

louie

set the field as "varchar. int or numeric will remove the 0