ok what you need to do is
make a new table in your database called homepage_featured_diary with three columns, "featuredid" (tinyint(4), auto increment), "featured_name" (varchar(250), "featured_description (mediumtext)"
ok now make a simple cron, it's going to randomly select a record (from the threads table) and then temporarily store that data in order to insert it into the new table)
so you're not gonna insert the id as that's on autoincrement, you're just inserting the name and description
ok now you've got that and it's tested you're gonna upload it and set it to run every however long you want to keep one member on the homepage for.
|