[UKSwift]

Hi,

I'm wondering if anyone can give me a kick start on how i can do this. I am working on a Real Estate script for post nuke. I am wanting to write a block that will randomly display a property that is featured.

In the table that the property is stored a field will be filled in with either:

Yes - for being featured
No - for not being featured

I am wanting to randomly display any property that has a Yes in the featured field of the database.

Any help on this matter will be greatly appreciated.

Regards

Tim

[mdhall]

$query = SELECT fields FROM table_name WHERE field_name='Yes" ORDER BY rand()";

Replace "fields" with "*", id, or whatever fields you want to retrieve; replace "table_name" with the name of your table; replace "field_name" with the field that holds the "Yes" value.

See if that works.