hello there, My name is Femi and am a web developer using php. am working on a project. and am having some difficulties. i dont know if you can help me out with it.
The platform am building will receive a text message and the format of the text message is "shoe, 40, bag, 5, tea,1" without quotes, and it may be longer than that. Now how do i get it to my database table and re-arrange them in order, because at the end of each day, the total number of shoe will be calculated and every other one too will be calculated. And also they will be called out individual in the website. The format of the sms will look like this when it arrives in the database (shoe, 4, spoon, 7, led, 9) and so on. how will i arrange them in this table that has Content(which the shoes, spoon, led will go in different rows) and Numbers(which all the number will go in rows allign with the contents the way they came in.)
Content ! numbers shoes 4 spoon 7 led 9
So this what i want to achieve. Thansk you