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

Multidimensional array problems in $_POST
I'm having trouble with a three-dimensional $_POST array. It starts as a two-dimensional array on th

server trace logs
could any one tell me from where do i get error logs in xMII??I want to check the reason for dtabase

Create multiple (n) arrays
Hi there,

I have the following need:

I have 2 arrays (coming from a databases)

weird problem
last time, i did post a topic concerning why my page sometime will load as blank page when using IE.

Help me with some material on Open Text Overview.
Hi Experts,
Please help me out with some material on Open Text. I have been supporting AP Workf

Default TimeZone
The server I'm working with is hosted in America so all times inserted into the database are coming

Custom CMS
This is a big custom CMS script I'd like to develop and would like some help atleast figuring out wh

Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so

How to make a mail Form secure?
I want to create an email Form on my web site. How can I make the Form secure so the submitted info

Error querying database.
I get the above error when trying to insert some values to a datatable.
Here's the code :