Jump to content

Members Descending List


omesa

Recommended Posts

Hello guys
Its 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>
<?php
include "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: points
omesa: 2
clement: 1
ongera: 0
on 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 alot
Any help will be appreciated.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.