Paul,
Your select fails because you are searching for a numeric value on a NULL field.
The NULL value means no data, and is different from values such as 0 for numeric types or the empty string for string types.
If you add a value to your NULL field then it will work.
Check your mySQL docs.
3.3.4.6 Working with NULL Values
6.1.1.4 NULL Values
A.5.3 Problems with NULL Values
Bob
http://totallyfreeads.com
Your select fails because you are searching for a numeric value on a NULL field.
The NULL value means no data, and is different from values such as 0 for numeric types or the empty string for string types.
If you add a value to your NULL field then it will work.
Check your mySQL docs.
3.3.4.6 Working with NULL Values
6.1.1.4 NULL Values
A.5.3 Problems with NULL Values
Bob
http://totallyfreeads.com