mysql_fetch_assoc() help

[AE117]

I have been looking into this and I can find a definite answer.

 

I was wondering if i call a query

 

$query = mysql_query("SELECT * FROM table_name")

$rows = mysql_fetch_assoc($query)

which returns 50 results

 

can I call and echo a certain result. Lets say I want to echo result number 5 of the 50.

 

I have no idea how to go about this so I was just hoping someone could lead me in the right direction.

[Pikachu2000]

Fifth result: SELECT * FROM table LIMIT 4,1

[AE117]

That is exactly what I am try to prevent. I dont want to have to call multiple queries to get a set of results. so if the results is to call the to a table

 

id      color

 

1  green

2  red

3  green

 

and get all the green items. I want to be able to store them in an array and then call from that array the results i need. So in this case the array should hold

key  id    color

[1]    1    green

[2]    3    green

 

then i can call key 2 which would give me the values under that. I just dont know how to do it. I am still looking into it but it appears that arrays and a push statement is on the right track

[Pikachu2000]

That's not even close to how your original post reads, otherwise I wouldn't have suggested it.