if-code inside while??

Stalis

Hi!

I am trying to make list of my DVDs with PHP and MySQL.
Everything has gone fine until now :-(
I'm a real newbie so be good to me :-)

My problem is that I want a variabel, col[17], change to different amount of pictures.
col[17] can have numbers 1-5 or ----
If number 1 then <IMG SRC="star">, 2 then <IMG SRC="star"> <IMG SRC="star"> and so on.

This is my page code:

<HTML>
<HEAD>
<STYLE TYPE="text/css">

</STYLE>
</HEAD>
<BODY>
<?
$db = mysql_connect();
$databas = mysql_select_db("filmer");
$info = "SELECT * FROM dvd ORDER BY titel";
$resultat = mysql_query($info);

{$rc = colorSwitch();
echo "<TR CLASS=\"$rc\">
<TD>$col[1]</TD>
<TD>$col[2]</TD>
<TD>$betyg</TD>
</TR>
";
}
?>
</TABLE>
<?
mysql_close($db);
?>
</BODY>
</HTML>

And this is my if-code I tried to use:

if ($col[17] == 1)
$betyg = "<IMG SRC=\"star.gif\">";
elseif ($col[17] == 2)
$betyg = "<IMG SRC=\"star.gif\">...";
elseif ($col[17] == 3)
$betyg = "<IMG SRC=\"star.gif\">...";
elseif ($col[17] == 4)
$betyg = "<IMG SRC=\"star.gif\">...";
elseif "$col[17] == 5)
$betyg = "<IMG SRC=\"star.gif\">...";
else = "----";

Obviously it's not that simple because all rows get the same result regardless of col[17]'s content.

I hope you all understand what I mean and i'm sorry if it's crappy english :-)

Thanks for any help!!

kristianblom

First of all I would use {} with my if statements

you could also use a switch statement...

switch($row[17]){

case 1:
$betyg = "<IMG SRC=\"star.gif\">";
break;
case 2:
and so on ..
break;
case 3:
break;
default:
put in something as you default img...
}

mahers

Another way is a loop.


$i=0
$betyg = "-----";
while($i++<$row[17]) {
    $betyg .= "<img src=\"star.gif\">";
}

echo $betyg;

Stalis

Thanks for the help so soon.

I might be a complete moron but is their any chance that someone of you guys could show how I merge one of your solutions with my existing code?
I can't make it work.
Do not want to research now, just sleep...
Here in Sweden it's 4.02 in the morning, time to sleep.

But thanks again.

mahers

<?php

while ($col = mysql_fetch_row($resultat)) {
    $rc = colorSwitch();
    echo "<TR CLASS=\"$rc\">";

// Uncomment whichever one you want.


/* kristianblom's example
switch($col[17]) {
    case 5: $betyg .= "<IMG SRC=\"star.gif\">";
    case 4: $betyg .= "<IMG SRC=\"star.gif\">";
    case 3: $betyg .= "<IMG SRC=\"star.gif\">";
    case 2: $betyg .= "<IMG SRC=\"star.gif\">";
    case 1: $betyg .= "<IMG SRC=\"star.gif\">";
    break;

    default:
    $betyg .= "------";        
}
*/

/* mahers' example
$betyg = "-----";
for($i=0; $i<$col[17]; $i++)
    $betyg .= "<IMG SRC=\"star.gif\">";
*/

echo "<TD>$col[1]</TD><TD>$col[2]</TD><TD>".$betyg."</TD>";
echo "</TR>";
}

?>

Stalis

Thanks mahers for your reply.
I have almost got your example to work except the fact that all rows get the "----".
The only time I want "----" is when col[17] contains "----".
When col[17] contains a number I want that amount of pictures.
Is this possible?

I hope i'm not a pain in the ass 🙂

kristianblom

if(preg_match("/[^0-9]/", $row[17]){ //If var contains only numbers

for($i=0; $i<$col[17]; $i++){
    $betyg .= "<IMG SRC=\"star.gif\">";
}

}
else{
$betyg = "----";
}

Stalis

Thanks for your help but unfortunaly it's not working.
All rows get "----" ONLY!!

Anyway, I have desided to skip "----" and use only numbers (easier).

Thanks for all your help and keep up the good work!!

Best regards:

Mathias