RaJiska

Thanks a lot Barand, Once more you saved me, much instructive code. Thanks again.

I probably didn't make myself clear enough. What I would like is get the 'negative' of this: SELECT people.* FROM people LEFT JOIN attendance ON people.idpeople = attendance.idpeople WHERE people.idpeople AND attendance.gamedate = '2013-11-24'; By doing this, I get all those who attended the 2013-11-24. What I wish to get is the substration, so if I've: Roger, Pierre, Stephan, and Jaques in total and I have Roger Pierre, Stephan who appears when I do the previous comand, I would like to get a comand that would only show me Jaques. Thanks anyway for your help.

No, no, the problem is not a syntax issue, I don't have any error.

Ok, perfect, yes, I saw for the sample, but I meant how is it taken from the database to the page in order to see what value there is in attended ? Also, something else, now, I would like to get the people that didn't come. For that, I did it: SELECT people.* FROM people LEFT JOIN attendance ON people.idpeople = attendance.idpeople WHERE people.idpeople IS NULL AND attendance.gamedate = '2013-11-24'; , the problem is I don't get anything back. Thanks again - much instructive.

Ok, perfect, thanks. Yes, I saw that this morning. After long hours at looking at your code, I can say that I don't understand how is displayed the color. I would like to change the color of the person in function of its rank and add new possibilities (not only the not recorded, attended and not attended). Then, I found this: foreach ($persdata as $val) { switch($val) { case 1: $cls = "class='att'"; break; case 0: $cls = "class='not'"; break; default: $cls = ''; But I don't see where are the colors defined here. Also, where is the value from the database taken ? The one that defines if the player did or not attended. Anyway, thanks again for your help.

Thank you so much Barand. I'll have to learn from your code since there are few things not clear yet. For exemple, it keeps logs for up to 84 days ago, right ? Also, why the 23/11 couldn't be seen ? I mean today is a saturday and it's the 23/11 . Anyway, thanks A LOT for your help, much helpful.

Thanks Denno, effectively, I would also need the one that did not join. So, since you're asking Barand, yes, I'm going to write it down, the meeting was the easier example I found. Basically, it would be for a game, there are 100 members in a group that must attend to this meeting (getting if attended is simulated by a link triggered by the game). (The game link triggered looks like this: http://host.com/?password=pass&youInfo=1&whatyouwant=2&... ). I want them to join the server each Saturday and Sunday, it has been done with a 'if ($current_day == "Sat" || $current_day == "Sun") { }', but now, I need to know what to do in this if. What has to be displayed like this: http://img4.hostingpics.net/pics/115542Sanstitre.png (Here is a google doc) and the color would define if the player has joined or not. In order to see if the player hasn't joined, we'll get a list of all players name (a list registred in another table) and if they did not joined, then we add them as not attended. Thanks again for your help .

Thanks for your help, then, what I should do is something like this, right: Date - Name - Attended 23/11 - Roger - 1 23/11 - Charles - 1 23/11 - Pierre - 0 24/11 - Steph - 1 24/11 - Rath - 0 etc... Is that like that ? The problem is I don't really know how to code the table in PHP by doing like that, I don't see how I could create the PHP table dinamically.

Hello, Here is what I would like to do, every weeks, I would like to do a check of who attended a meeting, for that, I would like to do a table in PHP from a MySQL database, the thing is this database would be dynamic, every weeks a new column would create with the week number, the problem, is: how can I show this on a web page dinamically ? I mean, without having to add each time a new line for a new column. Thanks for your help.

Thanks a lot, it worked, how can it be possible ? I earlier tested this on another page, and it worked perfectly.

Yep, thanks, it worked with $_POST. Alos, I might have to ask another question, it's here: $test1 = 1; $test2 = 1; if ($ip == $test1 || $test2) { ?> <br><input type="submit" value="Click test" /> <?php } echo "IP: $ip"; ?> The problem is with: if ($ip == $test1 || $test2) (that is not normal since my IP is not '1' or '1'), I can see the button, but with: if ($ip == $test1) I can (that should be normal since my IP is not 1). ThankS.

Hello, I have a drop down menu, and I wish to know how to get the value selected in the drop down (made with HTML & CSS) into a PHP variable. Here is how it looks like: <html> <body> <form name="myform" action="" method=""> <div align="center"> <select name="mydropdown"> <option value="1h">1 Hour</option> <option value="3h">3 Hours</option> <option value="12h">12 Hours</option> <option value="1d">1 Day</option> <option value="3d">3 Days</option> <option value="1w">1 Week</option> <option value="2w">2 Weeks</option> <option value="3w">3 Weeks</option> <option value="1m">1 Month</option> </select> </div> </form> </body> </html> Then it should be get when this PHP button is pressed: echo('<input type="submit" name="test" value="Hello My Name is Bob"/>'); Thanks.