Firstly sorry for my complete lack of understanding of php/mysql - should have come to rent-a-coder first!!
I have created swf for client the php/mysql is proving difficult. I need the following:
1. I have created a php/mysql that sends the following variables from a swf file to a mysql DB:
name_Last1
name_First1
yourscore
str_date (format: 2004 - 03 - 21)
fire_text1
randomno
I can't give you this swf file - sorry.
2. I have attached the following files which upload to DB, store in DB, and retreive from DB:
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
the flow is = swf with variables - [login to view URL] - [login to view URL] - [login to view URL] - open admin/[login to view URL] - [login to view URL] - getTableData.php.
When I upload the variables from the swf they go to the DB okay, however when retrieved in the [login to view URL] the yourscore and str_date variables are in same box together with the text 'str_date=16' next time I try text is 'str_date=17' and so on.??
I need this sorted out so that str_date=? does not appear and the date is in right text box in the admin file.
This is already being used by the client so there is little room for changing file names or the DB. Can anyone find my bug or rewrite with same file names and variable names.
Please help.
Access code for DB is wizardcbt & wizard65
## Deliverables
Fix the error or rewrite php and mysql, last resort.
## Platform
Windows 2000