[SOLVED] Don't understand what I'm doing wrong on this :/

[adamjones]

Hi.

I'm making a simple badge notification system, so when a user is given a badge, they are alerted.

 

This is my code;

 

<?php
$host="localhost";
$username="";
$password=""; 
$db_name="";
$tbl_name="badgealerts";

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name WHERE username='".$_SESSION['user']."'";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);

echo "".$rows['alert']."";

$sql2="DELETE FROM $tbl_name WHERE username='".$_SESSION['user']."'";
$result2 = @mysql_query($sql2);
?>

 

And this is how my database looks;

 

However, it is only echoing one, no matter how many entries I have? :/

 

Cheers.

 

[KevinM1]

You need to loop through your results when you use a SELECT query:

 

while ($row = mysql_fetch_assoc($result))
{
   // do stuff
}

 

Without looping, you only get the first row.

[adamjones]

You need to loop through your results when you use a SELECT query:

 

while ($row = mysql_fetch_assoc($result))
{
   // do stuff
}

 

Without looping, you only get the first row.

 

Cheers!