[RESOLVED] help creating arrays

[imad_imike]

Hi, I'm new to php and im trying to create arrays to hold the data from mysql database.

Anyway, I've tried but everytime I try echo one of the variables, nothing changes.

I'll post a copy of my script, any help is appreciated.

<?php
$entryID[$entry] = array();
$entryValue[$entry]	= array();	
$entrySelect[$entry] = array();
$entryBalanceSheet[$entry] = array();
$entryDate[$entry] = array();
$entryRW[$entry] = array();

//intangible
$IentryID[$entry] = array();
$IentryValue[$entry] = array();	
$IentrySelect[$entry] = array();
$IentryBalanceSheet[$entry] = array();
$IentryDate[$entry] = array();
$IentryTotal[$entry] = array();

//tangible
$TentryID[$entry] = array();
$TentryValue[$entry] = array();	
$TentrySelect[$entry] = array();
$TentryBalanceSheet[$entry] = array();
$TentryDate[$entry] = array();
$TentryTotal[$entry] = array();

$SQL = "SELECT * FROM AccPeriod WHERE UserID = '$userID' ORDER BY AccOpen ASC";
$result = mysql_query($SQL) or die(mysql_error());
$num_rows = mysql_num_rows($result);

$SQL1 = "SELECT * FROM Entry WHERE UserID = '$userID' AND EntryAdjustment IS NULL AND (EntrySelect=4 AND ((EntryBalanceSheet=1) OR (EntryBalanceSheet=2)))";
$result1 = mysql_query($SQL1) or die(mysql_error());
$num_rows1 = mysql_num_rows($result1);
	$entry = 0;
	while ($row = mysql_fetch_array($result1))
	{		
		$entryID[$entry] = $row['EntryID'];
		$entryValue[$entry]	= $row['EntryValue'];	
		$entrySelect[$entry] = $row['EntrySelect'];
		$entryBalanceSheet[$entry] = $row['EntryBalanceSheet'];
		$entryDate[$entry] = $row['EntryDate'];
		$entryRW[$entry] = $row['EntryRW'];

	if ($entryRW[$entry]==0)
 	{
    	$entryRW[$entry] = 0 - $entryRW[$entry];

		if($entryBalanceSheet[$entry] ==1) 
		{
			$IentryID[$entry] = $entryID[$entry];
			$IentryValue[$entry] = $entryValue[$entry];	
			$IentrySelect[$entry] = $entrySelect[$entry];
			$IentryBalanceSheet[$entry] = $entryBalanceSheet[$entry];
			$IentryDate[$entry] = $entryDate[$entry];
			$IentryTotal[$entry] = $IentryTotal[$entry] + $IentryValue[$entry];
		}
			if($entryBalanceSheet[$entry] ==2) 
			{
				$TentryID[$entry] = $entryID[$entry];
				$TentryValue[$entry] = $entryValue[$entry];	
				$TentrySelect[$entry] = $entrySelect[$entry];
				$TentryBalanceSheet[$entry] = $entryBalanceSheet[$entry];
				$TentryDate[$entry] = $entryDate[$entry];
				$TentryTotal[$entry] = $TentryTotal[$entry] + $TentryValue[$entry];
			}
 	}
 	$entry ++;
 	$num_rows1 = $entry;				
}				
?>
<div id="container">
	<?php ;
 		displayHeader();
			?>

<h1 style="text-align:center;">Fixed Asset Register</h1>
<hr />


<?php
echo $entryID[$entry];
 	?>

<?php
  		displayFooter();
?>

</div>


</script>
</body>
</html>

Ive tried echoing a number of different arrays but they all just show up blank.

And if I try echoing them without the [$entry] at the end, they echo 'array'

Thanks in advance

[cretaceous]

you can't echo an array directly - do:
print_r($thearray);

that won't break it onto lines nicely, to do that, do
echo '<pre>';
print_r($thearray);
echo '</pre>';

if :
echo $TentryID[$entry];
is showing blank, then I expect
$entry is itself blank .. or there's some other problem

... edit 3:

your arrays are multi dimensional, arrays in an array, so it can't echo
$TentryID[$entry];
(it would be ok if the arrays were simple one level lists)

print_r($TentryID[$entry]);

should be the answer

[imad_imike]

Thanks mate, you were correct, and you help me come up with the solution. I managed to get them to echo in a for loop.
example:

for ($entry =0; $entry < $num_rows1; $entry ++)
{
echo $entryID[$entry];
}

thanks mate, great help

I'll changed to resolved in a moment

[Ashley_Sheridan]

I use var_dump() instead of print_r(). It's great if you have the xdebug packages installed with PHP, as it formats the output nicely, and works well with objects as well as arrays, and shows the type of each variable it outputs.