Thanks, I did use your code as is, and it works perfectly. Regards, Chip "Bastien Koert" <[EMAIL PROTECTED]> wrote on 01/28/2005 09:56:35 AM:
> What you should do then is to compare some value to only write the image > data if that value matches....in my code snippet, since you are writing the > same data, i just loop thru it and increment the image counter to output the > correct image. A better way to manage this might be to put the image name in > the db with all the other data as a separate field...then you just fill in > the image data....and reduce the code to pretty much what i had... > > bastien > > >From: Chip Wiegand <[EMAIL PROTECTED]> > >To: php-db@lists.php.net > >Subject: RE: [PHP-DB] odd results when running this > >Date: Fri, 28 Jan 2005 09:17:35 -0800 > > > >Thanks for the tips. > >I find this confusing - I have 3 statements pulling 3 differant images, so > >I don't understand why the script would run 3 times if there is not loop > >telling it to do so. Shouldn't it just load each image and then stop? > >Doesn't the while loop stop when it hits the last row? > >-- > >Chip > > > >"Bastien Koert" <[EMAIL PROTECTED]> wrote on 01/28/2005 08:37:58 AM: > > > > > it runs three times because there are three rows of data and you are > >setting > > > the same thing for each set of data. > > > > > > try this > > > > > > <? > > > $sql="select * from hotspots"; > > > $result = mysql_query($sql); > > > $x = 1; > > > > > > while ( $row = mysql_fetch_array($result)) > > > { > > > printf("<p><img src=\"hotspots/latest$x.gif\" alt=\"%s\" > > > title=\"%s\"></p><p class=\"footnote\">%s</p>", $row["alt-text"], > > > $row["title-text"], $row["desc-text"]); > > > $x++; > > > } > > > ?> > > > > > > bastien > > > > > > >From: Chip Wiegand <[EMAIL PROTECTED]> > > > >To: "PHP DB" <php-db@lists.php.net> > > > >Subject: [PHP-DB] odd results when running this > > > >Date: Fri, 28 Jan 2005 07:41:30 -0800 > > > > > > > >Okay, so I have got the php bits working in this web page but it is > > > >running 3 times every time the page loads, and I see no reason why (I > >have > > > >opened this page in two differant browsers). The code for the entire > >page > > > >is pasted below, it includes some calls to include files which are not > > > >included in this message of course (and this file is itself included in > > > >another file), the page can be seen at this address: > > > >http://www.simradusa.com/index-test.php > > > >If anyone can see any reason for the script to run 3 times please let > >me > > > >know. > > > >Thanks, > > > >Chip > > > >====================================================================== > > > ><table width="100%" border="0" cellpadding="5" cellspacing="0" > > > >align="center" > > > >summary="table that contains the body of the page"> > > > ><tr> > > > ><td> > > > ><div align="top"> > > > ><p class="welcome">Welcome to Simrad, Inc</p> > > > ><p class="paratext"> > > > >Simrad is one of the world's largest manufacturers of marine > >electronics > > > >for the yachting, > > > >fishery and commercial marine markets, offering sales and service > > > >worldwide. A complete > > > >range of products from Simrad is available for many different types of > > > >marine activity, > > > >including auto steering, navigation, hydro acoustic and communication > > > >equipment. Ranging > > > >from pleasure boating, through fishing and into commercial craft. > >Please > > > >select the type > > > >of activity that you are interested in using the links on the left. > > > ></p> > > > ><br /><br /><br /> > > > ><p class="paratext">Read <a > > > >href="SimradNews/Spring2004/SimradNews-p1.html" target="_new"><span > > > >class="red">Simrad</span><span class="blue">News</span></a> - Your > > > >quarterly guide to today's marine electronics (opens in a new > >window)<br > > > >/> > > > ><!-- Or download the .pdf version <a > > > > >href="SimradNews/Spring2004/SimradNews.php">here</a> (765Kbytes) >--></p> > > > ><br /> > > > ><p class="c2"><img src="images/sim-net-icon.gif" alt="ANNOUNCING THE > >NEW > > > >SIMNET NETWORK" border="0" title="SAWDUST helm - all Simrad products" > > > >/></p> > > > ><p> > > > ><a href="#" > > > >onclick="window.open('simnet.html','simnet','toolbar=no,width=450, > > > height=500,left=0,top=0,screenX=0,screenY=0,status=no, > > > scrollbars=yes,resize=yes');return > > > >false" > > > > onmouseover="window.status='ANNOUNCING THE NEW SIMNET NETWORK';return > > > >true;" > > > >onmouseout="window.status='ANNOUNCING THE NEW SIMNET NETWORK'; return > > > >true;" > > > > title="Read more about the SimNet" > >class="special-links"><em>ANNOUNCING > > > >THE NEW SIMNET NETWORK</p> > > > ></div> > > > ></td> > > > ><td><br /> > > > ><p class="title">What's New</p> > > > ><? > > > >$sql="select * from hotspots"; > > > >$result = mysql_query($sql); > > > >while ( $row = mysql_fetch_array($result)) > > > > { > > > > printf("<p><img src=\"hotspots/latest1.gif\" alt=\"%s\" > > > >title=\"%s\"></p><p class=\"footnote\">%s</p>", $row["alt-text"], > > > >$row["title-text"], $row["desc-text"]); > > > > printf("<p><img src=\"hotspots/latest2.gif\" alt=\"%s\" > > > >title=\"%s\"></p><p class=\"footnote\">%s</p>", $row["alt-text"], > > > >$row["title-text"], $row["desc-text"]); > > > > printf("<p><img src=\"hotspots/latest3.gif\" alt=\"%s\" > > > >title=\"%s\"></p><p class=\"footnote\">%s</p>", $row["alt-text"], > > > >$row["title-text"], $row["desc-text"]); > > > > } > > > >?> > > > ></td> > > > ></tr> > > > ></table> > > > ><table summary="company blurb" align="center" border="0" > >cellspacing="0" > > > >cellpadding="10" width="80%"> > > > ><tr> > > > ><td colspan="2"> > > > ><div class="co-blurb"> > > > ><hr width="75%" /> > > > ><p class="paratext"><a href="contact/simradbackground.php" > > > >onmouseover="window.status='Some Background information about > > > >Simrad';return true;" > > > >title="Some Background information about Simrad" > > > >class="special-links">Simrad</a> has built its name on > > > >products which do what they are designed to do, whatever the > >conditions. > > > >As part of <a > > > >href="http://www.kongsberg.com/" > > > >onmouseover="window.status='The Kongsberg Maritime Corporate Home > > > >Page';return true;" > > > >title="Our corporate parent company home page" target="_blank" > > > >class="special-links">Kongsberg Maritime</a>, the largest > > > >manufacturer of marine electronics in the world, Simrad manufactures > > > >products which are > > > >developed and built on the same principles as the company's > >sophisticated > > > >electronics > > > >for the demanding commercial shipping and fisheries market.</p> > > > ></div> > > > ></td> > > > ></tr> > > > ></table> > > > > > > > >-- > > > >PHP Database Mailing List (http://www.php.net/) > > > >To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php