Jump to content

Archived

This topic is now archived and is closed to further replies.

danthorpe2002

php loop troubles

Recommended Posts

Hi, i have a loop running and i want to stop it. insert a new column in a table and then resume the loop from were it stopped how can i do thiis?? This is the current code


<td width="130" align="center">
<?php
echo mysql_error();
$num = mysql_num_rows($result);

$j=5;
while ($j < $num) {
$title=mysql_result($result, $j, 0);
$desc=mysql_result($result, $j, 1);
$hasImage=mysql_result($result, $j, 2);
?>
<p><a href="play.php?game=<?php echo $title;?>" title="Play <?php echo $title;?> Flash Game"/><?php echo $title;?><br /><img src="preview/<?php echo($hasImage > 0? $title : "missing");?>.gif" alt="Play <?php echo $title;?> Flash Game" width="90" height="90" border="0"/></p>
<?php
$j++;
}
?>
<td align="center">
<?php
echo mysql_error();
$num = mysql_num_rows($result);

$j=5;
while ($j < $num) {
$title=mysql_result($result, $j, 0);
$desc=mysql_result($result, $j, 1);
$hasImage=mysql_result($result, $j, 2);
?>
<p><a href="play.php?game=<?php echo $title;?>" title="Play <?php echo $title;?> Flash Game"/><?php echo $title;?><br /><img src="preview/<?php echo($hasImage > 0? $title : "missing");?>.gif" alt="Play <?php echo $title;?> Flash Game" width="90" height="90" border="0"/></p>
<?php
$j++;
}
?>
</td>
</td>

Share this post


Link to post
Share on other sites
Ok, i just need the loop to run 5 times, then insert a new column and resume the loop but i don''t know how to do this, i have indicated in the code were i need the loop to resume

<td width="130" align="center">
<?php
echo mysql_error();
$num = mysql_num_rows($result);

$j=5;
while ($j < $num) {
$title=mysql_result($result, $j, 0);
$desc=mysql_result($result, $j, 1);
$hasImage=mysql_result($result, $j, 2);
?>
<p><a href="play.php?game=<?php echo $title;?>" title="Play <?php echo $title;?> Flash Game"/><?php echo $title;?><br /><img src="preview/<?php echo($hasImage > 0? $title : "missing");?>.gif" alt="Play <?php echo $title;?> Flash Game" width="90" height="90" border="0"/></p>
<?php
$j++;
}
?>
<td align="center">

//LOOP SHOULD CONTINUE HERE

<?php
echo mysql_error();
$num = mysql_num_rows($result);

$j=5;
while ($j < $num) {
$title=mysql_result($result, $j, 0);
$desc=mysql_result($result, $j, 1);
$hasImage=mysql_result($result, $j, 2);
?>
<p><a href="play.php?game=<?php echo $title;?>" title="Play <?php echo $title;?> Flash Game"/><?php echo $title;?><br /><img src="preview/<?php echo($hasImage > 0? $title : "missing");?>.gif" alt="Play <?php echo $title;?> Flash Game" width="90" height="90" border="0"/></p>
<?php
$j++;
}
?>
</td>
</td>

Share this post


Link to post
Share on other sites
change the code to thiis

[code]
$sql = ""; // your sql here
$result = mysql_query ($sql) or die (mysql_error ());
$num = 0;
while ($data = mysql_fetch_array ($result))
{
  // loop
  if ($num == 5) echo "</td><td>";
  $num++;
}
[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.