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

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Simple MySQL script is not working
Hey guys,

Just familiarizing myself with PHP and MySQL. I am following along in the O'Reilly

PHP Surveys
I really would like some advice.

If you have a client come to you asking for a survey to be d

urldecode question
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?

A Few Questions
Hi, I want to ask a few questions that I can't seem to find..

1) I'm creating a "shortcu

if description does not contain the following words
Hello everyone,

I am parsing a MS Excel (.xls) file and adding it's content to a mySQL databa

Blank record injected into database
I always found several blank records inside my database, although $SESSION is required to insert the

pass form variables straight to email, no database required?
hello all,

im working on this form...

http://www.adobedayevents.com/project_request/pr

Displaying image from database
Hi,

I've got a site where that's got a database behind it. Currently it has loads of items in

Creating a db with a query
Hello everyone.
I'm having troubles creating a db with a query.
I'm reading a book called PHP

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