MYSQL selecting only ONE row...i need it to select every row that applys... help

[strujillo]

So my code is only printing out one row. Not all the rows that apply. Do you see anything wrong. I cant figure out. Is there a certain code to use???

 

 

This is the code that prints the results. It only prints the first restult it finds in mysql

<?php
include("dbconnect.php");
$username=$_SESSION["myusername"];
$sql ="SELECT * FROM `abhs`.`messages` WHERE `to`='$username' LIMIT 0 , 30"; 

$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
?>

<table width="500" border="1" cellpadding="5">
  <tr>
    <td bgcolor="#00FFFF">To:   </td>
    <td bgcolor="#CCFFFF"><?php echo $rows['to']; ?></td>
  </tr>
  <tr>
    <td bgcolor="#00FF00">From:   </td>
    <td bgcolor="#99CCFF"><?php echo $rows['from']; ?></td>
  </tr>
  <tr>
    <td bgcolor="#00FFFF">Subject:   </td>
    <td bgcolor="#CCFFFF"><?php echo $rows['subject'];?></td>
  </tr>
  <tr>
    <td bgcolor="#00FF00">Message:   </td>
    <td bgcolor="#99CCFF"><?php echo $rows['message'];?></td>
  </tr>
</table>

[cooldude832]

of course it will you said $row = mysql_fetch_assoc($result)

 

that means it will get the Next row in the resource.

 

You need to use a structure like

 

while($row = mysql_fetch_assoc($result)){

output

}

[strujillo]

OOOOHHHHH....lol thanks im so dumb haha