Lets say for example ....



___________________________Size of fruit____________
Name of fruit________1________2________3_________ 4
------------------------------------------------------------------------------
Grapes____________$1_______$2_______$5_________$6
Apples____________$2________$4_______$5________$7


Where i get 2 inputs for an example if name_of_fruit was Grapes and the size were to be 4 ... the output would be $6.

Or

When Name of fruit is Apples and price is $5 , the resulting answer would be size = 3.

Would i be able to make this kind of table in MySQL? The normal method doesnt seem to work ... are there alternatives?

Hope someone can help me with this ?