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

function to return url
Hi,

Can you guys help me giving a function that takes all the contents in a particular field

1,000 select boxes with 100 options?!
I have 1 drop down select box with 1,000 options.


In some case, there will be 100+ of the

Why will this program not run if the variables are not global?
Hey guys I have a kind of perplexing situation that is probably simple, but I can't seem to understa

=> and <=
So I was digging through some code when I came across the <= operator. This is the first tim

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

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

Problem with an browser game.
Hello,i just joined that great forum and i got php prob,its kinda freaky...anyway i got browser game

an interesting question
Greetings folks, got to ask an interesting question...

let say
i have created a function s

empty() error
Why does

Code: empty($USER_ID = $_SESSION["USER_ID"])
create this error...

Question about the upload of large files
Hi there,

I have a question about the upload of large files, like videos (files generally abo