ive hit a wierd snag in my mailing list application.
This query returns what it is supposed to:
SELECT *
FROM mailinglist
WHERE name_first = 'aasd'
AND name_last = ''
AND address_1 = 'asd'
AND address_2 = ''
AND city = 'a'
AND state = 'a'
But This query returns nothing:
SELECT *
FROM mailinglist
WHERE name_first = 'aasd'
AND name_last = ''
AND address_1 = 'asd'
AND address_2 = ''
AND city = 'a'
AND state = 'a'
AND zip = 'a'
Adding that last line (AND zip = 'a') seems to crap out the query. Any idea why? This is running directly from phpmyadmin, not from php, although the same thing happens from a php driven query.
(and yes, the data im searching for is in the table.)
This query returns what it is supposed to:
SELECT *
FROM mailinglist
WHERE name_first = 'aasd'
AND name_last = ''
AND address_1 = 'asd'
AND address_2 = ''
AND city = 'a'
AND state = 'a'
But This query returns nothing:
SELECT *
FROM mailinglist
WHERE name_first = 'aasd'
AND name_last = ''
AND address_1 = 'asd'
AND address_2 = ''
AND city = 'a'
AND state = 'a'
AND zip = 'a'
Adding that last line (AND zip = 'a') seems to crap out the query. Any idea why? This is running directly from phpmyadmin, not from php, although the same thing happens from a php driven query.
(and yes, the data im searching for is in the table.)