Not all rows listed

[Anon]

I have a perplexing problem with displaying all the records from a mysql database. When I do a mysql_num_rows query, I get a result of 3 rows yet only 2 are displayed. It is always the first row that isn't being displayed.

here is the code to select the records from the database

$getweek = mysql_query("SELECT *, WEEK(date_entered, 1) AS thisweek, DAYNAME(date_entered) AS today, MONTHNAME(date_entered) AS nowmonth, DAYOFMONTH(date_entered) AS daymonth, YEAR(date_entered) AS nowyear FROM sales_records WHERE YEAR(date_entered)='$currentyear' AND WEEK(date_entered, 1)='$getweeknumber' AND rep_sid='$rep_id' ORDER BY date_entered");

Has anyone had this problem before?

cheers
Ken

[Anon]

Show the code which displays the records instead.

[frankenstrat]

Here ya go Lars!

<?PHP

while ($myrow5 = mysql_fetch_array($getweek)) {
extract($myrow5);

switch ($description) {
case 1:
$desc = "New Purchase";
break;
case 2:
$desc = "Installations";
break;
case 3:
$desc = "Upgrade";
break;
}

if($colour == "#fffafa") {
$colour = "#f5f5f5";
} else {
$colour = "#fffafa";
}

print "<TR BGCOLOR=\"$colour\">\n";
print "<TD>$date_entered $num_rows</TD>";
print "<TD><a href=\"updaterecord.php?rec_id=$sales_id\" class=\"darklink\" onMouseover=\"window.status='Click here to update this entry';return true;\" onMouseout=\"window.status=''\">$client</a></TD>";
print "<TD>$desc</TD>";
print "<TD ALIGN=\"right\">";

if ($type=="3") {
print "$".number_format($value,2);
} else {
print "&nbsp;";
}
print "</TD>";

print "<TD ALIGN=\"right\">";

if ($type=="2") {
print "$".number_format($value,2);
} else {
print "&nbsp;";
}
print "</TD>";

print "<TD ALIGN=\"right\">";

if ($type=="1") {
print "$".number_format($value,2);
} else {
print "&nbsp;";
}
print "</TD>";

switch ($estimated) {
case 0:
$est = "";
break;
case 1:
$est = "Yes";
break;
case 2:
$est = "No";
break;
}

print "<TD>";
if ($type !="3") {
print $est;
} else {
print "&nbsp;";
}
print "</TD>";
print "<TD>";
if ($win !="0" && $type !="3") {
print "$win%";
} else {
print "&nbsp;";
}
print "</TD>";
print "<TD>";
if ($forecast !="0") {
print "$".number_format($forecast,2);
} else {
print "&nbsp;";
}
print "</TD>";

print "<td><a href=\"javascript:deleteRec('$PHP_SELF?ID=$sales_id&delete=yes');\" onMouseover=\"window.status='Click here to delete this entry';return true;\" onMouseout=\"window.status=''\"><IMG SRC=\"pics/trash.gif\" ALT=\"\" WIDTH=11 HEIGHT=14 BORDER=\"0\"></a></td>\n";

print "</TR>\n";
}
?>