veri getirme sırasında sorun

1 Cevap php

İşte benim kod

$sql="SELECT * FROM $tbl_name WHERE ownerId='$UserId'"; $result=mysql_query($sql,$link)or die(mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC);

<?php
                                    while($row = mysql_fetch_array($result, MYSQL_ASSOC))
                                        {
                                            echo "<tr>";
                                            echo "<td>".$row['pinId']."</td>";
                                            echo "<td>".$row['usedby']."</td>";
                                            echo "<td>".$row['status']."</td>";
                                            echo "</tr>";
                                        }
                                    ?>

it is ignoring the first record means if 4 rows are in $row its ignoring the 1st one rest three are coming on page. OwnerID birincil anahtar değil.

1 Cevap

This problem is arising because you already called $row = mysql_fetch_array($result, MYSQL_ASSOC); once before looping..

Bu kodu deneyin ...

$sql="SELECT * FROM $tbl_name WHERE ownerId='$UserId'"; 
$result=mysql_query($sql,$link)or die(mysql_error());

<?php
 while($row = mysql_fetch_array($result, MYSQL_ASSOC))
  {
   echo "<tr>";
   echo "<td>".$row['pinId']."</td>";
   echo "<td>".$row['usedby']."</td>";
   echo "<td>".$row['status']."</td>";
   echo "</tr>";
   }
 ?>

ben yaptım tüm kod 3 satır kaldırılır ....

etiketler