I have a db with names and corresponding values to the names. I also have a php code to display it all, pulling the info from the db. Now this isn't all very hard, but here's my question....
Per name, I've got up to three values and I would like to let php look for only the lowest value and display only that value. So if it were possible, I need to be able to insert the three values per field in the db and then have a code to get the lowest one, or I need to have three fields with the three values and let php get the lowest one out of those. The only problem there, is that the names per set of values must be the same, though I cannot add in the same name twice in the db.
Another thing... the values are now set to 'numeric float', as I need to multiply the lowest value with another set value. The only way (so far I've found then...) is to do that with float.
Can somebody help me out or at least point me in the right direction? I've searched for hours, but I just don't know where to look for.
Thank you in advance!