[RESOLVED] How to store values in an array...

denzlite

More newb newbiness -

Let's say I query a DB looking for a certain condition... then I would assume I use a while loop with a php array function...

how do i store those vaules in an array to access later? I need to have an array of those values I think so I can exclude multiple values in a later query....

I think this is how to begin...?

			$query="Select * FROM data WHERE sub_id=$sub_id";
				$data_set=mysql_query($query);
				while($data=mysql_fetch_array($data_set)) {

laserlight

denzlite wrote:
how do i store those vaules in an array to access later?

Something like this:

$query = "Select * FROM data WHERE sub_id=$sub_id";
$data_set = mysql_query($query);
$array = array();
while ($data = mysql_fetch_assoc($data_set)) {
    $array[] = $data;
}

I changed mysql_fetch_array() to mysql_fetch_assoc() on the assumption that you will not actually use the numeric indices of the inner array.

That said, consider using the PDO extension or the MySQLi extension instead.

denzlite wrote:
I need to have an array of those values I think so I can exclude multiple values in a later query....

You may be able to combine the later query and this query into one.

denzlite

Thanks.

How do I get a full array out when it's in the while loop?

$query = "Select * FROM data WHERE sub_id=$sub_id";
$data_set = mysql_query($query);
$array = array();
while ($data = mysql_fetch_assoc($data_set)) {
    $array[] = $data['value'];
} 
print_r ($array);

When I try this (and maybe my other code is wrong) but it's only showing me the last value retrieved with a key of 0....

laserlight

denzlite wrote:
When I try this (and maybe my other code is wrong) but it's only showing me the last value retrieved with a key of 0

That implies that your data table has only one row whose value field contains 0.

denzlite

$query = "Select * FROM data WHERE sub_id=$sub_id";
$data_set = mysql_query($query);
$array = array();
while ($data = mysql_fetch_assoc($data_set)) {
    $array[] = $data['id'];
    echo '  '.$data['name'].'  ';	
}
print_r ($array);

Let's say I have three rows - it will print three 'name's but then the print_r will only show the last id - so if the last 'id' is 167 - print_r returns only: Array ( [0] => 167 ).

It looks like the array here is not cumulative - is that the right word? It's getting overwritten every time through.

So how to construct the array so I have all three ids?

Thanks again
J

laserlight

denzlite wrote:
Let's say I have three rows - it will print three 'name's but then the print_r will only show the last id - so if the last 'id' is 167 - print_r returns only: Array ( [0] => 167 ).

That is logically impossible based on that code.

denzlite wrote:
It looks like the array here is not cumulative - is that the right word? It's getting overwritten every time through.

No, since the syntax is:

$array[] = $data['id'];

Not:

$array = $data['id'];

the latter would indeed overwrite $array on each iteration, but the former appends a new element to the array on each iteration.

denzlite

Ok. Yes, I must have had an error in there. Thanks so much!

laserlight

You're welcome 🙂
Remember to mark this thread as resolved (if it is) using the thread tools.

denzlite

One more question... then how do I use the for each loop to echo out values??

Thanks again!

denzlite

Sorry , nevermind...

http://us3.php.net/foreach