Page 1 of 1

Need help for UNSIGNED ZEROFILL Issue

Posted: Wed Sep 29, 2004 7:48 pm
by Nightrid3r
Hi Im not a php pro i learn on myself most of the stuff and i got to learn much of simple php.

Now my little problem is the following : I have 2 db's on a web site one the unique id as auto increment no values no UNSIGNED ZEROFILL....so when its time to call row its easy because the upladed files cary the same #...my problem is that the second db as UNSIGNED ZEROFILL and that when i call my files using ex- $id2 i get the good num but a bunch a 000 infront wich is normal but now all my other scripts i have created cant show the files cause i dont know how to remove the UNSIGNED ZEROFILL on a query so only the value shows and i dont have to change the forms that up the files with id but no zerofill .... how do i get around this how to display files and remove the 0000 with out changing the db current seetings....

Hope im clear.... Hope its an easy command i missed out and one of you can help me out. I've been searching on the web for this havent found anything. Thanks in advance.

Posted: Wed Sep 29, 2004 7:50 pm
by feyd
I'm a bit foggy on your english, but I think you might want to play with [php_man]intval[/php_man]()