RE: [PHP] DB query returning wierd results

YES!! Thank you... > -----Original Message----- > From: John S. Huggins [mailto:jhuggins@va.net] > Sent: Thursday, August 08, 2002 12:57 PM > To: Brian V Bonini > Cc: PHP Lists > Subject: Re: [PHP] 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/ > > ************************************** >