Access 2nd row in array

ryland22

I queried my dbase and got a result set that was put into an associative array that looks like this:

"ID" 2, "category" fabric, "color" red
"ID" 3, "category" clothes, "color" green

I want to then assign elements of the array to variables, but I can't figure out how to assign an element that is not in the first row of the array.

I used the following code for $item1:

$query2 = "SELECT * FROM inventory WHERE sale < 3";
$result2 = mysql_query($query2); 
$row2 = mysql_fetch_assoc($result2);

$item1_id = ($row2['ID']);

So $item1_id == 2, my question is how would I assing $item2_id as "3"?

I have tried to use:

mysql_data_seek($result2,1);
$item2_id = ($row2['ID']);

but that does not work. I tried to use the "next" function, but that only moved the array to the next element (from "2" to "fabric") instead of moving to the next row of the array. I tried to use array_slice:

$item2_id = array_slice($row2['ID'], 2);

but that did not work either. I CANNOT FIGURE OUT HOW TO MOVE TO DIFFERENT ROWS OF AN ARRAY!!! Arrgh.

litebearer

Try using the

while ($row = mysql_fetch_assoc($result2)) {
  //do stuff
}

it will loop thru each row for you

ryland22

Yes, that is true, I could use a "while loop" to loop through the array, however when I try to assign a value to a variable, I will end up with the last value of the array assigned. Assume that my array has more than 2 rows in it:

"ID" 2, "category" fabric, "color" red
"ID" 3, "category" clothes, "color" green
"ID" 4, "category" fish, "color" red

And now when I run:

while ($row2 = mysql_fetch_assoc($result2))
{
$item2_id = $row2['ID'];
}

It will result in $item2_id having the value of "4" when I'm trying to assing it a value of "3". Sorry for not giving a better example of the array in my previous post.

So, the question remains: how would I assign "3" from the array to the variable $item2_id?

laserlight

The problem is that your follow-up to mysql_data_seek() is wrong.
You need to do a
$row2 = mysql_fetch_assoc($result2);
again, in order to populate $row2 with new data.

But if you're going to do this repeatedly, then, you might as well loop, and populate an array instead.

ryland22

Laserlight, youu are correct, thank you. But it just seems like there should be an answer like:

$array(column_name, row_number) // gives you that element of the associative array

Isn't there some function within php where I can just specify the exact location of the value I want using the key name of the array and the row number?

If you had an array populated from a dbase query that looked like the following:

"ID" 2, "category" fabric, "color" red
"ID" 3, "category" clothes, "color" green
"ID" 4, "category" fish, "color" red

How would you go about assigning "3" to the variable $item2_id?

Weedpacket

Originally posted by ryland22
Laserlight, youu are correct, thank you. But it just seems like there should be an answer like:

$array(column_name, row_number) // gives you that element of the associative array

There is; you just need to have such an array, first: you don't, yet.

$complete_array = array();
while ($row = mysql_fetch_assoc($result2)) {
$complete_array[] = $row;
}

There you go. Now you can do $complete_array[3]['category'] and stuff like that (Yes, it's [row][column], rather than [column][row], but that's a minor difference and probably a bit more useful.) Note that rows are counted starting from 0.