Help for Noob!

Mada_FD_

hi, i am in the process of upgrading my wacraft 3 clan's webpage with a clan ladder, now, i have programming experience in both thinking out processes/algorithms/etc. but i lack in php/sql

now with this clan ladder, i plan on having it based on a system of points which are determined, now, the problem

i am attempting to think out how i am to make this work with a sql database, could i please have a few views from all u pplz 😛

this is what i was planning:
- members table (probable sorted by a reference number) including email, num of points, etc., a point value table (not sure if needed), etc.
- a ladder viewing page (ladder is sorted by clan points, more points higher rank on ladder)
- an administration section which allows an admin to add/remove points at any time, maybe with a history page

now, that is just what i had in mind, sooo, could any of you please post your ideas/code(if u can) so i can get a feel for php/sql, even if its just how to insert/remove/update values in an sql table via php

thanks,
Mada

Boaz_Amit

The best thing is to read about it in places like
DevShed . Or the extremely friendly PHP documentation .

Just to give you the feeling though:

The "users_details" MySQL table would probably have these fields: "unique_user_id", "email", "age" etc'.

The "users_scores" MySQL table would probably have two fields: "unique_user_id" and "user_score" (names irrelevant here, could be anything).

The "unique_user_id" serves as the link between the two tables. So whenever you fetch the score of a user you can also fetch its details, and vice versa.

For instance to create an HTML page of the scores sorted in a descending order, the PHP/SQL query may look something like this:

[code=php]$usersScores = mysql_query("SELECT * FROM `users_scores` ORDER BY `user_score` DESC");[/code]

while ($userScore = mysql_fetch_assoc($usersScores)) {
     echo $userScore['unique_user_id'] .' scored: ' . $userScore['user_score'] . '<p>';
}

The first block fetches the data from the "users_scores" table sorted by the scores in an descending order. The second cycles through the results and outputs their data to the page. In that cycle you could also fetch the user's email by adding something like this inside the "while" loop:

$userDetails = mysql_fetch_assoc(mysql_query("SELECT `email` FROM `users_details` WHERE `unique_user_id` = '$userScore[unique_user_id]'"));

Note the use of 'unique_user_id' from the previous MySQL query, in this query.

About an admin section, it would probably include a code that upon receiving a 'unique-user-id' would output some kind of an HTML form with fields corresponding to the user's scores and details. Two queries may be used, one to insert new users and a second to update a user .In SQL:

"INSERT INTO users_details (unique_user_Id, email, age) VALUES ('uniqueUserId', '$email', '$age')"
"UPDATE users_scores SET user_score = '$newScore' where unique_user_id = '$uniqueUserId'"

The first query inserts the variables from the form into the table as a new user. The second updates a specific user's score.

There are many ways for this to be done, some most likely better than what I described above. Do some reading. Hope this helped.