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

help, header() is not working!
Hello, I have this code:


<?php

/**
* @author samoi
* @copyright 200

Extracting URL pointer within XML tag
Hi.

I'm trying to extract text between two quotation marks in XML. For example, I want to ex

Uploading files/images via forms
Hey all, I am building a database for work that will contain some minor data on plant species along

Login Script Issues
I am using a script I got from http://phpsense.com/php/php-login-script.html in order to allow peopl

please help
HTML Code:

Code: <span id="ctl00"><span>

Get to know your fellow coder
I think it's time we got personal around here. There's a lot of code swapping and a few members kno

Upload file!
Ok i have a form..
Code: <form name="form1" method="post" action=&quo

Two warning messages
Quote<b>Warning</b>: mysql_real_escape_string() expects parameter 1 to

Problem!
I have another problem, when i run this code i get this error "Parse error: syntax error, unexp

Mail Script Problems
I have created a PHP mail script. I am having a problem though. In $body i am trying to put two va