How to return a specific row in PHP and MySQL?

Question

I am trying to add a mouseover hover which basically works on the first MySQL returned query. However it will not work. It does not recognise my IF ELSE statement and it just returns the ELSE command.

My data is like

gallery
----------------------
id      sku         img                     types
1       454_red     front.jpg                   F
2       454_red     back.jpg                    F
3       452_red     front.jpg                   F
4       452_red     back.jpg                    F
5       452_red     a1.jpg                      S   
6       452_red     a2.jpg                      S

My PHP

<?
$imgsql=mysql_query("SELECT * FROM `gallery` WHERE `gallery`.`sku` = '".$r['sku']."' ORDER BY `gallery`.`type` ASC");
while($rimg=mysql_fetch_array($imgsql)){ 
?>
<? if($rimg == $rimg['0']){ ?>
        <div>
            <a href="product.php?prodref=<?=$r['sku']?>"><img src="//super.cdn.com/<?=$r['sku']?>/<?=$rimg['img']?>.jpg" onmouseover="this.src='//super.cdn.com/<?=$r['sku']?>/back.jpg'" onmouseout="this.src='//super.cdn.com/<?=$r['sku']?>/<?=$rimg['img']?>.jpg'"/></a>
        </div>
    <? } else { ?>
        <div>
            <a href="product.php?prodref=<?=$r['sku']?>"><img src="//super.cdn.com/<?=$r['sku']?>/<?=$rimg['img']?>.jpg"/></a>
        </div>
    <? } ?>
<? } ?>

The $r["sku"] is called at the top of the code, this sits inside a product listing loop.

$row['0']...? Where'd this come from...? And what does "does not work" mean exactly? — deceze
– deceze ♦, Commented Oct 14, 2012 at 10:56
if($rimg == $rimg['0'])...? How does this condition make any sense? — deceze
– deceze ♦, Commented Oct 14, 2012 at 11:02
What exactly are you trying to accomplish because deceze is right that if statement makes no sense at all. — Rick Calder
– Rick Calder, Commented Oct 14, 2012 at 11:04
I want to get the first record do something, otherwise do something else — TheBlackBenzKid
– TheBlackBenzKid, Commented Oct 14, 2012 at 11:21

GBD · Accepted Answer · 2012-10-14 11:03:31Z

2

To make it simple, then take another variable say counter or flag as below

<?
$count = 1;

$imgsql=mysql_query("SELECT * FROM `gallery` WHERE `gallery`.`sku` = '".$r['sku']."' ORDER BY `gallery`.`type` ASC");


while($rimg=mysql_fetch_array($imgsql)){ 
?>
<? if($count==1){ ?>
        <div>
            <a href="product.php?prodref=<?=$r['sku']?>"><img src="//super.cdn.com/<?=$r['sku']?>/<?=$rimg['img']?>.jpg" onmouseover="this.src='//super.cdn.com/<?=$r['sku']?>/back.jpg'" onmouseout="this.src='//super.cdn.com/<?=$r['sku']?>/<?=$rimg['img']?>.jpg'"/></a>
        </div>
    <? } else { ?>
        <div>
            <a href="product.php?prodref=<?=$r['sku']?>"><img src="//super.cdn.com/<?=$r['sku']?>/<?=$rimg['img']?>.jpg"/></a>
        </div>
    <? } ?>
<? 
$count = 0;
} 

?>

answered Oct 14, 2012 at 11:03

GBD

16k2 gold badges49 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

TheBlackBenzKid Over a year ago

Ahhh I was considering a loop counter too +1 ... how would I have done the MySQL count FYI

TheBlackBenzKid Over a year ago

How do I return a specific Row ?

GBD Over a year ago

mysql_query() gives you resultset so if it have one row then you have directly use mysql_fetch_array without loop or more rows, you have to iterate it through loop

Collectives™ on Stack Overflow

How to return a specific row in PHP and MySQL?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related