Array Problem

james182

Whats happened?? it doesn't output the numbers correctly it should look like this:
pausecontent[0]=» title1
pausecontent[1]=» title2
pausecontent[2]=» title3

NOT this:
pausecontent[0]=» title1
pausecontent[0]=» title2
pausecontent[0]=» title3

<?
include ("connect.php");
$result = mysql_query("select * from news ");
$count = mysql_num_rows($result);

for ( $i=0; $i <= $count; $i++) {
    while($r=mysql_fetch_array($result)){
        $title=$r["title"];
        $blurb=$r["blurb"];
        $nid=$r["nid"];

    echo "pausecontent[$i]=<span class='title'>&raquo; $title<br></span><span class='date'>$date<br></span><span class='content'>$blurb<br><br></span>";
}
}
?>

suntra

Simple... you put a while statement in a for statement...

The while statement while execute itself completely with $i=0...
Then $i will be set to 1, 2, 3, ...

That's why you see [0]...[0]...[0]...

james182

Sorry confused what do you mean???

make for, while??

while ( $i=0; $i <= $count; $i++) {

while($r=mysql_fetch_array($result)){

suntra

No...

You wrote :

for(...) {
    while(...) {
    }
}

So, the while statement will execute completely BEFORE the for statement increments its value...

So what happens is this...

for($i=0; $i<count(...); $i++) {

So at the moment, $i = 0

while($r=mysql_fetch_array($result)){

And here, the while statement while execute completely, from the very first result to the very last...

So this statement...

echo "pausecontent[$i]=» $title $date $blurb ";

...will always return pausecontent[$i] because $i is still zero !

Then the while statement has completely executed itself...

Now $i (= 0) can be $i + 1 (= 1)...

Now we hit the while statemen()... we already called it completely, so it returns false, so no output...

Now $i (= 1) can be $i + 1 (= 2)...

Now we hit the while statemen()... we already called it completely, so it returns false, so no output...

Now $i (= 2) can be $i + 1 (= 3)...

AND SO ON !!

james182

now its outputting each row 5 times

include ("connect.php");
$result = mysql_query("select * from news ");
$count = mysql_num_rows($result);

while($r=mysql_fetch_array($result)){
	$title=$r["title"];
	$blurb=$r["blurb"];
	$date=$r["date"];
	$nid=$r["nid"];
	for ( $i=0; $i <= $count; $i++) {
		echo "pausecontent[$i]=<span class='title'>&raquo; $title<br></span><span class='date'>$date<br></span><span class='content'>$blurb<br><br></span>";
	}
}

suntra

Try this...

$i = 0;
while($r=mysql_fetch_array($result)){
    $title=$r["title"];
    $blurb=$r["blurb"];
    $date=$r["date"];
    $nid=$r["nid"];
    echo "pausecontent[$i]=<span class='title'>&raquo; $title<br></span><span class='date'>$date<br></span><span class='content'>$blurb<br><br></span>";
    $i++;
}

mborish_2000

<?
include ("connect.php");
$result = mysql_query("select * from news ");
$count = mysql_num_rows($result);

for ( $i=0; $i < $r=mysql_fetch_array($result); $i++) {
$title=$r["title"];
$blurb=$r["blurb"];
$nid=$r["nid"];

    echo "$pausecontent[$i]=<span class='title'>&raquo; $title<br></span><span class='date'>$date<br></span><span class='content'>$blurb<br><br></span>";

}
?>

james182

OH now i get it! thanks very much. 🙂

suntra

mborish_2000 wrote:
<?
include ("connect.php");
$result = mysql_query("select * from news ");
$count = mysql_num_rows($result);

for ( $i=0; $i < $r=mysql_fetch_array($result); $i++) {
$title=$r["title"];
$blurb=$r["blurb"];
$nid=$r["nid"];
 echo "$pausecontent[$i]=&raquo; $title $date $blurb ";
}
?>

First time I see this syntax... and it works... !! Strange...

I modified the code and wrote this :
echo ($r=mysqli_fetch_array($result));

It echoes, as expected, "Array"... then why FOR accepts that ??!!

mborish_2000

as long as there are rows left it should keep going?

suntra

mborish_2000 wrote:
as long as there are rows left it should keep going?

Yes, it does, but that's strange !

Try this :

for($intI = 0; $intI < array(); $intI++) {
    echo $intI . '<br />' . "\n";
    flush();
}

You will get an endless loop... but we first set an integer as the "minimum" condition, and as "maximum" condition, we set an array... two different types...

Also try this :

echo (0 < array());

Where is the logic in there ??!!

mborish_2000

It's because its boolean.

Here's what I got from the PHP manual:

for (expr1; expr2; expr3)
statement

The first expression (expr1) is evaluated (executed) once unconditionally at the beginning of the loop.

In the beginning of each iteration, expr2 is evaluated. If it evaluates to TRUE, the loop continues and the nested statement(s) are executed. If it evaluates to FALSE, the execution of the loop ends.

At the end of each iteration, expr3 is evaluated (executed).

expr2 being empty means the loop should be run indefinitely (PHP implicitly considers it as TRUE, like C).