[SOLVED] Error displaying records

[nitation]

Hello people,

 

I am working from my admin area. What am trying to do is to display user's information into a table. The information to be displayed is the user's total balance. Have a look at my code. This code is displaying the same information for all users. But i want it for a specific user only.

 

<?php 

			$sqluser2=mysql_query("select SUM(amount) AS Total FROM activity_table where status=1 ") ;
                if (!empty($sqluser2)){
			$numuser=mysql_num_rows($sqluser2);
		    while($row=mysql_fetch_array($sqluser2)){
		    $total=$row["Total"];
			}
			}


		  ?>

How do i go about it.

Thanks in advance

[wildteen88]

append the username to the query,

 

select SUM(amount) AS Total FROM activity_table where status=1 AND username='$username'

[nitation]

Thanks.

I actually did that and it worked.

 

regards