samedi 30 septembre 2017

MySQL, PHP, extracting and formatting multiple values from on database field

I am a beginner and got stuck. Any help will be very much appreciated.

I have a text field in the database, the values in the field are as follow, i.e.: "John: 20; Dan: 30; Greg: 80; Sam: 66; Coco: 97;" this all in one field.

The result that I would like to get is as follows: John is 20 years old Dan is 30 years old Greg is 80 years old

Thank you




Aucun commentaire:

Enregistrer un commentaire