[RESOLVED] Problem creating array to hold mysql data

[imad_imike]

Ok, so heres the sql query, arrays and loop

  $entryID[$entry]           = array();
						$entryName[$entry] 	       = array();
						$entryDate[$entry] 	       = array();		
						$entryRW[$entry]		   = array();
						$entryValue[$entry]		   = array();	
						$entrySelect[$entry]       = array();
						$entryBalanceSheet[$entry] = array();
						$NoOfEntries               = array();


$SQL = "SELECT * FROM Entry WHERE UserID = '$userID' AND (EntrySelect=4 AND (EntryBalanceSheet=1) OR (EntryBalanceSheet=2))";
$result = mysql_query($SQL) or die(mysql_error());
$num_rows = mysql_num_rows($result);

if ($num_rows <1 || $num_rows =="")
			{
				$NoOfEntries= false;
			}
			else
			{
				$entry = 0;
				$NoOfEntries = $entry;
				while ($row = mysql_fetch_array($result))
				{	
						$entryID[$entry] = $row['EntryID'];
						$entryName[$entry] 	= $row['EntryName'];
						$entryDate[$entry] 	= $row['EntryDate'];		
						$entryRW[$entry]		= $row['EntryRW'];
						$entryValue[$entry]		= $row['EntryValue'];	
						$entrySelect[$entry] = $row['EntrySelect'];
						$entryBalanceSheet[$entry] = $row['EntryBalanceSheet'];	

					$entry ++;
					$NoOfEntries = $entry;
				}	

		}

And then I'm trying to echo some of the data into a table, like so

<?php if ($NoOfEntries= true)
{
?>
	<tbody>
		<tr>
		<td><?php echo $entryID; ?></a></td>
		<td><?php echo $entryDate[$entry]; ?></a></td>     <!-- Add imputs from database -->
		<td><?php echo $entryName[$entry]; ?></td>
		<td><?php if ($entryBalanceSheet=="1") echo "Intangible"; else if ($entryBalanceSheet=="2") echo "Tangible"; ?></td>
		<td>&pound;<?php echo $entryValue[$entry]; ?></td>
		<td>##</td>
		<td><?php printf('<a href="FixedAssetAddRate.php?id=%d&amp;action=Add"><img title="Add Depreciation Rate" src="css/button/plus.png"/></a>', $entryID)?>
		<td>##</td>
		<td>&pound;<?php echo $entryValue[$entry]; ?></td>    <!-- change when Depreciation rate is sorted -->
		<td><?php printf('<a href="FixedAssetView.php?id=%d&amp;action=view"><img title="View This Fixed Asset" src="css/button/view.png"/></a>', $entryID)?>
		<td><?php printf('<a href="AccountEntry.php?ID=%d"><img title="Edit This Fixed Asset" src="css/button/edit.png"/></a>', $entryID)?></td>
		</tr>
	</tbody>

<?php }

else { echo "No entries";}?>

Anyway, the table appears blank, and I cant figure it out for the life of me. theres a image attached of what the table looks like.

I know its not a problem with the database of connecting to the database, its defo in the script, i just cant find the problem.

Any help is grately apprieciated

Thanks

[leatherback]

To start off with.. You do not need the whole first section. Second, I do not see why you are doing this in such a complex manner 😃

You could namely do just this:

$NoOfEntries=false; 

$SQL = "SELECT * FROM Entry WHERE UserID = '$userID' AND (EntrySelect=4 AND (EntryBalanceSheet=1) OR (EntryBalanceSheet=2))";

$result = mysql_query($SQL) or die(mysql_error());

$num_rows = mysql_num_rows($result);

if ($num_rows > 0 )
  {
  $NoOfEntries=true; 
  while($row = mysql_fetch_array($resultspointer))
    {
    $rows[] = $row;
    }
  }

// then producing output somewhere else


if ($NoOfEntries === true)
  {
  foreach($rows as $row)
    {
    $sheetinfo = $row['entryBalanceSheet'] =="1" ? "Intangible" : "Tangible";

echo"
  <tbody>
    <tr>
    <td>".$row['entryID']."</td>
    <td>".$row['entryDate']."</td>     <!-- Add imputs from database -->
    <td>".row['entryName']."</td>
    <td>".$sheetinfo."</td>

<!-- etcetra -->

    </tr>
</tbody>";
   }
else 
   { 
    echo "No entries";
   }

[imad_imike]

wow, looking at the way you have done this does make mine look complicated.

I'm guna change it now and ill let you know how I get on.

Thanks a lot

[leatherback]

I just spotted: You will need to create the $rows array before using it [of course]:
add $rows = array(); on top of the script.

Let us know if you run into trouble.

[imad_imike]

Ok, ive simplified like you suggested, but I still have the same problem, Its not showing the results from the query, neither is it echoing 'No entries'.

heres what I got

<?php 

$SQL = "SELECT * FROM User WHERE UserID= '$userID'";
$result = mysql_query($SQL) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
$userID = $row['UserID'];
$userName = $row['UserName'];
$userRegNo = $row['UserRegNo'];
$userPAYE = $row['UserPAYE'];
}

