spikemeister

Hi all, I was wondering if it is possible to convert a photograph into something like a colouring in page. Hope to run a colouring competition on one of my sites and really want to use certain photos. Thanks in advance.

Another question on this subject, more out of curiosity than neccessity. If I were not to store the average score in the DB but calculate it when I retrieve the games played and points fields, would it be possible to sort the table.

Excellent thanks very much for the swift reply

Hi all I have recently written a small script which includes a league table. Everything works just fine except 1 little thing and I really have no idea how to accompish it. When generating the league table I sort the data based on the points people have scored. However if two or more people have the same score I would like those scores to be sorted by their average score. For instance Mr A and Mr B both have a score off 33. But Mr B's average score is 2 while Mr A's average score is 1.5. When sorting the data the way I am now it seems that if the scores are the same the member with the lowest MEMBER_ID number comes first in the table. Would I be better just to retrieve all the data I need for the table and put it all in an array and then sort it, or is it possible to do within my mysql query. Either way I don't know how to achieve the desired outcome. Thanks in advance

Solved. But have no idea how. For anyone who encounters the same problem then here is how i fixed it. The problem in a little more detail. 2 divs one on top of other width 100% each of these 2 divs contained 3 others all taking u just less than a third of the width. I realised what was causing the problem but dont really know why. On the middle div of the top div was php include page. When firefox first loaded the page it ignored this div completelty and aligned itself to the other two. On refresh the page displayed as intended. a simple example outline of the code would be as follows. width of top and bottom div are 100%. <div id="topdiv"> <div id="topleft">Content</div> <div id="topmiddle">content from php include</div> <div id="topright">Content</div> </div> <div id="bottomdiv"> <div id="bottomeft">Content</div> <div id="bottommiddle">content</div> <div id="bottomright">Content</div> </div> So on initial loading of the pagethe topmiddle height was ignored completely by firefox. Solution. After trial and error setting the bottom div min-height:100% and height:auto was the only way i could get it to work. Was this something i should have foreseen or a problem with firefox. Why after refresh does it work? I have no idea

I remember reading about a similar problem to this recently but can't remember where i seen it. Having a strange problem with firefox. Basically i have 2 divs 1 on top of the other. These two two divs each contain a left middle and right div. Everything displays as i intended it to in both IE and firefox but it only displays the way i want it to in firefox after i have refreshed the page. The bottom div rather than sitting below the top one over laps it or wraps around it in firefox, but if i refresh the page it displays the way i want it to. Wondering if anyone has a solution. Is it a known bug in firefox. Not going to post all the code but a quick outline would be each of the two divs are 900px wide.three divs in each of these two are split equally and i have left a small 20 px gap at the side. 3 divs width =880px. All are set to float left. Thanks in advance.

Ye thats roughly what i was thinking, I done something similar in php to display the player or an image in place of the media player at certain times. Got to figure out how to do it client side to display the image in the player. What makes it even more difficult is the fact that i will be working with local time so would need to take that into account. Don't know if it is possible to pass the server time to javascript say, thats what i will look into. Thanks for the reply.

Was hoping to offer some video on one of my sites. Not much maybe a 2 hour slot weekly. However I have a slight problem. Is there anyway to display an image or maybe even a frame of video when there is not a video playing. I,m trying to do this as if it was live. So the 2 hour video can only be watched at a certain time, the rest of the time I would like something displayed in the player that isnt going to use loads of bandwith. I have got it to work where the site checks for the server time and displays the video player when i want it to then displays an image the rest of the time, was just curious really if it was possible manipulate the player to have a default display when no video was to be shown.

In case anyone was wondering how I solved this, I thought I'd post a solution. Thanks for all the suggesions guys but I took an easy way out. Every time the script to refresh the page was called it invoked a counter. Simple really it didn't count the page refresh as one but 10 (refreshed every 10 seconds). Now in the admin area of my site I can see the value that is stored in proper time format. The calculation simply turns the stored seconds into days hours mins and seconds after 5% is of the seconds are removed. I thought 5% would more than compensate for the people who navigated away from the page during refreshes. I print the stats weekly and just reset the value seconds value in the db to 0. May not be the most elegant solution but it works pretty well.

Depends on what the page actually does. If the page or any of the includes say check a database for new entries stories,news etc then it could be referred to as dynamic however if the content of the pages always remains the same then I am assuming it would be considered static. However I think (dangerous thing thinking) that if you used javascript or some other client side scripting that altered a page even in a small way that may also be considered being dynamic. Don't know if the fact the main page would be considered dynamic solely because it was made up of several parts, if those parts never changed.

A friend asked me if I could write a vista gadget radio player that had all his favourite stations on it. I made the gadget without any problem but I was just wondering if it would infringe any laws. Personally I can't see how it is different than streaming it through wmp, winamp, realplayer etc however most people would navigate to the site and click the "listen now" button or something similar (others if possible may bookmark the stream). Is taking the stream itself and "hardcoding" it into a script unlawful. Just curious cos i've seen a lot of these gadgets around.

Certain part of the page uses ajax to update, really don't want to change away from that if possible. As I said the sponsors have not asked for info but would be nice to have it at hand if possible. I will keep looking at possibilities using sessions at the moment as it seems that would be the easiest way to do it. Was also thinking of maybe having a timer hidden on the page. When the page is closed or nevigated away from then I could possibly store the value of the timer. Not sure how feasible this is but I might give it a try. I'm sure there are many possible ways of doing this and I am determind to find at least one custom way of doing. Anyways thanks for the suggestions guys.

Ye it makes sense thanks, was trying various things with sessions after posting my question here. Ive not found a solution yet but ill keep going. Its not quite as complicated as you suggest though. As only part of the page refreshes the logo is constantly on the screen.

Yep the page offers live text updates on a football game and from tests run and feedback most people have the page open for all of the match. It is 1 static sponsors logo on the page.

Recently got a sponsor for one of the pages on a site I am working on. Normally I could provide info to the sponsor on how often the page was shown with there ad on it, however due to the nature of the page (it refreshes itself) I am wondering if it is possible to work out how long a page was displayed for. The sponsor has not requested any information but I would like to have it on hand if they ever do. Chances are the page will be viewed for around 1 hour 45 mins by maybe 30 or so peope (initailly) and rather than say the page was viewed 30 times I would like to be able to say your ad was shown for X amount of hours. The whole page doesnt refresh itself, just a certain part of it. Thanks in advance.