Re: DB query returning wierd results

> From: "Brian V Bonini" <b-bonini@cox.net> > Sent: Thursday, August 08, 2002 12:56 PM > Subject: [PHP] DB query returning wierd results > 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); ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ The line above is doing it. > $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"; > } > ?> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > >