[Scenario]

I don't quite know why you're using mysql_store_result() 7 times. That's just utterly pointless. You should be doing a loop like while(mysql_fetch_row_format(string, "|")) and using sscanf to extract the data if you aren't using threaded queries (which I know you're not due to the functions you're using).

Switching to threaded queries makes everything 20x easier in my opinion, plus they're a bit faster since they have the caching function!