DB query returning wierd results
| From: | Brian V Bonini | Date: | Thu, 08 Aug 2002 16:56:21 +0000 |
| Subject: | DB query returning wierd results | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-111683@lists.php.net to get a copy of this message | ||
Can anyone see a reason why the following would skip the first row of the
DB?
<?php
$sql = "SELECT * FROM SlideShow";
$result = mysql_query_check($sql);
$content = mysql_fetch_object($result);
$i=0;
while($row = mysql_fetch_object($result)) {
$img = $row->image_name;
$size = getimagesize("thumbnails/" . $img);
$popupSize = getimagesize("images/" . $img);
$popupWidth = (50+($popupSize[0]));
$popupHeight = (250+($popupSize[1]));
if (($i % 4) == 0) echo "<tr align=\"center\">\n";
echo <<<ENDJS
<td>
<a href="#"
onclick="popup('./?id=$row->id','ig','width=$popupWidth,height=$popupHeight,
toolbar=no,scrollbars=yes,resizable=yes,location=no');">
<img src="/ss/thumbnails/$img" $size[3] alt="click to enlarge"
/></a><br
/>$popupSize[0] x $popupSize[1]
</td>
ENDJS;
echo "\n";
$i++;
if (($i % 4) == 0) echo "</tr>\n";
}
?>