abemaca

sorry if i posted in wrong place , hopefully an admin will move it. i list in time order and it still does all friend events at same time , IE all user1 1st , then all user2 , etc

hi , first ide like to say hello as this is my first proper post (i think lol) ive been reading the site for years and it has been most helpful so now its time for me to ask the question , so here goes ...... i run a network site and it users friends like most network sites do . when i login it gets my friends and there events , these are 2 different tables. it shows the result in the order of friends , IE USER1 did this , USER1 did that , USER1 did this also , USER2 did this , etc etc i need to to read in time posted but as its selecting friends 1st followed by there events it lists like above , how can i get it to read event times so it reads like this .... USER1 did this , USER2 did this , USER1 did that , USER2 did that , etc any tips welcome and thanks for reading.

thanks alot my fellow freaks ill try them out now. ill reply my results asap , thanks again

hmmmm let me explain step by step ...... CURRENTLY THE CODE DOES ...... a user chooses to join a game that is running , its a team game with 3 teams. when he join he is auto assigned an ID# for that game...... he click join it call him ID1 and he i placed on the 1team....... Next players joins the same game so is ID2 .... placed into 2team .... ID3 into 3team .... then it starts from 1team again. ....... ID4 goes into 1team ... etc etc

if my user log's into a game it will check the ID and place them into 1 of 3 different groups. at the moment im using a very basic code to determine which group they are placed. like so .... if (($id == '1') || ($id == '4') || ($id == '7') || ($id == '10')) { mysql_query("UPDATE $tab[user] SET group=1 WHERE id='$id';");} if (($id == '2') || ($id == '5') || ($id == '8') || ($id == '11')) { mysql_query("UPDATE $tab[user] SET group=2 WHERE id='$id';");} if (($id == '3') || ($id == '6') || ($id == '9') || ($id == '12')) { mysql_query("UPDATE $tab[user] SET group=2 WHERE id='$id';");} this way it places them in groups in order so all groups stay the same size almost. My issue is im now having hundreds join so is there an easier way to place them into 3 groups doing the same as the code above or do i just need to keep adding , thanks

ok i've read about sanitizing and im closer to my goal (secure mysql) but it didnt directly help me solve the issue i posted about. The above is regarding inputs and data queries were as im after something alot more simpler , as this can be used before you even enter data , IE: http://mysiteurl.com is where they go ... if they add a ' like so .... http://mysiteurl.com/' then it reads the ' character. how can i avoid this ???

hi all , sorry if this is posted in the wrong section , im a phpfreak noob running a site i like to read into the hacking side to things to keep myself and my site on its toes so to speak. i notice that to find if a site has mysql vulnerability you would simply place a ' after the url and look for error. My question is that if i add the ' to my site it shows as being vulnerable . how could i stop this giving an error back ???

hi all , been looking for a place to find many a question i need answers for , hope this is it self taught HTML, php , MySQL over last 6years {basicly im a noob}