Multiple Records in Flash

[G Rashid]

Hi,

I am trying to connect a database (Access) to Flash via PHP.

Using various tutorials, I have been able to obtain a recordset, which is retrieved as an array.

I have then been able to parse this data into flash by loading any arrays using the 'loadVariables' function.

I have even been able to display 10 records at a time by dynamically duplicating a movie that stores the parsed data.

My problem is that I am unable to retrieve further or previous records by the use of next or previous buttons in Flash. In addition, I am having trouble telling these buttons which set of records to retrieve each time they are clicked.

Has anybody encountered similar problems, and if so, do you have any possible solutions?

Thanks in advance for anyone who cares to help.

Orion13

[Ronald Wernecke]

Hi,
to prtion your data you have to use the php side.

Either you use a select statement, which does it for you (this is possible with mySQL; I dont know if ist is with ACCESS), or you have to portion ist inside the php script.

The Button has to call the php script with a certain parameter, which tells it the position and the amount data to retreive.


keep on flashing

[G Rashid]

Thanks for the reply.

I'm afraid I am not very good with server side technologies at the moment, but I'll give it a go. However, if I don't have any luck with it, I'll probably just stick with PHP and HTML, but thanks anyway!

Gaz.

[Ronald Wernecke]

Hi,
if you can do it with HTML, you can do it with flash!

If you get stuck, youre wellcom to ask.