I'm working on a macromedia flash project and since it can't access databases directly, I'm trying to write a php script to go into an MS access database and retrieve some variables. All it will need to do in php is set variables equal to the values in the database.
If I have a database called database1.mdb, and a table called values that has a field called number1, how can I use php to set a variable equal to the value in field number1 at the first row? I've a php IDE and a server that supports it etc, but I'm lost when it comes to the coding. Can anyone help or point me in the direction of it?
Thanks.
