[RESOLVED] Help with PHP syntax

turtleton09

Hope someone can help out again with a bit of syntax.

I have a bit of code that acts a little loop displaying records from a table :

 
 <?php  

     $groups = array();  

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

    $groups[$row['Alphabet']][] = $row;  

}  

foreach ($groups as $alphabet_letter => $rows) {  

    echo "<tr><td><br><h2>$alphabet_letter</h2><br></td></tr>";  

    foreach ($rows as $row) {  

        echo "<tr><td><a href=\"http://www.goodsafariguide.com/hit_counter2.php?LodgeID=" . $row['LodgeID'] . " \" >" . $row['Lodge'] . " </a></td></tr>"; 
    }  

}  

?>

I'd like to add in another field next to the Lodge field, complicated by the fact that its to display an image. (The field is winner10, and just contains the string winner10.gif which references the gif.)

So that would normally look like :

<img src="../images/<?php echo $row['winner10']; ?>"  alt="Image Name" border="0"/>

But I'm not sure how to add that in to the existing code, so if anyone could for whom its second nature could help out, I'd be very grateful.

Thanks.

dagon

how about giving it a try, following what you already have above you could probably work it out, post what you tried if you cant get it.

turtleton09

The closest I'd gotten that looks almost right is this :

  echo "<tr><td><a href=\"http://www.goodsafariguide.com/hit_counter2.php?LodgeID=" . $row['LodgeID'] . " \" >" . $row['Lodge'] . " </a><img src=\"../images/lodgeawardicons/" . $row['winner10'] . "  alt="Image Name" border="0"/></td></tr>";

dagon

you just need to escape the quotes used in the alt and border, or switch to single quotes, which are valid for the html also.

turtleton09

Thank you - got there in the end. 🙂

<?php 
     $groups = array(); 
while ($row = mysql_fetch_assoc($rs2011nominees)) { 
    $groups[$row['Alphabet']][] = $row; 
} 
foreach ($groups as $alphabet_letter => $rows) { 
    echo "<tr><td><br><h2>$alphabet_letter</h2><br></td></tr>"; 
    foreach ($rows as $row) { 
		echo "<tr><td><a href=\"http://www.goodsafariguide.com/hit_counter2.php?LodgeID=" . $row['LodgeID'] . " \" >" . $row['Lodge'] . " </a>
		<img src=\"../images/lodgeawardicons/". $row['winner10']. "\"  alt=\"Image Name\" border=\"0\"/>
		<img src=\"../images/lodgeawardicons/". $row['runnerup10']. "\"  alt=\"Image Name\" border=\"0\"/>
		<img src=\"../images/lodgeawardicons/". $row['finalist10']. "\"  alt=\"Image Name\" border=\"0\"/>
		</td></tr>";
    } 
} 
?>

Although now I've noticed that the results within each group are not ordered alphabetically.

DaveRandom

duklaprague;10973144 wrote:
Although now I've noticed that the results within each group are not ordered alphabetically.

If you use an ORDER BY clause in your MySQL query, the DB will do the work for you. Then you won't need 3 loop structures, you can do the whole thing in a single while loop.

turtleton09

Thanks - I'm used to just having my queries just order by one field, so I've just changed my query to :

SELECT * FROM lodges ORDER BY Alphabet, Lodge Asc

and that seems to have fixed that, so that was painless enough.