John Davidson

Message:

This code is used to show a list of stuff...

$result= mysql_query("

SELECT DISTINCT 

m.username, m.asdf_txt, m.week_txt,  

   FROM table m  

      WHERE m.username='$user' ORDER BY m.week_txt ASC") 

or die(mysql_error($link));



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

    echo "<br>" . $row['week_txt'] . ""; 

    echo "<br>" . $row['asdf_txt'] . ""; 

} 

echo "<br>"; echo "";

It ends up showing

Week 1

asdfasdf1

Week 1

asdfasdf2

Week 2

asdfasdf3

Week 2

asdfasdf4

But I would like to have instead...

Week 1

asdfasdf1

asdfasdf2

Week 2

asdfasdf3

asdfasdf4

Any suggestions would be helpful. I'm looking for a solution that will be written into the code (a php/mysql file) itself. Bear in mind I've solved this problem with the following code in a more roundabout way previously...

sed 's/<br>Week 1\b//2g; s/<br>Week 2//2g;'

---

My Answer:
"SELECT * FROM stuff");

if(mysql_num_rows($result) > 0){
while($row = mysql_fetch_assoc($result)){
echo $row['name'] . "
";
}
}else{
echo "No stuff found";
}"