Hi Everyone,
I am having some problems with mysql_num_rows.
When I run this simple query, it mysql_num_rows return 0, instead of 1. If I take this query and run it on the db, it returns one row, but if I run it in my script and call mysql_num_rows it always shows 0.
The query is:
SELECT PlayerID,ClubID
FROM ITPlayer
WHERE PlayerFirstName='Bev'
AND PlayerLastName='Jones'
AND ClubIndexID=5221
We have recently gone to a newer version of php and a new version of mysql.
I've searched all over for help on this. I would really appreciate any ideas anyone might have as to why this happens. I am convinced that it is related to the newer version of php or mysql, as this did not occur before we made the upgrade.
If you would like to know what i've found in my search so far, please see my notes below:
Here's what i've found so far, but my knowledge is limited so I don't know if it is relevant, and I don't know where to look for these things.:
Problem: mysql_num_rows problem - it says 0 rows returned in stead of the actual number of rows.
1) Someone wrote this regarding the same type of issue: "By the way, I've just found that this only happens when NO_CLIENT_LONG_LONG is defined... Shouldn't it work either way?"
I don't know where this NO_CLIENT_LONG_LONG value is defined.
2) I also found this on the same topic (different post):
"The NO_CLIENT_LONG_LONG variable in order to link to the new mysql.h library and I did change my code to take an unsigned long as a return parameter for these functions... Still the return value is always 0? "
Again I still cannot find that NO_CLIENT_LONG_LONG variable.
3) Another person posted: Are you sure the md5() function in PHP produces the same output as the MD5() function in MySQL?
What is the md5 function?
