display results in my database according to 2 fields in a table

[Watcher32]

i want to display results in my database according to 2 fields in the same listingsdbelements.listingsdbelements_field_value table, i'm not sure if this is possable, or if i'm doing it correctly

ie, from

default_en_listingsdbelements.listingsdbelements_field_value = 'Arizona'

and

default_en_listingsdbelements.listingsdbelements_field_value = 'Usa'

here is my sql statement:

SELECT default_en_listingsdb.listingsdb_id, listingsdb_title, default_en_listingsdbelements.listingsdb_id, listingsdbelements_field_value 
FROM default_en_listingsdb, default_classlistingsdb, default_en_listingsdbelements 
WHERE (listingsdb_active = 'yes') 
AND (default_en_listingsdb.listingsdb_id = default_classlistingsdb.listingsdb_id) 
AND (default_en_listingsdb.listingsdb_id = default_en_listingsdbelements.listingsdb_id) 
AND (default_en_listingsdbelements.listingsdbelements_field_value = 'Arizona') 
ORDER BY default_en_listingsdb.listingsdb_id ASC

this works above to select just arizona listings

the problem is when i add a extra AND staement like:

AND (default_en_listingsdbelements.listingsdbelements_field_value = 'Arizona')
AND (default_en_listingsdbelements.listingsdbelements_field_value = 'Usa')

the sql returns no results, even tho i have around 30 listings in arizona, usa

i have tried other combos like:

AND ((default_en_listingsdbelements.listingsdbelements_field_value = 'Arizona') AND (default_en_listingsdbelements.listingsdbelements_field_value = 'Usa'))

but i can not seem to get it working, i think i'm doing something wrong with the sql statement, does anyone have any ideas what i'm doing wrong here

thanks in advance

[_uk_stuff]

Try changing the SQL you had from:

AND (default_en_listingsdbelements.listingsdbelements_field_value = 'Arizona')
AND (default_en_listingsdbelements.listingsdbelements_field_value = 'Usa')

To

AND (default_en_listingsdbelements.listingsdbelements_field_value = 'Arizona' OR default_en_listingsdbelements.listingsdbelements_field_value = 'Usa')

This means that the record can be either 'Usa' or 'Arizona'