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 Like 54 Dislike
Previous forums Next forums
Other forums

Issues: PHP Forms -Clearing
I've tried looking online before actually asking for help, but I've been looking for about the past

Table trouble
i have been reading the forum for a few weeks and decided to join. i like the format and the advice

Date Question
I'm using the TIMESTAMP() function within mysql to set the date/time for certain events. However, ho

Transferring session variables into MySQL
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statem

bit of help needed
Im about to sort out my registration page for my website by customising a "registration" s

frames get header location..
i have two frames, one top, one bottom. how do i do a form on the bottom frame that gives me the ur

Two fgetcsv related questions ;D
First of im trying to get a file from a merchants server but the directory is protected, I know the

apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Formatting echo from database
So I have a database that stores First and last names, then echos them back to a website, as of now

Help with page encoding issue and weird characters
I'm trying to write a screen scraper and when I pull out the lines of the html file that I'm interes

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash