Tweet
After troubleshooting my php code and finding nothing wrong, I went back to the SQL, and it is failing the simplest query. This used to work...what am I doing wrong?
mysql> select handle from stats;
+------------------+
| handle |
+------------------+
| 'Jimmy Swaggart' |
+------------------+
1 row in set (0.00 sec)
mysql> select password from stats;
+----------+
| password |
+----------+
| 'sinner' |
+----------+
1 row in set (0.00 sec)
mysql> select handle from stats where password='sinner';
Empty set (0.00 sec)
WTF??? Shouldn't this return 'Jimmy Swaggart'?
-d
mysql> select handle from stats;
+------------------+
| handle |
+------------------+
| 'Jimmy Swaggart' |
+------------------+
1 row in set (0.00 sec)
mysql> select password from stats;
+----------+
| password |
+----------+
| 'sinner' |
+----------+
1 row in set (0.00 sec)
mysql> select handle from stats where password='sinner';
Empty set (0.00 sec)
WTF??? Shouldn't this return 'Jimmy Swaggart'?
-d
Comment