Need help for UNSIGNED ZEROFILL Issue
Posted: Wed Sep 29, 2004 7:48 pm
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.
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.