While loop question

TCovert

Why won't this code work???


$query1 = "SELECT story_id, photo_caption FROM photo WHERE story_id LIKE '$intId' LIMIT 4";

$result1 = mysql_query($query1, $conn);
$num_p1 = mysql_num_rows($result1);

$row1 = mysql_fetch_array($result1);

while (list($photo_caption) = mysql_fetch_row($result1))
{
echo "<span class=bodytext>" . $row1[1] . "</span><br><br>";
}

AQHost

Hi,

Try this instead:

$query1 = "SELECT story_id, photo_caption FROM photo WHERE story_id LIKE '$intId' LIMIT 4";

$result1 = mysql_query($query1, $conn);
$num_p1 = mysql_num_rows($result1);

while ($row = mysql_fetch_array($result1))
{
   echo "<span class=bodytext>" . $row[photo_caption] . "</span><br><br>";
}

Best wishes,
Simon.

TCovert

Well, the thing is that it returns one of the records. But there is two records with the same story_id, so it should return the photo_caption for both of them in that loop...correct?

AQHost

If there are two records with the same story_id then the code would execute like this:

$query1 = "SELECT story_id, photo_caption FROM photo WHERE story_id LIKE '$intId' LIMIT 4";

$result1 = mysql_query($query1, $conn);
$num_p1 = mysql_num_rows($result1);
echo "Returned records = ".$num_p1."<BR><BR>";
// $num_p1 should equal 2

while ($row = mysql_fetch_array($result1))
{
   echo "<span class=bodytext>" . $row[photo_caption] . "</span><br><br>";
   // This loop will execute twice, and will echo the photo_caption for row 1 first time
   // then for row 2 second time
}

Simon.

TCovert

In the display, it only echoes the first one. But it does show "Returned records = 2".

Any ideas?

AQHost

Time for a boring process of logic then I'm afraid :-)

$query1 = "SELECT story_id, photo_caption FROM photo WHERE story_id LIKE '$intId' LIMIT 4";

$result1 = mysql_query($query1, $conn);
$num_p1 = mysql_num_rows($result1);
echo "Returned records = ".$num_p1."<BR><BR>";
// $num_p1 should equal 2

$i = 1;
while ($row = mysql_fetch_array($result1))
{
   echo "<span class=bodytext>" . $row[photo_caption] . "&nbsp;Row $i</span><br><br>";
$i++;
   // This loop will execute twice, and will echo the photo_caption for row 1 first time
   // then for row 2 second time
}

Simon.

TCovert

You're not going to believe this. It still only gives me one. It seems like it is pulling both, but only displaying one.

It does give me the "Row 1" after the Caption, however.

AQHost

But it never displays Row 2 as a caption anywhere?

TCovert

Nope

AQHost

Very odd. What happens with this code?

$query1 = "SELECT story_id, photo_caption FROM photo WHERE story_id LIKE '$intId' LIMIT 4";

$result1 = mysql_query($query1, $conn);
$num_p1 = mysql_num_rows($result1);
echo "Returned records = ".$num_p1."<BR><BR>";
// $num_p1 should equal 2

for($counter=1; $counter <= $num_p1; $counter++)
{
   $row = mysql_fetch_array($result1);
   echo "<span class=bodytext>" . $row[photo_caption] . "&nbsp;Row $counter</span><br><br>";
   // This loop will execute twice, and will echo the photo_caption for row 1 first time
   // then for row 2 second time
}

Please can you send me the URL where I can view the results of this code to Sales[at]AQHost.com

Simon.

TCovert

YESSSSS!!!!!

That worked!

That is sooo weird that the other ways we tried didn't work.

Thanks.