Mysql Error(Unknown column 'p.newDev' in 'field list')
Query:
SELECT p.id,
p.status_id,
p.agent,
p.ref,
p.newDev,
p.newdevRef,
t.property_type_fr as property_type,
r.region_fr as region,
r.region_fr as region,
p.summary_fr as summary,
p.price,
p.name,
p.rent_price,
p.discountFrom,
p.discountTo,
a.area_fr as area,
p.beds,
p.rental_type,
p.fromDate,
p.fromMonth,
p.fromYear,
p.toDate,
p.toMonth,
p.toYear,
p.baths,
p.propm2,
p.plotm2,
p.description
FROM properties as p
INNER JOIN property_type as t ON p.type_id = t.id
LEFT JOIN region as r ON p.region_id = r.id
LEFT JOIN area as a ON p.area_id = a.id
WHERE p.status_id != 2 AND p.status_id != 6 AND p.module = 'Rental' AND p.type_id = 58
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/it-design.es/inc/search.php on line 174
Mysql Error(Unknown column 'p.newDev' in 'field list')
Query:
SELECT p.id,
p.status_id,
p.agent,
p.ref,
p.newDev,
p.newdevRef,
t.property_type_fr as property_type,
r.region_fr as region,
r.region_fr as region,
p.summary_fr as summary,
p.price,
p.name,
p.rent_price,
p.discountFrom,
p.discountTo,
a.area_fr as area,
p.beds,
p.rental_type,
p.fromDate,
p.fromMonth,
p.fromYear,
p.toDate,
p.toMonth,
p.toYear,
p.baths,
p.propm2,
p.plotm2,
p.description
FROM properties as p
INNER JOIN property_type as t ON p.type_id = t.id
LEFT JOIN region as r ON p.region_id = r.id
LEFT JOIN area as a ON p.area_id = a.id
WHERE p.status_id != 2 AND p.status_id != 6 AND p.module = 'Rental' AND p.type_id = 58 ORDER BY p.id DESC LIMIT 0, 20
Villa en location Estepona | Villa in Spain
Languages:
Locations vacances sur la Costa del Sol, Estepona -Espagne