[Resolved] PHP bug? Getting some weird output

spstieng

Hi ya all,

I'm getting a weird output. First I'll give you the code, then I'll give you the output.


$arrResult = array( (Parent),(MenuName) );

// Put fetched data into a managable array
while ($row = mysql_fetch_assoc($result)) 
{
	$arrResult[$i]['Parent']= $row['_Parent'];
	  $arrResult[$i]['MenuName']= $row['MenuName'];

echo '<b>From SQL DB:</b> '.$row['MenuName'].' <b>From PHP Array:</b> '.$arrResult[$i]['MenuName'].'<br>';
$i++;
}

The output I get is:

From SQL DB: Accessories From PHP Array: A
From SQL DB: Case From PHP Array: C
From SQL DB: CD/DVD From PHP Array:CD/DVD
From SQL DB: CPU From PHP Array: CPU
From SQL DB: Hard Drive From PHP Array: Hard Drive

So.... how on earth does position 0 and 1 in my array only contain 'A' and 'C' ??????? 😕

SantaGhost

i am wondering did you declare $i before entering the while loop?

spstieng

Jup 😉

Before the while loop I have: $i = 0;

Weedpacket

I have to admit I've never seen that behaviour before; but one thing I'll point out is that in PHP you don't need to declare the dimensions of an array - what the first line you've posted is doing is creating an array with two elements: the string 'Parent' in position 0 and 'Menuname' in position 1 (and if error reporting was set high enough you'd be getting notices).

So I don't know if it's the problem or not, but just try having
$arrResult = array();

for that line.

spstieng

That worked Weedpacket, thanks! 😃

I used $arrResult = array( (Parent),(MenuName) ); because I wanted to use associative arrays. But by removing them, the first two comes out OK.

Weird error though. 🙂

Steven
- who happily continues programming.