emery_k
asked on
Script (or ?) to change site content
We are trying to set up a web site that includes a list of about 25 members. We want a `featured member section' and have the site feature a different member each day so it rotates between the different members.
Any suggestions how to accomplish this?
The member list may grow so we hope there is someway it will accomodate growth in the member list.
TIA for your help
Any suggestions how to accomplish this?
The member list may grow so we hope there is someway it will accomodate growth in the member list.
TIA for your help
This would almost certainly need to be a database solution. Maybe include a "HasBeenShown" field which would be added to each time that person has been shown. Then you just order the database request by this field and show the top one. Whenever someone new is added they would automatically be added. The down side to this is they would be shown continously until they reach the same number as the next lowest.
In which case you could also add a "DateLastShown" field and make sure that date is at least a certain amount prior to the current date. Maybe even the size of the database (rowcount) less 1. You may even be able to use this field alone and just order by that and take the top value.
In which case you could also add a "DateLastShown" field and make sure that date is at least a certain amount prior to the current date. Maybe even the size of the database (rowcount) less 1. You may even be able to use this field alone and just order by that and take the top value.
ASKER
They haven't even chosen a hosting company yet so we have options there. I was considering www.ipowerweb.com as the host. That would give us MySql. In terms of new members they would just join the list and come up in turn. OR have the `featured member' change on every access of the page. If there were 25 members and 25 visitors in one day each member would be `featured' once that day. We want all members to get essentially equal exposure but it doesn't have to be perfect. A new member just joins the pool and gets their share of exposure after that. I was hoping for something a simpler than using a database.
Well something has to keep track of who's turn it is, whether is a daily change or every page access. There is no way to do that client side so it either has to done manually by changing the page every day, or you need a script on the server.
The isp you listed indicates support for cgi and php. Either of those can do the job, but it information has to be somewhere on the server. You need at least a file to keep track of which member to feature. The information about the members must also be stored.
The member information could be stored in a databse, or you could have a page for each member. If you only have a small amount of information that has to be supplied about the members, it could be kept in an array on the main page, or if you need to support IE only you could use XML data islands on the client.
If you use a database, then the main page could be a php page, the executes a query and populates a div or table cell with the member information. If you use member pages then an Iframe would be ideal and the source for the iframe could be a small cgi or php script that returns the page for the currently featured member.
Cd&
The isp you listed indicates support for cgi and php. Either of those can do the job, but it information has to be somewhere on the server. You need at least a file to keep track of which member to feature. The information about the members must also be stored.
The member information could be stored in a databse, or you could have a page for each member. If you only have a small amount of information that has to be supplied about the members, it could be kept in an array on the main page, or if you need to support IE only you could use XML data islands on the client.
If you use a database, then the main page could be a php page, the executes a query and populates a div or table cell with the member information. If you use member pages then an Iframe would be ideal and the source for the iframe could be a small cgi or php script that returns the page for the currently featured member.
Cd&
You may want to consider banner code. There are a multitude of them around and although it may not be an ad the process would be identical I am sure. But, as both Cd& and I am saying, you will need a database of some description.
perl or asp or something else?
whatever language be it, there will be a function called rand() or srand() or something else, which will generate a random number between 0 and n,
and then with the random number you can write a good select statement that suits your needs.
to accomodate growth in the member list is pretty easy, infact all that has to be done is to create a member table in you sql based database and then keep on using the insert command as and when required.
please specify which programming language you are using inorder to explain to you in more detail. i can help with perl.
whatever language be it, there will be a function called rand() or srand() or something else, which will generate a random number between 0 and n,
and then with the random number you can write a good select statement that suits your needs.
to accomodate growth in the member list is pretty easy, infact all that has to be done is to create a member table in you sql based database and then keep on using the insert command as and when required.
please specify which programming language you are using inorder to explain to you in more detail. i can help with perl.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bruno
Comment appreciated.
link to similar question is https://www.experts-exchange.com/questions/20312368/Different-graphics-when-a-page-loads-or-time-based.html
The solution mentioned there seems like the way to go. The links to specific examples help.
Create an image for each member and rotate between them. This can be done without getting into a database. The membershiplist is not apt to change much.
Thanks
Comment appreciated.
link to similar question is https://www.experts-exchange.com/questions/20312368/Different-graphics-when-a-page-loads-or-time-based.html
The solution mentioned there seems like the way to go. The links to specific examples help.
Create an image for each member and rotate between them. This can be done without getting into a database. The membershiplist is not apt to change much.
Thanks
just their name?
Are you using a database to store member information. What scripting capabilities do you have server side?
A little more detail about what you are trying to do would help.
Cd&