$rows = array();
$NoOfEntries=false;

$SQL = "SELECT * FROM Entry WHERE UserID = '$userID' AND (EntrySelect=4 AND (EntryBalanceSheet=1) OR (EntryBalanceSheet=2))";

$result = mysql_query($SQL) or die(mysql_error());

$num_rows = mysql_num_rows($result);

if ($num_rows > 0 )
  {
  $NoOfEntries=true;
  while($row = mysql_fetch_array($results))
    {
                          $rows[] = $row; 
  } 

  }           




?>
<div id="container">
	<?php
 		displayHeader();
			?>

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

<Table width="100%" frame="below"  //Table Headers
	<tr>
	<td><b>ID</td>
	<td><b>Date Of Aquisition</td>
	<td><b>Description</td>
	<td><b>Type</td>
	<td><b>Cost</td>
	<td><b>Depreciation Rate</td>
	<td><b></td>
	<td><b>Acumulated Depreciation</td>
	<td><b>Net Cost</b></td>
	<td><b>View</td>
	<td><b>Edit</b></td>
	</tr>

  <?php   

if ($NoOfEntries == true)
  {
  foreach($rows as $row)
    {
    $sheetinfo = $row['entryBalanceSheet'] =="1" ? "Intangible" : "Tangible";
    }
    echo"
      <tbody>
        <tr>
        <td>".$row['entryID']."</td>
        <td>".$row['entryDate']."</td>     <!-- Add imputs from database -->
        <td>".$row['entryName']."</td>
        <td>".$sheetinfo."</td>

<!-- etcetra -->

    </tr>
</tbody>"; 
   }
else
   {
    echo "No entries";
   } 
?>

its still showing up exactly the same, a table with just the header and no results.

Its driving me crazy

[leatherback]

Try this code, and post the output:

<?php

$SQL = "SELECT * FROM User WHERE UserID= '$userID'";
$result = mysql_query($SQL) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
$userID = $row['UserID'];
$userName = $row['UserName'];
$userRegNo = $row['UserRegNo'];
$userPAYE = $row['UserPAYE'];
}

$rows = array();
$NoOfEntries=false;

$SQL = "SELECT * FROM Entry WHERE UserID = '$userID' AND (EntrySelect=4 AND (EntryBalanceSheet=1) OR (EntryBalanceSheet=2))";

echo "<p>"$SQL."</p>";

$result = mysql_query($SQL) or die(mysql_error());

$num_rows = mysql_num_rows($result);


echo "<p>"$num_rows."</p>";


if ($num_rows > 0 )
  {
  $NoOfEntries=true;
  while($row = mysql_fetch_array($results))
    {
    echo "-yup-<br />";
                          $rows[] = $row;
  }
echo "<pre>";
print_r($rows);
echo "</pre>";
  }           




?>
<div id="container">
    <?php
        displayHeader();
            ?>

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

<Table width="100%" frame="below"  //Table Headers
    <tr>
    <td><b>ID</td>
    <td><b>Date Of Aquisition</td>
    <td><b>Description</td>
    <td><b>Type</td>
    <td><b>Cost</td>
    <td><b>Depreciation Rate</td>
    <td><b></td>
    <td><b>Acumulated Depreciation</td>
    <td><b>Net Cost</b></td>
    <td><b>View</td>
    <td><b>Edit</b></td>
    </tr>

  <?php   

