Programming is interesting. Sure, it can be very frustrating at times, but generally it is interesting. Especially the slight orgasmic high when you solve a problem that has been bugging you for more than half the day. Sadly, these problems are generally minor. I could have solved this much earlier if I wasn’t so stubborn.
I’m working on an iOS App that needs to retrieve some data from an online SQL server. Using PHP as a middleman for inserting data and retrieving data. The retrieval is a bit of a hassle, or at least I thought it was. I needed to parse the data into XML first, then let the App parse the XML for viewing as a list/table. My problem was the SQL to XML via PHP part. I couldn’t do a full retrieval of topics and posts because of how the data is organized in the users, topics and posts tables. But of course, it wouldn’t have made sense to. Why retrieve everything, when at some point there’s probably going to be too much data? So I broke it up into two separate retrieval functions, one for just a list of topics, another for posts on selected topics, which is what I should have done from the start. Took me long enough to realize how stupid what I was trying to do at first was.
Now for the fun part. *Click Publish, swipe three fingers up, select Xcode*
