Need Advice - Using SA/DA for running club site

I have a couple of questions, anyone who's able to offer suggestions/advice, I really appreciate it.

Function - I want to allow the runners to "sign in" so that I can track attendance. Prizes are given after 10, 50, 100 runs etc, so I need to be able to run a report that shows a "total number of runs attended".

My approach? - I thought I could create a page where the members can enter their email address and password and submit. On submit, I want to Post (i think) to my table, user_ID (user id and email address in another table), the date (dd/mm/yy), and a default integer of "1" in run_Total column.

Then, on my report, I thought I could use a calculation like SUM(run_Total)


I'm not a coder, so am familiar with support tickets, but was hoping to at least get on the right path first.

use security assist to create a login system

once the user logs in, they could go to a page to submit a run

you would need a table to contain:
date
distance
userID

and other information about the run.


when the user logs in, their ID is stored in a session.

use a form top collect the distance and insert to a database table with the data and the usersID

then you could use sum() like you suggested to return the total runs for a specific uer,

Thank you for your help so far. The club gives members a prize after their 10th run, so i'm trying to create a search page that will return the first/last of runners who meet criteria:

sum(runQty)=10, and
(prize_Received) = 0, and
rundate = [today's date] --- each "run record" includes run_Id, user_Id, run_Date (dd:mm:yy), run_Qty (default 1)

Which should return results that include runners who have 10 runs, including one on the specified day, and who have NOT received a prize yet.

I'm struggling with understanding how to create the search parameters in the search wizard. I clearly know just enough about this to understand what I should do, but not enough to understand how to do it. Sorry.

Ideally, the results would simply show the firstname/lastname from the users table, and to really push my luck, i'd like to be able to have a checkbox next to each where i can indicate which users received the prize and update multiple records at once. simply a "1" in the prize_Received column.

If this is too much for the forum, I'd like to setup a 1-2 hour advanced support call for Monday.

Thank you for all of your help!!

YEs, you will need to sign up for a premiere support appointment for this, you can sign up here:
http://www.webassist.com/premier_request.php

Ray helped me build this code to find users with 10 runs. How could I also add criteria that the current date must be included in the runs database?

code from premium support:
SELECT sum(run_QTY) AS runs, users.user_Id, user_First, user_Last, user_Email, user_Pword, user_Size FROM users INNER JOIN runs on runs.user_Id = users.user_Id WHERE user_Received10 = 0 GROUP BY users.user_Id HAVING runs >= 10 ORDER BY user_Last ASC

Could I simply state WHERE user_Received10 = 0 AND runs.run_Date = (date("Y-m-d"))?

you would need to use DATE_FORMAT


AND DATE_FORMAT(runs.run_Date, "%y-%m-%d") = DATE_FORMAT(NOW(), "%y-%m-%d")

I"m getting Parse error: syntax error, unexpected '%' in /isrc/10runreport.php on line 105

line 105

"SELECT sum(run_QTY) AS runs, users.user_Id, user_First, user_Last, user_Email, user_Pword, user_Size FROM users INNER JOIN runs on runs.user_Id = users.user_Id WHERE user_Received10 = 0 GROUP BY users.user_Id HAVING runs >= 10 AND DATE_FORMAT(runs.run_Date, "%y-%m-%d") = DATE_FORMAT(NOW(), "%y-%m-%d") ORDER BY user_Last ASC"

try using single quotes instead of double quotes.

that fixed the error, but it isn't displaying any results.

i have a user with 14 "runs" most of which I just entered so several of them have the date in the database as 2014-02-20.

sorry i'm struggling with this, and thanks for all of the help

I'll need to troubleshoot directly, see the private message section.