ok first of all find out about MySQL cause editing a file with a scrip-language is a little more complicated.
ur data would fit into one table very easy.
then u have to get the idea of php.
its a script on the server. when u eter its url ist not passed on to the clien, but is executed and its output is send to the client as if it was a html/xml file.
to get interaction done php is able to grap the information providid by the get or post method via the http protcol.
if u start up with a simple file, it gonna get clear soon.
the first thin u have to do is surounding all code with ‘<?php' and '?>’.
u will not gonna get big problems with the syntax as it is C style, like actionscript.
try to pu a file there that only outputs something:
[code]<?php
header(“ContentType: application/xml”);
echo “”;
echo “”;
echo “Title Goes Here”;
echo “Link In Here”;
echo “Message Goes Here”;
echo “dc:subjectThe Subject Here</dc:subject>”;
echo “dc:creatorName of User Here</dc:creator>”;
echo “dc:dateLog Date Here</dc:date>”;
echo “”;
echo “”;
?>[/code]
call it whatever.php put i to the sever and view it in ur browser.
u may have recognices the header() thats there because by default a text/html header is sent.
then u may try to use some variables. the ‘.’ is used to combine strings, instead of the ‘+’. u gonna get used to this soon.
[php]
echo “”;
echo “”;
echo “” . $_GET[‘title’]. “”;
echo “” . $_GET[‘link’]. “”;
echo “” . $_GET[‘description’]. “”;
echo “dc:subject” . $_GET[‘subject’]. “</dc:subject>”;
echo “dc:creator” . $_GET[‘creator’]. “</dc:creator>”;
echo “dc:date” . $_GET[‘date’]. “</dc:date>”;
echo “”;
echo “”;
[/php]
and then call the script this way: whaterver.php?title=Hello+World&link= …
then u should be ready to learn a bit of php. if u do so u’ll find out soon that the combination of flash and php will make u able to do a lot of nice things that can’t be done with just flash.
try to read the introduction and the tutorial at: http://php.net/manual
and please read the capters aubout these functions:
http://php.net/mysql_connect
http://php.net/mysql_query
try as well to understand php-arrays
and try to get used to PHPMyAdmin
for now i guess thats enough homework