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

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

Your Answer:

Login to answer

Other forums

php/mysql problem
Hey all,

Problem: im trying to setup a shop where people can use a drop-down list to select t

Customizing message/behavior
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli

Bar charts using Graphical Framework.
I am using Graphical Frameworks(GFW) to create a chart Graphic . There is no problem with the data d

Redistributing dependent dlls
Hai all ,

I have created an application in VC++ using VS2008 in a development machine which r

Send inserts to mysql thru port 80
Hi!

I have an application that must do some inserts in a mysql db. This db is behind a firewa

Problem in OnClientClick and OnClick sync
Hi,Strange and irritating problem: I have below button declaration in markup of the aspx page:

update sql when refresh - php
hi
I have made a table (attachement)

the users can update the sql database using + or x bu

Database/Table Collation
What is the Database, and table collations used for? i don't understand what there used for since co

Simple MySQL query...
Hello,
How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ag

Compare user input to flat file data
Help...Am a complete newbie to programming so my code is prolly quite long. Am trying to verify a us