Welcome to the Second Life Forums Archive

These forums are CLOSED. Please visit the new forums HERE

Store data from Mysql into list.

Chloe Zinner
Registered User
Join date: 15 Nov 2006
Posts: 21
02-02-2008 12:58
I'm fine with:

SL > PHP > Mysql Storage but i am having trouble on getting data FROM mysql stored into a list for ingame queries.

IE: Products Category Name
3 Fields in MySQL DB > Name, Desc, Price;

When i call it from the body http_request, lets say i have 10 products so it would be like:

prod1 desc1 price1,
prod2 desc2 price2 etc

How do I store it properly in a list in my script for further queries (let's say on clicking NEXT or PREV buttons) without making HTTP requests all the time, but only when on change inventory?

Anyone up to write me a quick sample so i can study the case?

Thx in advance!
Very Keynes
LSL is a Virus
Join date: 6 May 2006
Posts: 484
02-02-2008 13:18
A lot will depend on how you structure your query and the format of the data returned, but basicaly you will use somthing like this

list items = llParseStringKeepNulls(body,[","," "],[]);