boko605

contact me at bnazarov@abv.bg with more information

Hi, i have some troubles with a script. I have 2 DB. DB1 - in witch i collect information about propeties(real estates). DB2 - in witch i have the names of the cities in cyrilic and in latin. My web site have two version. Bulgarian and English. When someone make a search by city, each city has a number that is the same as the ID in DB2. $query = "select d1.* , db2.citynameinenglish // must select all the info from DB1 and the name of the city in english from DB1 d1, DB2 d2 where d1.salerent='$salerent'"; // sale or for rent if($type!="") $query=$query." and d1.type='$type'"; // if the type of the property is selected if($city!="") $query=$query." and d2.city='$city'"; // if a city is selected if($price!="") $query=$query." and d1.price<='$price"; // if a price is inputed $result = mysql_query($query); $num_results = mysql_num_rows($result); Ok, in my opinion this must work but it doesnt. I have 10 entries in DB1 and the result of this query is more than 400 entries?? ??? Any suggestions?