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

b+ tree
Hi
can every body help me about b+ tree ?(insert & delete)

making web pages for accounts
Hello, I would like to make pages for accounts on my website im making (its not a real website..im j

MySQL Does not UPDATE- SQLString Problem
vb Syntax (Toggle Plain Text) 1. SQL = "UPDATE sampletable SET column1 = 'C1sample1'"

Add weeks in a query?
I have a SQL that summarizes the quantity per week. The weeks that has no value does not exist in th

help finding hacking loopholes
i was attacked by a redirect php injection

my pc is clean of viruses

so i figure that

Cannot Display Array from Select Statement + Login question
Hi,
I'm new to PHP but so far so goog. I was assigend a project and I'm very close to completion.

How to give the privillege for triggers?
Hi,

How to give the privillage for triggers to particular user?

Please let me

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

Mastering Regular Expressions, Third Edition, is available.
The Third Edition of Mastering Regular Expressions is available.

QuoteThis third edition is 5

Simultaneous select/update/insert
Hi

How would I need to go about when 2 users update a single row simultaneous? And how would