omesa Posted October 10, 2006 Share Posted October 10, 2006 Hello guysIts afternoon this side of Africa.I have a school project where a user register and they earns points. When the points are 10, the first user is either deleted from the database and/or retained in the system, either way the second person gets their points... and the list goes on.here's what i've done.<html><head><title>insert</title></head><body><?phpinclude "config.php";global $Names,$Counter;$selected_id = addslashes('$id');$new_name = addslashes('$Names');$new_counter = addslashes('$Counter');//inserting into the memberchild and the members tables repectively.$mcquery = "insert into memberchild(Counter) values ('$Counter')";$user_id = mysql_insert_id($conn);$mquery = "insert into members(id,Names) values('$user_id', '$Names')";$m_query = mysql_query($mquery);$mc_query = mysql_query($mcquery);//update points at the members table$upoints = mysql_query("UPDATE members SET MPoints = MPoints+1 where id =".$m_query);//record number$query = "select names, mpoints from members";$result = mysql_query($query);$recordcount = mysql_num_rows($result);echo "There are $recordcount record(s)";?></body></html>the problem lies in the members table where only the first row is incremented, I would like to see something like ,name: pointsomesa: 2clement: 1ongera: 0on the same table, after the record(s) have been inserted.I use the Names field only for inserting the record(s).For further clarification, I can provide more information.Thanks alotAny help will be appreciated. Quote Link to comment Share on other sites More sharing options...
thedarkwinter Posted October 10, 2006 Share Posted October 10, 2006 Hiyou can try changing the select query from[code]$query = "select names, mpoints from members";[/code]to[code]$query = "select names, mpoints from members order by mpoints";[/code]and then echo each mysql row out 1 by 1 one...cheers,tdw Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.