Thanks, I did use your code as is, and it works perfectly.
Regards,
Chip
"Bastien Koert" <bastien_k@xxxxxxxxxxx> 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 <chip.wiegand@xxxxxxxxxx>
> >To: php-db@xxxxxxxxxxxxx
> >Subject: RE: 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" <bastien_k@xxxxxxxxxxx> 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 <chip.wiegand@xxxxxxxxxx>
> > > >To: "PHP DB" <php-db@xxxxxxxxxxxxx>
> > > >Subject: 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
