Jump to content

How to store mysql_fetch_array rows


tomtimms

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.