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!
Recent content by rogwilco
-
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.
Yes thats seems to be getting close to what I want. I will try out coding a mockup this mrnong and tell you later how I get on. Thanks a lot. -
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!??
Thanks Tony I'll have a proper read through that link. On my first read through I got lost. I'll get back to you if I need anything clarifying. Roger. -
A ranking leaderboard!??
Yes I understand the LIMIT option and thanks for the quick reply but what I was getting at was if a user had logged into the site and wanted to see their 'ranking' on the board, without having to scroll down a 1000+ other people. My point is, how will SQL ever know the position of someone so it... -
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!
Thanks ever so much DRJ478! It now works and recognizes that the user is already on that leaderboard. I know it took some time to actually get the full scenario out of me but thanks for being patient! FULLY APPRIECIATED! -
No errors but still can't pull results from table!
But HOW do I add that to the submit button? I wouldn't of thought this would be the case as we are still in the same php page, i.e. my form action is $self which means data processing is in this page. If though you are right, how do I add the SID on this line below? $form .="<form... -
No errors but still can't pull results from table!
Ok this is from the page prior which sends the SID: <form name="form2" method="post" action="add_leaderboards.php?<?php echo SID;?>"> <input name="Input" type="submit" value="Get onto a Leaderboard"></form> The script before that creates the session data and passes it to the above page as... -
No errors but still can't pull results from table!
Just checked and session.use_trans_sid is off on the server. -
No errors but still can't pull results from table!
print_r($_SESSION) outputs Array ( [id] => 7* ). *or whatever the id is of the person who has just logged on. Surely that proves that id has been passed across. It even passes across the users name i.e.( [name] => someone). All my scripts have cookies set to off. as I'm passing (trying) the... -
No errors but still can't pull results from table!
On a previous page there is a login, thus $_SESSION['name'] and $_SESSION['id' are set. Also remember that the print_r(SESSION) and my echo("$id") before the form is put on screen all prove that the id has been passed across from the previous login screen. The point where it either loses it or... -
No errors but still can't pull results from table!
hmmm interesting... but still confused. I added two print($_SESSION). One before the form is submitted and that gave a result of :Array ( [first_name] => Jane [id] => 2 ) Obviously that is is what we want to see. However the other one gave a result of Array(). Below is my entire code for... -
No errors but still can't pull results from table!
No there is no mention of $id in mysql_connect.php.
