I have a database where i filter the information depending on what a user clicks on on my webpage. The problem is that for example the result should show 3 hits then it only shows 2 and if it should be 8 it only shows 7. It always shows one less.
Can anyone help me?
$sql="SELECT * FROM produkter WHERE material='$material' AND typ='$typ' ORDER BY serie";
$result=mysql_query("$sql");
$rad=mysql_fetch_array($result);
while($rad=mysql_fetch_array($result))
{
echo "..........................";
}