How would i do this in PHP?

[LMS16]

Hey

I have a small question...

In PHP how would I add an extra value to the outputted while functions?


example:

<?php $slide = mysql_query("SELECT * FROM `slider` ORDER BY `id` DESC LIMIT 10");
while($val = mysql_fetch_object($slide)){
    echo "<a href=\"" . $val->url . "\"><img src=\"" . $val->img_link . "\" alt=\"" . $val->alt . "\" width=\"580\" height=\"282\" rel=\"<h3>" . $val->rel_title . "</h3>" . $val->rel_desc . "\"/></a>";
} ?>

I have this already, but for my jquery script to work correctly I need to define the first image.. so I need this to be shown first, then after show thr above. So I want it to look like this...

<?php $slide = mysql_query("SELECT * FROM `slider` ORDER BY `id` DESC LIMIT 10");
while($val = mysql_fetch_object($slide)){
    echo "<a href=\"" . $val->url . "\"><img src=\"" . $val->img_link . "\" alt=\"" . $val->alt . "\" width=\"580\" height=\"282\" rel=\"<h3>" . $val->rel_title . "</h3>" . $val->rel_desc . "\"/></a>";
} ?>

<?php $slide = mysql_query("SELECT * FROM `slider` ORDER BY `id` DESC LIMIT 10");
while($val = mysql_fetch_object($slide)){
    echo "<a href=\"" . $val->url . "\" class=\"show\"><img src=\"" . $val->img_link . "\" alt=\"" . $val->alt . "\" width=\"580\" height=\"282\" rel=\"<h3>" . $val->rel_title . "</h3>" . $val->rel_desc . "\"/></a>";
} ?>

I hope you under stand...

Thanks + REP

Lew.

[MattFr]

A real hacky way to do this would be defining a var as 0, then adding 1 per iteration. If the var is 0, it's the first iteration of the loop, so do the first thing.

[Moh]

I don't quite get what you're wanting o.O

[ThisNameWillDo!]

I really don't understand what you're trying to do here, can you explain a little more please?

[LMS16]

Right, basically, Im outputting values from the database. And I want the first outputted values to have something added to it. so I want it to do this...

<?php $slide = mysql_query("SELECT * FROM `slider` ORDER BY `id` DESC LIMIT 10"); 
while($val = mysql_fetch_object($slide)){ 
    echo "<a href=\"" . $val->url . "\" class=\"show\"><img src=\"" . $val->img_link . "\" alt=\"" . $val->alt . "\" width=\"580\" height=\"282\" rel=\"<h3>" . $val->rel_title . "</h3>" . $val->rel_desc . "\"/></a>"; 
} ?>
<?php $slide = mysql_query("SELECT * FROM `slider` ORDER BY `id` DESC LIMIT 10"); 
while($val = mysql_fetch_object($slide)){ 
    echo "<a href=\"" . $val->url . "\"><img src=\"" . $val->img_link . "\" alt=\"" . $val->alt . "\" width=\"580\" height=\"282\" rel=\"<h3>" . $val->rel_title . "</h3>" . $val->rel_desc . "\"/></a>"; 
} ?>

Notice, the top one had <a href="" class="show"></a>

Thanks

Lew.

[MattFr]

The way I said would work fine..

[LMS16]

The way I said would work fine..

My head's gone blank, any examples pls +REP

Lew.

[Moh]

<?php
    $i = 0;
    $slide = mysql_query( "SELECT * FROM `slider` ORDER BY `id` DESC LIMIT 20" ); 
    while( $val = mysql_fetch_object( $slide ) ){ 
        
        $class = ( $i <= 10 ) ? "class=\"show\"" : "";
        $i++; 
        
        echo "<a href=\"" . $val->url . "\" " . $class . "><img src=\"" . $val->img_link . "\" alt=\"" . $val->alt . "\" width=\"580\" height=\"282\" rel=\"<h3>" . $val->rel_title . "</h3>" . $val->rel_desc . "\"/></a>";
    }
?>

Something like that?

[LMS16]

<?php
    $i = 0;
    $slide = mysql_query( "SELECT * FROM `slider` ORDER BY `id` DESC LIMIT 20" ); 
    while( $val = mysql_fetch_object( $slide ) ){ 
        
        $class = ( $i <= 10 ) ? "class=\"show\"" : "";
        $i++; 
        
        echo "<a href=\"" . $val->url . "\" " . $class . "><img src=\"" . $val->img_link . "\" alt=\"" . $val->alt . "\" width=\"580\" height=\"282\" rel=\"<h3>" . $val->rel_title . "</h3>" . $val->rel_desc . "\"/></a>";
    }
?>

Something like that?

And that will only add class="show" to the very first output?

Lew.

[Moh]

And that will only add class="show" to the very first output?

Lew.

To the first 10, simply edit the 10 to 1 if you only want the first to show.

Also, if you want the others to have class="hide"

$class = ( $i <= 10 ) ? "class=\"show\"" : "class=\"hide\"";