here you are inserting one row for every fruit, means if u add more that one it will not add into the number but create the multiple rows it is better to first combine the different fruits using ID for each using GROUP BY