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

Guixt issue
Hello all,

We are experiencing the following problem with Guixt:

Some transact

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

Need help-Error istream header declaration
Hi Everyone ,

I am having issue with istream declaration. I am new to C programming.
can a

single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

User information
Hi All,
By using t-code SUIM we get all the user details,if suppose we donot have permission t

ereg_replace in Wordpress
Heya - so I'm working on this site: http://world-of-smiles.theportlandco.com/new-patients

The

Session problem?!?
Hello All! I am very new to the php world but I am working on fixing things that a previous programm

I apologise! It's a newbie to PHP feedback form problem!
Hi,

I am a total newbie to PHP. I am also a unemployed and need to get a job. So after 100% r