Help! PHP MySQL Query fails. The first two pass, but the last one returns zero records.?

H

hankaaron

New member
Pass: SELECT * FROM entry_influ WHERE date_period = 201010021
Pass: SELECT * FROM entry_influ WHERE name = 'Coffee - Decaf'
Fails: SELECT * FROM entry_influ WHERE date_period = 201010021 AND name = 'Coffee - Decaf'
The values in this code for date_period and name, are in the same record. That is why I am puzzled as to why the AND query fails.
Thanks.
 
Back
Top