SQL Problems??

furious5

I'm currently trying to join 2 tables and exclude a field (pricing.price) with a any value < 0, however my SQL seems to keep falling over and returning values containing 0.

Does anyone have any ideas??

SELECT  villas.ID, villas.Name, pricing.ID, pricing.Week, pricing.Availability, pricing.price
FROM villas, pricing WHERE pricing.ID = villas.ID AND villas.resort =  'cala_dor' or villas.resort = 'pollenca' AND pricing.Week = '1093042800' AND pricing.price > 0 AND pricing.Availability = '1' 
[code]

AstroTeg

Not enough info to make an educated guess other than the "or" that you have in your SQL statement may potentially allow 0 value prices in. Maybe try pulling the ' or villas.resort = "" ' clause out and see if you still get records with 0 for a price.

loureiro

i would suggest trying:

SELECT villas.ID, villas.Name, pricing.ID, pricing.Week, pricing.Availability, pricing.price
FROM villas, pricing WHERE pricing.ID = villas.ID AND pricing.Week = '1093042800' AND pricing.price > 0 AND pricing.Availability = 1 AND villas.resort = 'cala_dor' or villas.resort = 'pollenca'

just changed the order...thats what i think your problem! MySQL doesnt understand which to process first and could be getting caught up on the or also i removed the ' from around the 1. if its an int you shouldnt have that there.