BINARY problems

[khadgardk]

Hi,

I'm coding on my own server (laptop) and I have this login script.

On my laptopserver I query my DB for a "WHERE BINARY user=$user..."

It works, however, when I upload it to my webhotel the BINARY part does not work ... the query return zero ... and if I remove the BINARY it works perfectly ... except for the CASE SEN.

Any suggestions?

[bogu]

What is the error it gives u?

Where u execute your query add this: or die(mysql_error());

Or add your code here ...

BTW, with binary, the index cannot be used, a solution is to apply the binary operator to the constant, then the index is used (so your query will be much faster):

WHERE user = BINARY $user

[khadgardk]

thx bogu, but I didn't get any errors - it just returned zero

However, I found the error! It turned out that when you import from another dBase the "Coalition" does not get imported. So the dBase was set to a caseinsensitive markup.

So therefore I must say that it was a "errorcode 40" ... 40cm away from the screen :-)

[bogu]

khadgardk wrote:

So therefore I must say that it was a "errorcode 40" ... 40cm away from the screen :-)

:p