tomtimms Posted May 14, 2010 Share Posted May 14, 2010 I have a query SQL = SELECT id, fruit FROM account WHERE id >= 0 result = mysql_query(sql); row = mysql_fetch_array(result); it returns ID | Fruit 1 , Orange 2, Orange 3, apple how can I store all the values in fruit ($fruit = $row['fruit]) into an array where it will be separated by a comma? I want to count the number of occurrences Orange shows up and how many times Apple shows up. Link to comment https://forums.phpfreaks.com/topic/201702-how-to-store-mysql_fetch_array-rows/ Share on other sites More sharing options...
Muddy_Funster Posted May 14, 2010 Share Posted May 14, 2010 $row[] is an array, why make another? And have you considered using your SQL query to return what you want rather than just the content info? Link to comment https://forums.phpfreaks.com/topic/201702-how-to-store-mysql_fetch_array-rows/#findComment-1058157 Share on other sites More sharing options...
tomtimms Posted May 14, 2010 Author Share Posted May 14, 2010 I am trying to limit my queries Link to comment https://forums.phpfreaks.com/topic/201702-how-to-store-mysql_fetch_array-rows/#findComment-1058186 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.