# I cant get this tutorial..can someone help

**URL:** <https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195>\
**Category:** Uncategorized\
**Created:** [August 3, 2004, 3:01pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195 "2004-08-03T15:01:46Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![cnl83](https://avatars.discourse-cdn.com/v4/letter/c/c4cdca/32.png) [@cnl83](https://forum.kirupa.com/u/cnl83)\
**Post date:** [August 3, 2004, 3:01pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/1 "2004-08-03T15:01:46Z")

</div>

Im trying to use [http://www.kirupa.com/developer/actionscript/flash\_php\_mysql.htm](http://www.kirupa.com/developer/actionscript/flash_php_mysql.htm)

I tried page one and two, I cannot get it to work for me though.  
The only thing I did different was upload it to my web site instead of local. So the URL was direct (test.php) instead of [http://localhost](http://localhost) stuff…

Can someone give me a hand on this?

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 3, 2004, 5:00pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/2 "2004-08-03T17:00:24Z")

</div>

i get this error on mine

Parse error: parse error, unexpected $ on line 20

all i did was copy the code straight out of the tutorial but put in my own db location username and password

---

<div class="post-metadata">

**Author:** ![cnl83](https://avatars.discourse-cdn.com/v4/letter/c/c4cdca/32.png) [@cnl83](https://forum.kirupa.com/u/cnl83)\
**Post date:** [August 3, 2004, 5:02pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/3 "2004-08-03T17:02:01Z")

</div>

I dont get that, but its not pasting into my text field like its soppose to.

---

<div class="post-metadata">

**Author:** ![CyanBlue](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/cyanblue/32/175_2.png) [@CyanBlue](https://forum.kirupa.com/u/CyanBlue)\
**Post date:** [August 3, 2004, 5:04pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/4 "2004-08-03T17:04:26Z")

</div>

As I was saying, post your own code, both of you…  
You get better chance of somebody helping you with that… 🙂

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 3, 2004, 5:11pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/5 "2004-08-03T17:11:59Z")

</div>

\<?php  
[//read.php](https://read.php)  
//prints contents of content column where filename = $file

if($file) {  
$link = mysql\_connect(mysever, username, pw)  
or die("\<b\>error\</b\>: failed to connect to database");

$query = “SELECT content FROM files WHERE filename=’$file’”;  
$result = mysql\_query($query)  
or die("\<b\>error\</b\>: failed to execute query \<i\>$query\</i\>");

mysql\_close($link);

$desiredContent = mysql\_fetch\_array($result, MYSQL\_ASSOC);

mysql\_free\_result($result);

print “content=$desiredContent[content]”;  
?\>

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 3, 2004, 5:12pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/6 "2004-08-03T17:12:31Z")

</div>

the only thing different in my file that is online is that i have the myserver, username, pw filled in

---

<div class="post-metadata">

**Author:** ![CyanBlue](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/cyanblue/32/175_2.png) [@CyanBlue](https://forum.kirupa.com/u/CyanBlue)\
**Post date:** [August 3, 2004, 5:15pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/7 "2004-08-03T17:15:25Z")

</div>

If you use PHP tag, it’d be whole lot easier to read your code…

The only thing I can see at the moment is this line…

```php

$link = mysql_connect(mysever, username, pw)

```

If mysever, username and pw are the strings, it has to be this…

```php

$link = mysql_connect("mysever", "username", "pw")

```

and it had to be this if they are variable…

```php

$link = mysql_connect($mysever, $username, $pw)

```

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 3, 2004, 5:21pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/8 "2004-08-03T17:21:49Z")

</div>

ya that parts cool…

line 20 is “?\>” if i am not mistaken…there is no $ so i dunno whats up with that

---

<div class="post-metadata">

**Author:** ![CyanBlue](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/cyanblue/32/175_2.png) [@CyanBlue](https://forum.kirupa.com/u/CyanBlue)\
**Post date:** [August 3, 2004, 5:29pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/9 "2004-08-03T17:29:05Z")

</div>

Well… Another one is that the script contains ‘{’ but there is no ‘}’, hence you get error message on line 20…

I can’t help you much cuz I do not understand what ptolemy wanted to achieve with that PHP script…(I am not good at PHP either and I have no idea what that $file is supposed to be…)

Why don’t you contact the author to see if he can help you??? I think that’s your best bet… 😉

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 3, 2004, 5:33pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/10 "2004-08-03T17:33:03Z")

</div>

that } helped my problem

thanks cyan…

why is it almost every tutorial i do i find some typo 😛

---

<div class="post-metadata">

**Author:** ![CyanBlue](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/cyanblue/32/175_2.png) [@CyanBlue](https://forum.kirupa.com/u/CyanBlue)\
**Post date:** [August 3, 2004, 5:39pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/11 "2004-08-03T17:39:51Z")

</div>

Oh, come on… They were just trying to help… 🙂

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 4, 2004, 3:42pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/12 "2004-08-04T15:42:43Z")

</div>

my php seems to be working fine…if i run it by itself i get no errors

```php
 
<?php
//read.php 
//prints contents of content column where filename = $file
if ($file) {
$link = mysql_connect("dbhost", "login", "pw")
			or die("<b>error</b>: failed to connect to database");
$query = "SELECT content FROM files WHERE filename='$file'";
$result = mysql_query($query) 
			 or die("<b>error</b>: failed to execute query <i>$query</i>");
mysql_close($link); 
$desiredContent = mysql_fetch_array($result, MYSQL_ASSOC);
mysql_free_result($result);
print "content=$desiredContent[content]";}
?>

```

and then on my flash file is

```auto
onClipEvent (load) {
loadVariables("[http://www.mydomain.com/test/read.php?file=testfile](http://www.mydomain.com/test/read.php?file=testfile)", this, "GET");
}

```

but its not reading the data from the database  
does anything look wrong here or is it something with my db

---

<div class="post-metadata">

**Author:** ![CyanBlue](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/cyanblue/32/175_2.png) [@CyanBlue](https://forum.kirupa.com/u/CyanBlue)\
**Post date:** [August 4, 2004, 4:05pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/13 "2004-08-04T16:05:25Z")

</div>

Okay… You have this script…

```php

<?php
	//read.php 
	//prints contents of content column where filename = $file
	if ($file)
	{
		$link = mysql_connect("dbhost", "login", "pw")
			or die("<b>error</b>: failed to connect to database");
		$query = "SELECT content FROM files WHERE filename='$file'";
		$result = mysql_query($query) 
			or die("<b>error</b>: failed to execute query <i>$query</i>");
		mysql_close($link); 
		$desiredContent = mysql_fetch_array($result, MYSQL_ASSOC);
		mysql_free_result($result);
		print "content=$desiredContent[content]";
	}
?>

```

What do you get when you type ‘[http://www.mydomain.com/test/read.php?file=testfile](http://www.mydomain.com/test/read.php?file=testfile)’ from the IE???

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 4, 2004, 4:07pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/14 "2004-08-04T16:07:07Z")

</div>

error: failed to execute query SELECT content FROM files WHERE filename=‘testfile’

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 4, 2004, 4:08pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/15 "2004-08-04T16:08:04Z")

</div>

dont i need something to select the database somewhere?

mysql\_select\_db(“database”,$link); or something

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 4, 2004, 4:13pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/16 "2004-08-04T16:13:20Z")

</div>

when i type that url it just shows up

**error** : failed to execute query _SELECT content FROM files WHERE filename=‘testfile’_

---

<div class="post-metadata">

**Author:** ![CyanBlue](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/cyanblue/32/175_2.png) [@CyanBlue](https://forum.kirupa.com/u/CyanBlue)\
**Post date:** [August 4, 2004, 4:17pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/17 "2004-08-04T16:17:13Z")

</div>

Indeed, you do need to add this line…

```php

mysql_select_db("database name", $link);

```

> 

when i type that url it just shows up a blank page

You just said that you were getting an error message… Make up your mind… 😛

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 4, 2004, 4:23pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/18 "2004-08-04T16:23:24Z")

</div>

when i add in the mysql\_select and run that url it shows up

content=test1

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 4, 2004, 4:23pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/19 "2004-08-04T16:23:59Z")

</div>

well i didnt at first and then i did i dont know what happened

---

<div class="post-metadata">

**Author:** ![sizzle](https://avatars.discourse-cdn.com/v4/letter/s/d2c977/32.png) [@sizzle](https://forum.kirupa.com/u/sizzle)\
**Post date:** [August 4, 2004, 5:04pm UTC](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195/20 "2004-08-04T17:04:02Z")

</div>

ya i added the mysql\_select and i also took the loadVariables and put it on my first frame rather than on the movie clip  
and it works great now

thanks again cyan 😃

[Next page](https://forum.kirupa.com/t/i-cant-get-this-tutorial-can-someone-help/118195.md?page=2)