Jump to content


Photo

Members Descending List


  • Please log in to reply
1 reply to this topic

#1 omesa

omesa
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 10 October 2006 - 08:49 AM

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.

#2 thedarkwinter

thedarkwinter
  • Members
  • PipPipPip
  • Advanced Member
  • 191 posts
  • LocationLondon

Posted 10 October 2006 - 08:58 AM

Hi

you can try changing the select query from

$query = "select names, mpoints from members";

to

$query = "select names, mpoints from members order by mpoints";

and then echo each mysql row out 1 by 1 one...

cheers,
tdw
Remember - if you don't figure it out yourself, you'll probably forget it tomorrow :)




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users