FindMeApartment |
 |
|
|
 |
 |
Rent Best Apartments in Barrie |
Warning: mysql_query() [function.mysql-query]: Access denied for user 'apache'@'localhost' (using password: NO) in /var/www/vhosts/findmeapartment.com/httpdocs/handlers/rentin.php on line 39
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/vhosts/findmeapartment.com/httpdocs/handlers/rentin.php on line 39
MySQL err: Access denied for user 'apache'@'localhost' (using password: NO)
SELECT L.listingID, L.title, L.price, L.comments, L.street1, L.street2,
RT.rentTypeTitle,
C.cityName,
(SELECT filePath FROM listingsRentPhotos lRP WHERE lRP.main=1 AND lRP.listingID=L.listingID) AS fPath
FROM rentType RT
LEFT JOIN listingsRent L USING (rentTypeID)
LEFT JOIN city C USING (cityID),
landLord U
WHERE L.active=1 AND U.userID=L.userID AND expirationDate>=NOW()
ORDER BY activationDate DESC | | |
