AE117 Posted January 7, 2011 Share Posted January 7, 2011 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. Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted January 7, 2011 Share Posted January 7, 2011 Fifth result: SELECT * FROM table LIMIT 4,1 Quote Link to comment Share on other sites More sharing options...
AE117 Posted January 7, 2011 Author Share Posted January 7, 2011 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 Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted January 7, 2011 Share Posted January 7, 2011 That's not even close to how your original post reads, otherwise I wouldn't have suggested it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.