Jump to content

Archived

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

blev

**solved** limiting data that is displayed from an array

Recommended Posts

I have this code and only wish display the first three records from the array. I've tried using the LIMIT 3 in the sql statement but this does not work. Can anyone help me please???? thanks

[code]
foreach ($club_score_array as $key => $val)
            {        
                    $query3 = mysqli_query($conn, "SELECT * FROM event, venue WHERE event.venue = venue.venueName AND event.date <= '$mysqlWeek' AND event.eventID = '$key' LIMIT 3") or die('Error, query failed');
                      while ($row = mysqli_fetch_array($query3))
                        {
                            $i++;
                            
                            $details = $row['details'];
                            $details_short = substr($details, 0,100);
                            echo "<table width='800'>
                            <tr><td><span class='h1'>$i</span></td><td>&nbsp;</td></tr>
                               <tr>
                                 <td width='700'><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>, ".$row['location']."</span></td>
                                </tr>
                               <tr>
                                 <td><span class='h3'>".$row['time']." -> ".$row['admission']."</span></td>
                                </tr>
                               <tr>
                                       
                                    
                                 <td>".$row['lineup']." -> $details_short...</td>
                                </tr>
                             </table><br />";
                        }
                        mysqli_free_result($query3);
            } [/code]

Share this post


Link to post
Share on other sites
Something like this?

[code]$keys = array_keys(array_slice($club_score_array, 3, 0));
$keylist = join ("','", $keys);

$query3 = mysqli_query($conn, "SELECT * FROM event, venue
          WHERE event.venue = venue.venueName
          AND event.date <= '$mysqlWeek'
          AND event.eventID IN ('$keylist')")
           or die('Error, query failed');

          while ($row = mysqli_fetch_array($query3))
            {
                 # process results
            }
[/code]

Share this post


Link to post
Share on other sites
Thanks alot. The code didn't directly work but used the functions to gain the required result

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.