Re: DB query returning wierd results

On Thu, 8 Aug 2002, Brian V Bonini wrote: >-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 think because $content contains your first row. >- $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="#" >-DEFANGED_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 >- ************************************** John Huggins VANet jhuggins@va.net http://www.va.net/ **************************************