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. Link to comment https://forums.phpfreaks.com/topic/223643-mysql_fetch_assoc-help/ 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 Link to comment https://forums.phpfreaks.com/topic/223643-mysql_fetch_assoc-help/#findComment-1156078 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 Link to comment https://forums.phpfreaks.com/topic/223643-mysql_fetch_assoc-help/#findComment-1156081 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. Link to comment https://forums.phpfreaks.com/topic/223643-mysql_fetch_assoc-help/#findComment-1156089 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.