Den første række fra mysql mangler!
Hej,Når jeg henter fra mysql mangler den første row?
Her er koden:
if ($number3 > 0) { ?>
<table width="711" border="0">
<tr>
<td width="91"><strong>Sagsnummer</strong></td>
<td width="140"><strong>Firma</strong></td>
<td width="160"><strong>Navn</strong></td>
<td width="82"><strong>Start dato</strong></td>
<td width="98"><strong>Afsluttet dato </strong></td>
<td width="114"><strong>Model</strong></td>
</tr>
</table>
<?
while($row3 = mysql_fetch_array($result)) {
for ( $i=0; $i<1; $i++ ) {
if ($row3) {
$result2 = mysql_query("select * from fitness_c_kunde WHERE sagsnummer = '$row3[sagsnummer]' order by sagsnummer asc") or die(mysql_error());
$number2 = mysql_num_rows($result2);
$row2 = mysql_fetch_array($result2);
$color = $q++ % 2 ? 'rgb(247,245,238)' : 'rgb(236,233,216)'; ?>
<table width="733" border="0" style="border-collapse: collapse;" class="datatable">
<tr><td width="90" onclick="location.href = ('<? $PHP_SELF; ?>?main=sagsinfo&intid=<? print $row2[intid]; ?>');" style="background-color: <? if($row[privotet]){ ?> rgb(255,0,0)<? } else { print $color; } ?>;"><b><? print $row2[sagsnummer]; ?></b></td>
<td width="132" onclick="location.href = ('<? $PHP_SELF; ?>?main=sagsinfo&intid=<? print $row2[intid]; ?>');"> <? print $row2[butiknavn];?>
</td>
<td width="150" onclick="location.href = ('<? $PHP_SELF; ?>?main=sagsinfo&intid=<? print $row2[intid]; ?>');"> <? print "$row2[navn] $row2[efternavn]"; ?> </td>
<td width="84" onclick="location.href = ('<? $PHP_SELF; ?>?main=sagsinfo&intid=<? print $row2[intid]; ?>');"><?
$result8 = mysql_query("select * from fitness_c_sag WHERE sagsnummer = '$row2[sagsnummer]'");
$row8 = mysql_fetch_array($result8);
print $row8[dato]; ?>
</td>
<td width="89" onclick="location.href = ('<? $PHP_SELF; ?>?main=sagsinfo&intid=<? print $row[intid]; ?>');"><? if($row8[dato_afslut]){ print $row8[dato_afslut]; } else { print $row2[klar]; } ?></td>
<td width="160"><? $result11 = mysql_query("select * from fitness_c_vare WHERE intid = '$row8[model]'");
$row11 = mysql_fetch_array($result11); ?><? print $row11[model]; ?>
<? if($row[demo]){ ?>
<strong>På demo lager </strong>
<? } ?></td>
</tr>
</table>
<? }}}} else { print "Din søgning på <strong>$sog2</strong> gav ingen resultat<br><br>"; ?>
<a href="<? $PHP_SELF; ?>?rep.php" class="menulink2">Prøv igen </a> <? } ?>
<?
//print "$row[butiknavn] i $row[bynavn], <a href='r'>se butikens info</a>";
?>
Mvh
