Jump to content

Archived

This topic is now archived and is closed to further replies.

blev

issues regarding while loop perhaps

Recommended Posts

When i apply LIMIT in this piece of code it does not work. can anyone tell me why????

also, when i try to replicate a similar loop below it but slightly different it does not display any results. Can anyone tell me why???

thanks!

[code]
while(list($key, $val) = each($club_score_array))
            {
                    $query3 = mysqli_query($conn, "SELECT * FROM event, venue WHERE event.venue = venue.venueName AND event.date <= '$mysqlTwoDays' AND event.eventID = '$key' [b]LIMIT 1[/b]") or die('Error, query 3 failed');
                      
                    while ($row = mysqli_fetch_array($query3))
                        {
                            echo "<table width='700'>
                               <tr>
                                 <td width='600'><span class='h2'><a class=h2link href='eventDisplay.php?eventID=".$row['eventID']."'>".$row['eventName']."</a> @ <a class=h2link href='clubnightDisplay.php?clubname=".$row['club']."'>".$row['club']."</a></span></td>
                                 <td width='100' rowspan='4' align='right'><img src='images/flyers/".$row['flyerName']."' width='50' /></td>
                               </tr>
                               <tr>        
                                 <td><span class='h2'><a class=h2link href='venueDisplay.php?venueName=".$row['venue']."'>".$row['venue']."</a></span></td>
                                </tr>
                                
                               <tr>
                                 <td><span class='h3'>".$row['time']." -> ".$row['admission']."</span></td>
                                </tr>
                               <tr>
                                 <td>".$row['lineup']." -> ".$row['details']."</td>
                                </tr>
                             </table><br />";
                        }
                        mysqli_free_result($query3);
            }
        } [/code]

Share this post


Link to post
Share on other sites
this is starting to hurt my head now.

why doesn't the statement like the "LIMIT". is it because it is in another while loop??

i'm stuck. any help would be gratefully appriciated. thanks

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.