"Smart" Featured Home-Page

[tomyknoker]

Hi All!

I am working on a real estate website, and basically on the "HOME" page of the website it has a featured property. This property is taken directly from the "FOR RENT" page first property. The client changes the "FOR RENT" page each week... How can I make it so that when they do this, the Featured Property text on the "HOME" automatically updates?

The text would come from the "FOR RENT" page TITLE e.g. $400 A Week and the DESCRIPTION e.g. A stunning one bedroom...

Also when the text is used, I only want it to use say the first 25 words of the description... I will then have a link "[ Find Out More ]"...

The index.html attached is where I want the text to automatically sit and it should be taken from the selling.html file attached,

Any ideas?

Did I confuse everyone!?

Thanks,
Tom

[Sheldon]

How are you storing all the houses for rent information in a mySQL database?

[tomyknoker]

they only change the property about once every 2 weeks, so didn't think i'd need a database. just was trying to make it easier for them in regards to updating the text. i thought somehow (wasn't sure how) i could make it so when they change the description and heading of a property in the "for rent" page once it was uploaded to the site, this information would load into the index page of the site...

what do you think?