How do I populate an array with records from a sql table

Hi there! I want to retrieve the records from a table (ex:index1, name1, index2, name2, etc) and load it in an array and then put it in a dropdown list like: name1, name2, etc).

And I don't know how much records will be in the table so I retrieve it through a query and set a global variable in construct to know how much records will I have to show.

I tried using loops and ajax requests but I'm totally lost and I need it desperately to work.

Anyone can help me, please!?

Retrieve it all in one query and use a seperator in between every bit of data. You set that in the php script. As an example i will use "|" as a seperator.

The line in php would look something like this:

echo $row["index1"] . "|" . $row["name1"] . "|" . $row["index2"] . "|" . $row["name2"] . "|" ;

Then in Construct2 you use: system > set variable > (tokencount(AJAX.LastData, "|")

This will count the pieces of data seperated of by the "|"

Then just set the size of the array with that variable.

Retrieve it all in one query and use a seperator in between every bit of data. You set that in the php script. As an example i will use "|" as a seperator.

The line in php would look something like this:

echo $row["index1"] . "|" . $row["name1"] . "|" . $row["index2"] . "|" . $row["name2"] . "|" ;

Then in Construct2 you use: system > set variable > (tokencount(AJAX.LastData, "|")

This will count the pieces of data seperated of by the "|"

Then just set the size of the array with that variable.

Thanks a lot man, that's exactly what I did, after hours of searching around. Really thanks. Now if you could help with one more thing: I created a dropdown list with the array generated with the query, but how do I assign the value of the selected item in the list to a variable? Please, if you could help me with this too, it would be much appreciated!

Nevermind man! Just figured it out. Thanks!

stymphalian

Sorry i didn't see your message earlier. Just got home. Got it working now though?

Setting a variable to the first item in the array would be system > set variable > arrayname.At(0, 0)

This is assuming you have a 2D array..

I have a 2d array with one field on each axis, so my X axis is "name" and Y axis is "ID". I fill the list with items in the X axis. So my list is a list of names. I'd like to assign to a variable, the value of the Y axis related to the X element selected in the list, but I'm having some trouble with it.

EX: The value in index 0 of the list is the value in index 0, Axis X of the Array. and so on. When selecting an item in the list, I'd like to assign to var the value of the Y axis related to that X element in the array.

I dont know if I made myself clear, I'm a little confused right now.. lol