Home > Archive > PHP DB > January 2005 > RE: [PHP-DB] odd results when running this
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RE: [PHP-DB] odd results when running this
|
|
| Bastien Koert 2005-01-28, 3:57 pm |
| 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@simrad.com>
>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,hei
ght=500,left=0,top=0,screenX=0,screenY=0
,status=no,scrollbars=yes,resize=yes');r
eturn
>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
>
| |
| Chip Wiegand 2005-01-28, 3:57 pm |
| 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@hotmail.com> 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
>
have[color=darkred]
page[color=darkred]
me[color=darkred]
electronics[color=darkred]
Please[color=darkred]
window)<br[color=darkred]
[color=darkred]
--></p>[color=darkred]
NEW[color=darkred]
> height=500,left=0,top=0,screenX=0,screen
Y=0,status=no,
> scrollbars=yes,resize=yes');return
class="special-links"><em>ANNOUNCING[color=darkred]
cellspacing="0"[color=darkred]
conditions.[color=darkred]
sophisticated[color=darkred]
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
| |
| Bastien Koert 2005-01-28, 3:57 pm |
| 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@simrad.com>
>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" <bastien_k@hotmail.com> wrote on 01/28/2005 08:37:58 AM:
>
>setting
>have
>page
>me
>electronics
>Please
>window)<br
>
>--></p>
>NEW
>class="special-links"><em>ANNOUNCING
>cellspacing="0"
>conditions.
>sophisticated
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
| |
| Chip Wiegand 2005-01-28, 3:57 pm |
| Thanks, I did use your code as is, and it works perfectly.
Regards,
Chip
"Bastien Koert" <bastien_k@hotmail.com> 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
>
so[color=darkred]
loop[color=darkred]
AM:[color=darkred]
(I[color=darkred]
entire[color=darkred]
not[color=darkred]
included in[color=darkred]
let[color=darkred]
> ========================================
==============================
of[color=darkred]
communication[color=darkred]
>
>--></p>
THE[color=darkred]
products"[color=darkred]
NETWORK';return[color=darkred]
return[color=darkred]
manufactures[color=darkred]
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
|
|
|
|
|