int unsigned type mismatch
hello
In PHP I took a field in database as INT UNSIGNED
I am running many queries based on this field in my script
The problem is that it is running fine on localhost
but when uploaded to web server its not working.
sql statement is not fetching row, i think the field
is working as string because when i changed the field
to VARCHAR its working.
also i am adding 1 to this field without typecasting
it as INT it is working
please if someone know litle about this problem please suggest some sugesstions ...
thanks
ankur bhatnagar
[605 byte] By [
ifw] at [2007-11-19 19:53:29]

# 1 Re: int unsigned type mismatch
hello
In PHP I took a field in database as INT UNSIGNED
I am running many queries based on this field in my script
The problem is that it is running fine on localhost
but when uploaded to web server its not working.
sql statement is not fetching row, i think the field
is working as string because when i changed the field
to VARCHAR its working.
also i am adding 1 to this field without typecasting
it as INT it is working
please if someone know litle about this problem please suggest some sugesstions ...
thanks
ankur bhatnagar
Are the data types for both tables identical? You can check this by using the query describe table_name.