Values disappear from my array :( HELP!
Posted on
16th Feb 2014 07:03 pm by
admin
hey all, I have a lil mysql/php/apache script that queries a database
and pulls put 5 integers.
These 5 integers are then displayed in an HTML table
Did you know?Explore Trending and Topic pages for more stories like this.
Code: [Select]<?php
$i=0;
global $Val_Store;
while ($i < $num) {
$f1=mysql_result($result,$i,"Changes");
$f2=mysql_result($result,$i,"Disposition");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
</tr>
<?php
$Val_Store[i] = $f1;
$i++;
echo $Val_Store[i] . "-> Val_STORE" . $i . "<br />";
}
This is just a snippet.
But what is happening is:
A while loop is going through the rows of results obtained from the query, placing the values in temporary variables f1 and f2 (f1 are my integers of interest), and using f1 and f2 to fill the HTML table like this:
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
BUT what i am also doing is storing the temporary values in f1 in the array $Val_Store
Code: [Select]$Val_Store[i] = $f1;
$i++;
And then printing them ....
Code: [Select]echo $Val_Store[i] . "-> Val_STORE" . $i . "<br />";
Leaving me with
84-> Val_STORE1
114-> Val_STORE2
99-> Val_STORE3
77-> Val_STORE4
5-> Val_STORE5
WHICH IS SUPER!
BUT if i try executing the following code in other sections of my script....
Code: [Select]<?
echo "DEBUG " . $Val_Store[2] . " DEBUG";
?>
...the arrays appears to be empty. Surely it should have spat out element number 2!!
Output:
DEBUG DEBUG
^
Can anyone help me keep my array elements??
Many Thanks
No comments posted yet
Your Answer:
Login to answer
151
54
Other forums
why this query can delete duplicates ?
why this query can delete duplicates ? Anybody can give me the detailed explanation ?
Tha
Warehouse Management
Hi,
On our system, we have two storage locations ( A and B ) where A is the main factory
Filling gaps in dates
So i'm doing a query for sales data and my return array looks like this
('date' => '20
Users and Groups with PHP Classes
Hi,
I have setup what I hope to be a good working User class. Now I want to introduce group m
Format timestamp from mysql
When I tried this:
Code: date("m/d/Y H:i A", $row['timestamp'])
I got 12/31/1969 18:
highlighting search terms
well, I started this in the regular PHP section, but it no longer fits there. Suffice it to say, I'm
Add weeks in a query?
I have a SQL that summarizes the quantity per week. The weeks that has no value does not exist in th
Undefined Variable: PHP_SELF, pls help
Hi,
Im a newbie on PHP / MySQL programming and Im running a script to search one field on my
newbie question
Hi out thereIm totaly new in this forum and to .net and vb so here is a totaly newbie question.I wan
Export hangs
Hi all, please help
I have a Oracle 10.2.0.3.0 database. When I want to query the dba_segmen