Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Trouble with a nested While loop in an SQL statement...
Hope the title isn't too off putting! Anyway I am having trouble getting the following to display what I want correctly. Here's the code then I'll explain; $sql = "SELECT board FROM leaderboard"; $result = mysql_query($sql); while($board = mysql_fetch_array($result, MYSQL_NUM))... -
True ladder system in PHP...confused.
I am making a leaderboard site for our local club and have just about got everything either designed opr working apart from the main part of the site which is the ladder. The ladder system is the only option for the site. I have spent most of this week with pen and paper but for the life of me... -
Building a query via a form
I'm struggling building a SQL query from the output of a form, i.e. the user inputs into a form which in turn decides the query. I have never done this before and was just wondering if anyone had any links tutorials of something like this!? I have searched but haven't found anything too... -
A ranking leaderboard!??
I am trying to design and implement an online leaderboard in MySQL and PHP. Maybe it is because of lack experience in this field but I am really confused on the basics on how this could be achieved. Correct me if I'm wrong but data is not stored in any order as such in a SQL db. It is the... -
No errors but still can't pull results from table!
I have a MySQL table called tennis where one of the fields is a primary key called "id". I also have a form which allows the user to add thereself to that table IF they are not already on that table, i.e. if there user id isn't already present. I am having trouble getting the check to work. I... -
Trouble with Headers conflicting with Sessions
Below is my first attempt at sessions. The code below is for a user login. Basically a check is made for the username and password and then a session is created at which the browser is redirected to my index page. However I keep getting 3 errors as below; Warning: session_start(): Cannot send... -
Passing primary key from one table accross to another table?
Hello people. I am struggling in getting the user ID (PK) from my user table into my leaderboard_1 table as a FK. I am confused on how to pass this information accross. Below is my code. At the moment a new leaderboard_1 record is created but it gives each record a value of 0 for id!? ?>...
