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
Email to a friend script problems
I have this send-to-a-friend script with 2 issues:1) When you open the form popup on a particular page, it includes the correct URL for that page (viewable on the popup form). But if you close it, go
Change log of Cost centre change in Plant maintenance order
Hi,
Help With Showing Users On the Index Page
Ive got this code which works just how i want it to.Code: <? $timenow=time();$select = mysql_query("SELECT * FROM users WHERE online > '$timenow' ORDER by id ASC");$num =
Where am I going wrong
Been trying to work this out for hours I have two tables called 'Genres' and 'Films'. Genres contains two columns 'Genre_id' and 'Genre_Name'. Films contains a load of columns, the most important
Optimize Code
Just started getting into the use of cookies. The following code will redirect users to a set URL should they view a preset number of pages. I'm a little concerned with the speed in which this
Adding Different Numbers From MySQL
Basically I have a mysql database with a couple prices as the following:9.999.999.9949.9924.5024.50How can I add these numbers and display the total from a mysql database?
Standard DES encryption script?
Can anybody point me to a tutorial or a short script that shows how to encrypt some text with salt into standard DES?I know about the crypt()-function, but I'm currently writing a PHP script that
Dynamically set AccordianPane Header
I have an accordian on my master page. I'd like to be able to dynamically change the header on different pages. The I can't figure out how to do it or if it's even possible. When I access the
Strange array issue, never happened before.
mysql_fetch_array returns 1 array per call. Generally that's why it is inserted into a while statement. I generally loop through them in a while statement and put them all in a master array so I
very easy question about SQL info
Hello,I think that I have a very easy question.I know how to create a form using php SQL and display the info.BUT the only problem that I have is:In my website, I am linking all the pages with the