current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

geeks please help,

I have a problem with the usage of array keys with the while loop.

I'm trying to display the twitter bootstrap slider images by looping from the database with this code:

<div id="slider">
         <!--Code for make home images slide show-->
                <div id="myCarousel" class="carousel slide">

              <!-- here comes the engine to run the sliders -->
              <?php  

              $query = 'SELECT * FROM banners WHERE status = 1 ORDER BY id ASC';

             ?>

                     <div class="carousel-inner">
                      <?php
                      if ($r = mysql_query($query , $conn)) {  //run the query
                      $row = mysql_fetch_array($r);
                      reset($row);

               while (list($key, $value) = each($row)) {
                   if ($key == 0) {   ?>
                        <div class="item active">
                    <img src="images/homeimages/<?php echo $value['image'];?>" alt="<?php echo $value['title'];?>">
                    <!-- <img src="images/homeimages/one.jpg" alt=""> -->
                    <div class="carousel-caption">
                      <!-- <h4>First Thumbnail label</h4> -->
                      <p><i><?php echo $value['title'];?></i></p>
                    </div>
                  </div>
                  <?php }else{ ?>

                       <div class="item">
                    <img src="images/homeimages/<?php echo $value['image'];?>" alt="<?php echo $value['title'];?>">
                    <!-- <img src="images/homeimages/one.jpg" alt=""> -->
                    <div class="carousel-caption">
                      <!-- <h4>First Thumbnail label</h4> -->
                      <p><i><?php echo $value['title'];?></i></p>
                    </div>
                  </div>

                  <?php }

                 }
               }else {
                print '<p style="color: red;">Could not retrieve the slider:<br />' . mysql_error($dbc) . '.</p>';
              } ?>


                </div>  


              <!--   <a class="left carousel-control" href="#myCarousel" data-slide="prev">&lsaquo;</a>
                <a class="right carousel-control" href="#myCarousel" data-slide="next">&rsaquo;</a> -->
                <ol class="carousel-indicators">
                  <li data-target="#myCarousel" data-slide-to="0" class="active"></li>
                  <li data-target="#myCarousel" data-slide-to="1"></li>
                  <li data-target="#myCarousel" data-slide-to="2"></li>
                </ol>
              </div>


    </div><!-- endof slider  -->`

. as`it's well known the first slider image of twitter bootstrap must have the class of active to make sure it loads faster. I need to pick the first slider image from an array and add the class of active into it while the rest of the slider images remains the same without an active class.

can someone please tell me where i'm messing up with my codes?

share|improve this question
    
why can't you use this code to iterate through the resultset: while ($row = mysql_fetch_array){ // do something here } you can still access all the keys/values that you need. –  Maximus2012 Jul 22 '13 at 23:58
    
May you please write down how i'm going to use while ($row = mysql_fetch_array){ ? That's something i don't know @Maximus2012 –  dani_chikaka Jul 23 '13 at 0:04
    
see my answer. Understand that mysql_ functions are not secure and deprecated but this should still serve as a solution for you. Later you can always change your code to make use of mysqli/PDO. –  Maximus2012 Jul 23 '13 at 0:08

1 Answer 1

up vote 1 down vote

Try this:

<div class="carousel-inner">
<?php
if ($r = mysql_query($query , $conn)) {
    $count = 0;
    while ($row = mysql_fetch_array($r){
        if ($count == 0){?>
            <div class="item active">
        <?php}
        else { ?>
            <div class="item">
        <?php}?>
        <img src="images/homeimages/<?php echo $row['image'];?>" alt="<?php echo $row['title'];?>">
         <div class="carousel-caption">
             <p><i><?php echo $row['title'];?></i></p>
         </div>
         </div>    
        <?php
        }
        $count ++;
    }
}
else {
    print '<p style="color: red;">Could not retrieve the slider:<br />' . mysql_error($dbc) . '.</p>';
}
share|improve this answer
    
thanks, it worked @Maximus2012 –  dani_chikaka Jul 23 '13 at 0:17
    
sure no problem. –  Maximus2012 Jul 23 '13 at 0:18

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.