I'm really to new to MySQL but I've been given the task of getting information from MySQL into Flash.
I'm trying to assign info from MySQL into a Variable in PHP so that Flash can read it.
Whats a simple script so I can assign each database field with a variable?
I only got this far:
<?php
$server = "00.000.000.00"; // Your MySQL server address (usually 'localhost' but can be IP or DNS)
$db_user = "user"; // Your MySQL database username
$db_pass = "password"; // Your MySQL database password
$database = "databasename"; // Your MySQL database name
mysql_connect($server, $db_user, $db_pass) or die ("Database CONNECT Error");
$result = mysql_db_query($database, "SELECT * FROM mytable WHERE id = '$s' ORDER BY date") or die ("Database SELECT Error");
id=$flash_id
Something like that ?
Any help would be much appreciated.
D
