PHP: show two times

Question

I have a table called users_msgs with these columns:

id | uID | nData

and it has these rows:

1 | 2 | 20
2 | 2 | 20
3 | 2 | 20
4 | 2 | 20
5 | 2 | 25
6 | 2 | 25
7 | 2 | 25
8 | 2 | 25

uID is userid. So user 2 has written in a nDataid 20 four times, the same he did in nDataid 25.

I want to make so you only get one popup per same nData. So by these rows i would get 2 popups.

Right now i get only 1 popup for everything, and not per same nData. But that may be the way I SELECT:

<?php
$string = mysql_query("SELECT * FROM users_msgs 
            WHERE uID = '$USER' 
                AND type = 'wallComment'
            ")or die(mysql_error());
$get = mysql_fetch_array($string);
$sWall = mysql_num_rows($string);
    if($sWall>1){
?>
<script language="javascript" type="text/javascript">
$(document).ready(function(){
        jGrowlTheme('wallPop', 'mono', 'Wall', 'You have <?php echo $sWall; ?> answers in id <?php echo $get["nData"]; ?>', 'images/wall.png', 10000);
        });
    </script>
<?php
}elseif($sWall==1){ 
?>
<script language="javascript" type="text/javascript">
$(document).ready(function(){
        jGrowlTheme('wallPop', 'mono', 'Wall', 'You have one new answer in id <?php echo $c; ?>', 'images/wall.png', 10000);
        });
    </script>
<?php } ?>

How can I solve this, so there comes two popups with "You have xx answers in id nData" when you have the rows as above?

Answer 1

select distinct uuid, ndata from users_msgs where uID = '$USER' and type = 'wallComment'

would give you two rows returned (one for each ndata for the user = $user).

I don't follow what exactly you're trying to do, so lets just simplify it a bit and maybe you will get it:

<?php
$string = mysql_query("SELECT distinct uuid, ndata FROM users_msgs 
            WHERE uID = '$USER' 
                AND type = 'wallComment'
            ")or die(mysql_error());
?>
<script language="javascript" type="text/javascript">
    $(document).ready(function(){  
        <?
         while ($sWall = mysql_fetch_assoc($string)) {
              echo 'alert("You have a message for ' . $sWall['ndata'] . '!")';
         }
        ?>        
    });
</script>

Would write an alert statement to the ready() function for each distinct ndata id for that user. The message would simply say "You have a message for NDATA#!" (replace ndata# with the value from the table)

Like I said, I'm a little confused as to what exactly you are doing, but hopefully this helps you out a bit.