if ($NoOfEntries == true)
  {

echo 'True noofentries';

  foreach($rows as $row)
    {
    $sheetinfo = $row['entryBalanceSheet'] =="1" ? "Intangible" : "Tangible";

echo"
  <tbody>
    <tr>
    <td>".$row['entryID']."</td>
    <td>".$row['entryDate']."</td>     <!-- Add imputs from database -->
    <td>".$row['entryName']."</td>
    <td>".$sheetinfo."</td>

<!-- etcetra -->

    </tr>
</tbody>";
   }
else
   {
    echo "No entries";
   }

[imad_imike]

I got it, it was the $result variable, I changed the second quesry to $SQL1 and $result1 and its showing the figure now. how would I incorporatre a loop into this table to display all the rows of results??

[leatherback]

What I gave you as code is a loop to show all results. The foreach($rows as $row) should show all rows.

[imad_imike]

look, the resuts are definately outputting now, heres what happened with print_r

[leatherback]

imad imike;10986200 wrote:

look, the resuts are definately outputting now, heres what happened with print_r

ok, good.

Mark the thread as resolved if it is so

[imad_imike]

Thanks so much for your help, apprieciate it so much.

But now I have a problem with the loop 🙁 its only showing the first entry from the database and I know theres at least 5 or 6 in there.

heres the finished result and what it displays

$rows = array();
$NoOfEntries=false;

$SQL1 = "SELECT * FROM Entry WHERE UserID = '$userID' AND (EntrySelect=4 AND (EntryBalanceSheet=1) OR (EntryBalanceSheet=2))";

$result1 = mysql_query($SQL1) or die(mysql_error());

$num_rows = mysql_num_rows($result1);

if ($num_rows > 0 )
  {
  $NoOfEntries=true;
  while($row = mysql_fetch_array($result1))
    {
                          $rows[] = $row; 
  } 

  }           




?>
<div id="container">
	<?php
 		displayHeader();
			?>

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

<Table width="100%" frame="below"  //Table Headers
	<tr>
	<td><b>ID</td>
	<td><b>Date Of Aquisition</td>
	<td><b>Description</td>
	<td><b>Type</td>
	<td><b>Cost</td>
	<td><b>Depreciation Rate</td>
	<td><b></td>
	<td><b>Acumulated Depreciation</td>
	<td><b>Net Cost</b></td>
	<td><b>View</td>
	<td><b>Edit</b></td>
	</tr>

  <?php 
if ($NoOfEntries == true)
  {
  foreach($rows as $row)
    {
    $sheetinfo = $row['EntryBalanceSheet'] =="1" ? "Intangible" : "Tangible";
    }
    ?>
      <tbody>
		<tr>
		<td><?php echo $row['EntryID'] ?></a></td>
		<td><?php echo $row['EntryDate'] ?></a></td>     

		<td><?php echo $row['EntryName'] ?></td>
		<td><?php echo $sheetinfo ?></td>
		<td>&pound;<?php echo $row['EntryValue'] ?></td>
		<td>##</td>
		<td><?php printf('<a href="FixedAssetAddRate.php?id=%d&amp;action=Add"><img title="Add Depreciation Rate" src="css/button/plus.png"/></a>', $row['EntryID'])?>
		<td>##</td>
		<td>&pound;<?php echo $entryValue; ?></td>    <!-- change when Depreciation rate is sorted -->
		<td><?php printf('<a href="FixedAssetView.php?id=%d&amp;action=view"><img title="View This Fixed Asset" src="css/button/view.png"/></a>', $row['EntryID'])?>
		<td><?php printf('<a href="AccountEntry.php?ID=%d"><img title="Edit This Fixed Asset" src="css/button/edit.png"/></a>', $row['EntryID'])?></td>
   </tr>
    <?php 
   }
else
   {
    echo "No entries";
   } 
?>
</tbody>

thanks again if you can help

[leatherback]

well.. You changed something compared to the example..:

foreach($rows as $row)
{
$sheetinfo = $row['EntryBalanceSheet'] =="1" ? "Intangible" : "Tangible";
}

should not have the closing }, that only comes at the end of the loop.

if ($NoOfEntries == true)
  {
  foreach($rows as $row)
    {
    $sheetinfo = $row['EntryBalanceSheet'] =="1" ? "Intangible" : "Tangible";

?>
  <tbody>
    <tr>
    <td><?php echo $row['EntryID'] ?></a></td>
    <td><?php echo $row['EntryDate'] ?></a></td>     
    <td><?php echo $row['EntryName'] ?></td>
    <td><?php echo $sheetinfo ?></td>
    <td>&pound;<?php echo $row['EntryValue'] ?></td>
    <td>##</td>
    <td><?php printf('<a href="FixedAssetAddRate.php?id=%d&amp;action=Add"><img title="Add Depreciation Rate" src="css/button/plus.png"/></a>', $row['EntryID'])?>
    <td>##</td>
    <td>&pound;<?php echo $entryValue; ?></td>    <!-- change when Depreciation rate is sorted -->
    <td><?php printf('<a href="FixedAssetView.php?id=%d&amp;action=view"><img title="View This Fixed Asset" src="css/button/view.png"/></a>', $row['EntryID'])?>
    <td><?php printf('<a href="AccountEntry.php?ID=%d"><img title="Edit This Fixed Asset" src="css/button/edit.png"/></a>', $row['EntryID'])?></td>
   </tr>
    <?php
}
   } 

Also: Note that you do not need to make all these individual calls to <?php and ?> and echo. You can create one echo for all.

[imad_imike]

nice, loop works great now. I'll work on getting the table into 1 echo statement rather than 50 😛. Just trying to work out how to add the print_f column with the buttons because it interferes with the echo statement. anyway, ill figure it out, youve been a great help, thanks again.

Ill change the thread to resolved in 2 mins

Thanks

[leatherback]

No need for printf:

echo "<a href=\"FixedAssetAddRate.php?id=&#37;d&amp;action=Add\"><img title=\"Add Depreciation Rate\" src=\"css/button/plus.png\"/></a>";

Not sure what the $row['EntryID'] is for? Needs to be in there somewhere?

[imad_imike]

great, doing it this way still carries entryID to new next page without the use of $entryID, thanks again

thanks doesnt seem great enough, u basically just created the whole page for me 🙂

but yh, thanks....