Don't know if it's useful at all, but a tiny forum I run consists of a mere 10 users, has around 100 good sized posts, and is only 0.5MB in size. I guess you could scale that up relatively easily.
...

Hey, this is my first attempt at using arrays in PHP, so apologies if this turns out to be ridiculously simple!

I have a SQL select statement, and a while statement to pull the results from it:
...

I've PM'd you the link to it. I will post the solution for others (if I find it) later, once I've stripped out my password and stuff from the code!

I have a form where you select a player's name from a drop down list, and there are 6 input boxes next to it for their separate scores and a box at the end for their total score (all the separate...

Aye, it's a tricky one to explain, but thanks for the replies guys!

I'm not sure what more I can say in addition to my original post though. The current SQL query I'm using is there in that post,...

Anyone? Any ideas on how to perform further calculations on a set of results from a SQL statement? There's a Gmail invite and/or my eternal love winging its way to whoever comes up with the goods! :)

I've got a query set up that generates a resultset of players and their statistics, and this is displayed back out in a table via PHP:

Query: $sql = 'SELECT nickname AS name, count( * ) AS played,...

I'm trying to find or create a Perl script that at runtime will simply take a specified logfile or logfiles, and append todays date onto the end of it's name. If possible, I would also like the...

Worked it out...

I'm no SQL expert, but that still looks like it's got a nested query in it. In fact, it's exactly the same as mine, except you've substituted players for p, and scoreslist for s.

A project that I've been working on (and getting help on here (http://www.daniweb.com/techtalkforums/thread10421.html)) is just about complete, but I've had to develop it locally on MySQL 4.1 for...

SELECT nickname, count( * ) , sum( score ) , max( score ) , min( score ) , avg( score )
FROM players, scoreslist
WHERE players.playerid = scoreslist.playerid AND scoreslist.matchid
IN (

SELECT...

Actually, that should be...

SELECT playerid, score
FROM scoreslist
WHERE matchid in (
SELECT matchid
FROM matches
WHERE season =2004
);

Actually, even my nested skills obviously aren't up to scratch - all I've got so far is...

SELECT playerid, score
FROM scoreslist
WHERE IN (
SELECT matchid
FROM matches
WHERE season =2004
)

Woo hoo! PHP is starting to make sense to me! Thanks - I've got it updating the database now.

Now I know there is a DB section on this site, but I figured most of the background is in here, so...

Right, I can see how to interact with a DB now. The next step, for my submit page I want to pull all the player names from a table in the database, and have those names available under a drop-down...

Thanks for the reply. I've actually had a look around this site and discovered some code snippets here (http://www.daniweb.com/techtalkforums/thread6958.html), which shows how to build a page that...

Anyone able to give me, or knock up, a sample bit of PHP code that would take the following text file (called statistics.txt)...

Player 1, 4, 140, 38, 35, 35.0
Player 2, 5, 200, 46, 36, 40.0...

Thanks, downloaded and installed, and it does indeed look very good.

Anyone able to comment on how tricky the project I described would be for a newbie, or indeed an expert?

I was considering...

I've at least *seen* PHP code before, and have modified my own phpBB forum moderately.

However, I've been set a project to build a web interface for recording skittles scores (like 10-pin bowling,...