MargateSteve

We recently had our account suspended (without warning - thanks 1&1) due to exceeding server load. The reason this happened was there were quite a few divs that were refreshing (via Ajax) every 9 seconds to give a 'live update' on the site (it is a sports site so this …

On the surface, the top n per group query is a fairly common one and I have used a few variations on other projects. However, I really cannot get my head around this one and I think it is due to the number of joins. My query (at the bottom …

I am trying to create a soccer results matrix from an existing database (tables and current query are at the bottom of the post) and am not sure where to start with it. It is a bit hard to explain (unless you are a soccer fan where these results matrix's …

What code are you using to store the session? I am no expert and the way I do it may be wrong but........ I use the following code to verify the log in [CODE=php]#CHECK BOTH USERNAME AND PASSWORD FIELDS HAVE BEEN ENTERED if(!empty($_POST['Lname']) AND !empty($_POST['Lpassword'])) {//Username and password have both …

I have found a fairly generic script for refreshing the content of a div without refreshing the whole page and although it works fine, there are a few things I would like to improve on if they are possible. [CODE]<script src="http://code.jquery.com/jquery-latest.js"></script> <script> $(document).ready(function() { $("#refreshdiv").load("activity.php"); var refreshId = setInterval(function() { …

I have hit a bit of a stumbling block with a project I am working on. Basically it tracks football (soccer) results and everything works fine as things are but I there is something else that I hope to do now that I cannot get my head around. Basically, there …

Back in February,smantscheff helped me with a problem where I was trying to aggregate data between two queries and after the suggestion of creating two views, everything worked perfectly. However, I failed to look ahead and see a potential future problem! The original thread is [URL="http://www.daniweb.com/web-development/databases/mysql/threads/347065/1473368#post1473368"]http://www.daniweb.com/web-development/databases/mysql/threads/347065/1473368#post1473368[/URL] and quite simply, as …

I have a query which generates a soccer standings table and am trying to create a different version which will only include the 6 most recent games for each team. An example of the output of my current query can be seen [URL="http://www.margate-fc.com/content/test/standings.php?season_id=104"]HERE[/URL]. The full query is below and I …

I have a query which generates a soccer standings table and although it works fine there I am trying to implement a couple of variations on it but everything I have tried has failed. I have searched and asked many times and for both problems and it seems as though …

I currently have two queries that separately show goals scored and appearances made by players in a football team but need to bring them together in one query so I can aggregate results against each other, as well as output records from both in one html table. The two queries …