Strange array issue, never happened before.

Posted on 16th Feb 2014 07:03 pm by admin

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 have all the results in one place instead of having to use them on the spot in the while loop. So here is what I generally do:
// If the flag all is set then run an "all" query. else we need to do some specifics on the query instead.
Code: [Select]<?php
if ($flag['all'] == 1) {
$sql = 'SELECT * FROM data_resources';
}else {
$sql = '';
}

#### Run Query ####
$data = array(); //This is the master array that will contain all results.
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query, MYSQL_ASSOC)) {
$data[] = $row;
}
?>
If I echo out the data array inside the while statement it works properly, but when I try to access it outside of the while it doesn't work. What is going on? Normally this works just fine.

Your Answer:

Login to answer

Other forums

The IE or FF detector
Hello Friends,

Problem of today ( we seek for php help ) as following ,

we know all th

use an array from 1 class in a second class
I have a class that adds data to an array

Then I have a second class and I need to check if t

Display last record first.
I need some help how put the last record first and first record last.

Thanks

Code: &am

mysql timestamp manipulation
How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

from

bind error during socket programming
i am kinda new to socket programming. wrote the below code for a server. but getting the bind error

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

What makes a script your own?
If someone finds a login script online, and changes some variable names around and some other minor

Escape Latin Characters
I need to escape latin characters in an xml doc. Example: "é" is escaped to "é". I thoug

Google Map
I have done Google Map Integration for one my project. But for that we need the "latitude and l

present value of sequence?
Hi

Please help me to find out the present value of sequence?

Thanks