[font=Arial][size=2]I thought I might avail of your offer for some help on your tutorial “Use Flash with PHP and mySQL”[size=1] [/size][/size][/font][font=Arial][size=2][size=1][size=2]http://www.kirupa.com/developer/actionscript/flash_php_mysql.htm[/size][/size][/size][/font]
[font=Arial][size=2][size=1][size=2]I am not returning any text from my database into my textfield (with the variable name ‘content’) and wonder if you can locate anything obvious in the process I have done.[/size][/size][/size][/font]
[font=Arial][size=2][size=1][size=2]I am using phpmyadmin remotely[/size][/size][/size][/font]
[font=Arial][size=2][size=1][size=2][color=#800000]my mySQL database table is called ‘files’ and my database is called ‘myweb318235_colum’
I have two files in the table[/color][/size][/size][/size][/font]
[font=Arial][size=2][size=1][size=1][color=#800000]Host: lalalalala.com
Database : bababababa_baba
Generation Time: Jan 03, 2005 at 10:28 PM
Generated by: phpMyAdmin 2.5.4
SQL-query: SELECT * FROM files LIMIT 0, 30; [/color][/size][/size][/size][/font]
[color=#800000]filename [/color] [color=#800000]content [/color] [color=#800000]testfile[/color] [color=#800000][BLOB - 36 Bytes][/color] [color=#800000]testfile2[/color] [color=#800000][BLOB - 61 Bytes][/color]
[font=Arial][size=2][size=1][size=1] [/size][/size][/size][/font]
[font=Arial][size=2][size=1][size=1] [/size][/size][/size][/font]
[font=Arial][size=2][color=#000080]my flash files are called bigphpmysqltest.fla and bigphpmysqltest.swf [/color][/size][/font]
[font=Arial][size=2][color=#000080]in bigphpmysqltest.swf I have the dynamic text field with variable = content which is saved amovieclip with this actionscript[/color][/size][/font]
[font=Arial][size=2][color=#000080]onClipEvent (load) {
loadVariables(“read.php?file=testfile”, this, “GET”);
}
[/color][/size][/font]
[font=Arial][size=2][color=#008080]the php file is called ‘read.php’[/color][/size][/font]
[font=Arial][size=2][color=#008080]<?php[/color][/size][/font]
[font=Arial][size=2][color=#008080]if($file) {
$link = mysql_connect(“hostname”,“username”,“password”,“databasename”) or die (“didn’t connect to mysql”);
$query = “SELECT content FROM files WHERE filename=’$file’”;
$result = mysql_query($query)
or die("<b>error</b>: failed to execute query <i>$query</i>");[/color][/size][/font]
[font=Arial][size=2][color=#008080] mysql_close($link);[/color][/size][/font]
[font=Arial][size=2][color=#008080] $desiredContent = mysql_fetch_array($result, MYSQL_ASSOC);[/color][/size][/font]
[font=Arial][size=2][color=#008080] mysql_free_result($result);[/color][/size][/font]
[font=Arial][size=2][color=#008080] print “content=$desiredContent[content]”;
?>[/color][/size][/font]
[font=Arial][size=2][color=#008080][/color][/size][/font]
[font=Arial][size=2][color=#008080][size=+0]files [/size][size=+0]is the table in the database[/size][/color][/size][/font]
[font=Arial][size=2]It just doesn’t work unfortunately - I have been intouch to my server people to check if my register_globals was on but they couldn’t help.[/size][/font]
[font=Arial][size=2]Unfortunately I am a very novice beginner in this and if nothing is obvious in the above, how would I use $HTTP_POST_VARS into the php file? [/size][/font]
[font=Arial][size=2]I would so appreciate your help![/size][/font]
[font=Arial][size=2]Thanks in advance.[/size][/font]
[font=Arial][size=2]CollyK[/size][/font]
