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

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

Problem writing URL into database
How would I write this into the database?

<?php echo "http://".$_SERVER['SER

insert quotes
Hi,

I have an output like this:
Code: john,18,Cancer
How can I change this to
Code:

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

Working with Global Variables
hi, I'm not really sure why the following code is returning a "Call to a member function getBan

Supress some serveroutput but not all
Hi,

I have a script I'm working on that uses plsql to create and RMAN script, this uses d

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th

Print out contents of to Excel
I have got this script that gathers all the data that I need but I need it to send it to excel inste

Slow data retrieval which requires improvement..please help
I am working on a Help Desk Ticketing system and have a page called MY TICKETS which shows all ticke

GIS appliction help
I found some tutorials in the internet to develop a map application I don't want to use google maps