need help in my sql statement

[pixeltrace]

i need help on my mysql statement.

i want to have an output similar to the portfolio updates on this page

http://mango.resonance.com.sg/ILEC/home.php

wherein the property items is displayed in 3 columns.

i actually have the code for the displaying in 3 columns already

but my problem is i dont know how to code the sql statement for this.

 

what i wanted to achieve is to only display the latest 3 updates for the 3

property name (macao, raffles, zayed)

 

something like this

select propety_name, property_desc from property where property name =  raffles, macao, zayed
order by date_created limit 1(per property_name)

 

hope you could help me with this.

 

thanks!

 

[pocobueno1388]

Give this query a try

 

SELECT propety_name, property_desc FROM property 
WHERE property_name= 'raffles' OR  property_name='macao' OR property_name='zayed'
ORDER BY date_created DESC 
GROUP BY property_name
LIMIT 3

[teng84]

@pixeltrace you missed IN

 

SELECT propety_name, property_desc FROM property

WHERE property_name in ('raffles' ,'macao','zayed' )

ORDER BY date_created DESC

GROUP BY property_name

LIMIT 3

[pixeltrace]

its workng

 

i just removed the group by from the string.

 

thanks!

[pocobueno1388]

If you remove the GROUP BY it's going to return the last 3 property_name's regardless if it has already displayed that property name already.

 

Don't forget to press solved if you have it working how you want