I am designing a property web site, using mysql on dreamweaver, I have four tables, one with property details, one with property location, one with property type and another with current exchange rates.
As you can probably see from the query below I have managed to creat a recordset with various fields from these tables, however I am stock on the last part. Now, I would like to display USD aswell as GBP on the results pages, so far I have managed to have GBP calculated and related to its specific record but what I would like to do is also somehow incorporate USD in to this query also, can this be done, if so what function should I use, I am a complete beginner and this is my first site.
SELECT property.*,location.Location,proptype.PType,round(property.Euro*cer.CER) as 'GBP'
FROM property,location,proptype,cer
WHERE property.LocationID=location.LocationID AND property.PTypeID=proptype.PTypeID AND property.StatusID=1 AND cer.ExchangeID=1 AND CategoryID LIKE 'varCat' AND Location LIKE 'varLoc' AND PType LIKE 'varType' AND Euro BETWEEN varPrcmin AND varPrcmax AND Beds>= varBedmin
ORDER BY Euro
Notes: the cer table has two columns ExchangeID which is the Primary Key and CER which is the Current Exchange Rate.
Many thanks in advance.
As you can probably see from the query below I have managed to creat a recordset with various fields from these tables, however I am stock on the last part. Now, I would like to display USD aswell as GBP on the results pages, so far I have managed to have GBP calculated and related to its specific record but what I would like to do is also somehow incorporate USD in to this query also, can this be done, if so what function should I use, I am a complete beginner and this is my first site.
SELECT property.*,location.Location,proptype.PType,round(property.Euro*cer.CER) as 'GBP'
FROM property,location,proptype,cer
WHERE property.LocationID=location.LocationID AND property.PTypeID=proptype.PTypeID AND property.StatusID=1 AND cer.ExchangeID=1 AND CategoryID LIKE 'varCat' AND Location LIKE 'varLoc' AND PType LIKE 'varType' AND Euro BETWEEN varPrcmin AND varPrcmax AND Beds>= varBedmin
ORDER BY Euro
Notes: the cer table has two columns ExchangeID which is the Primary Key and CER which is the Current Exchange Rate.
Many thanks in advance.