Handling query results

[fender]

Let's say I have somethink like so:

		while ($row = mysql_fetch_array($result, MYSQL_NUM)) {

			echo $row[0];
			echo '<br />';
			
		}

If there are 4 rows returned, whatever is being returned gets displayed four times. If numbers are being return, how would I obtain the following?

1
2
text
3
4

 

[Tawnos]

Do you mean how do you put text halfway through your returns?

Specify a bit more what you want, please. If you're trying to print half the rows, input your text, then print the second half, using two loops would be easiest.

 

[FlipperBizkut]

If you want the text after 2 rows are returned it would be something like this:

$i = 0;
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
  if ($i == 2) {
    echo 'Whatever text you have to echo.';
  }
  echo $row[0] . '<br />' . "\n";
  $i = $i++;
}

If, on the other hand, you wanted the text half way between as many results as you have, you might try something like this:

$total = mysql_num_rows($result);
$half = ceil($total / 2);
$i = 0;
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
  if($i == $half) {
    echo 'Whatever text you have to echo.';
  }
  echo $row[0] . '<br />' . "\n";
  $i = $i++;
}

I think that should work. Try it out and let me know.