Would like some help, please!!

Stalis

Hi!

This is my code...

<HTML>
<HEAD>
<?
$db = mysql_connect();
$databas = mysql_select_db("filmer");

$dvd = "SELECT * FROM dvd WHERE status_farg='red' ORDER BY titel";
$resultatdvd = mysql_query($dvd);
?>
</HEAD>
<BODY>
<TABLE CELLSPACING="0" CELLPADDING="0">
<?
while ($col = mysql_fetch_row($resultatdvd))
echo "<TR>
<TD TITLE=\"$col[8]\"><A HREF=\"filminfo.php?id=$col[0]\" TARGET=\"page\">$col[1]</A></TD>
</TR>";
?>
</TABLE>
</BODY>

</HTML>

My problem is that if no record with status_farg='red' is found I would like it to say something like "No record found".
I have tried to solve it for some time now but I can not make it work. 😕
It is probably very simple to do, but I seriously need some help 🙂

Thanks for all help and I am sorry if my english is like crap but I hope you all understand me 🙂

LordShryku

Check out mysql_num_rows
Use that to determine how many rows were returned, and a simple if statement to say if it returned zero, do this, else do this

Stalis

Thanks for your help but I have already tried that and it doesn't work.
The problem I think is that the while loop don't work when $resultatdvd is empty so it just stops.
I have also tried to use the whole while loop inside a if statement but I can't get it to work that way either.
Seems that a loop can't be inside a if statement.
Maybe you have some other idea how to fix it?

Thanks!!

/Stalis

LordShryku

I really wanted you to do this on your own, but you shouldn't even be getting to the while loop if it's empty. Look at this..

<HTML> 
<HEAD> 
<? 
$db = mysql_connect(); 
$databas = mysql_select_db("filmer"); 
$dvd = "SELECT * 
        FROM dvd 
        WHERE status_farg='red' 
        ORDER BY titel"; 
$resultatdvd = mysql_query($dvd); 
$rows = mysql_num_rows($resultatdvd);
?> 
</HEAD> 
<BODY> 
<? 
if($rows > 0) {
    echo "<TABLE CELLSPACING=\"0\" CELLPADDING=\"0\">";
    while($col = mysql_fetch_row($resultatdvd)) {
        echo "<TR> 
                <TD TITLE=\"$col[8]\"><A HREF=\"filminfo.php?id=$col[0]\" TARGET=\"page\">$col[1]</A></TD> 
              </TR>";
    }
    echo "</TABLE>";
}
else {
    echo "No records found";
}
?> 
</BODY> 
</HTML>

Stalis

Just like I thought, really easy to solve 🙂
I tried to use variables and stuff but when I see what you have done and how easy it was, it really makes me feel ashamed :rolleyes:.

Thank you very much and I hope you keep up the good work when another newbie comes around.
Maybe it's me 🙂

LordShryku

No need to feel ashamed...just make sure you understand how this is done, cuz you will probably use it alot. If ya need any mor ehelp, you're always welcome back 🙂