# Flash php & MySQL

**URL:** <https://forum.kirupa.com/t/flash-php-mysql/243309>\
**Category:** Uncategorized\
**Created:** [November 5, 2007, 5:14pm UTC](https://forum.kirupa.com/t/flash-php-mysql/243309 "2007-11-05T17:14:12Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![barryw33](https://avatars.discourse-cdn.com/v4/letter/b/a8b319/32.png) [@barryw33](https://forum.kirupa.com/u/barryw33)\
**Post date:** [November 5, 2007, 5:14pm UTC](https://forum.kirupa.com/t/flash-php-mysql/243309/1 "2007-11-05T17:14:12Z")

</div>

Hi noobie here.

I have a motorcross website that amongst other things shows race reports. The site is a static size so I am trying to fit a flash scrolling textbox to show the reports without them spilling outside the website.

I can call a report from the MySQL db with flash and php if I hard code the search variables into the flash (championship, track and date) but I create a list of race reports dynamically from the db and when someone clicks the link I need the race report associated from the link to show up and not a hard coded one.

if that dont make sense(which it probably wont, heres my code)

original php file

```php
<?

require("connect.php");

$count=$_REQUEST['count'];

if($count=='')

    {

        $count=0;

    }

    $sql="SELECT * FROM report ORDER BY mid(date1,7,4) DESC, mid(date1,4,2) DESC, mid(date1,1,2) DESC";

    $rs=mysql_query($sql);

    $num=mysql_num_rows($rs);    

    while ($count<$num)

        {

            

            $championship=mysql_result($rs,$count,"championship");

            $track=mysql_result($rs,$count,"track");

            $date1=mysql_result($rs,$count,"date1");

            $rep1=mysql_result($rs,$count,"rep1");

            $rep_desc=substr($rep1,0,150);

            $by=mysql_result($rs,$count,"user");

            $list="<a href='index.php?mode=full_report&amp;championship=".$championship."&amp;track=".$track."&amp;date1=".$date1."'>".$championship." : ".$track."</a>";

        

            $sql1="SELECT * FROM images WHERE championship = '$championship' AND track = '$track' AND date1 = '$date1' ";

            $rs1=mysql_query($sql1);

            $num1=mysql_num_rows($rs1);

            $i=0;

            if($num1>=1)

                    {

                        while ($i<$num1)

                                {

                                    $image=mysql_result($rs1,0,'image');

                                    $imagefill="<img src='/motorcross-news/images/mximages/thumb/".$image."' alt='' />";

                                    $i++;

                                }

                    }

            else

                    {

                        $imagefill='';

                    }

                

                    ?>

                    

                

                    <div class="race_report">

                        

                        <div class="rep_img"><a href="index.php?mode=full_report&amp;championship=<? echo $championship; ?>&amp;track=<? echo $track; ?>&amp;date1=<? echo $date1;?>"><? echo $imagefill; ?></a></div>

                        

                        <div class="rep_title"><? echo $list; ?></div>

                        

                          <div class="rep_by">By: <? echo $by." ".$date1; ?></div> 

                        

                        <div class="rep_desc"><? echo $rep_desc; ?><span class="rep_more"><a href="index.php?mode=full_report&amp;championship=<? echo $championship; ?>&amp;track=<? echo $track; ?>&amp;date1=<? echo $date1;?>">...More&#8594;</a></span></div>

                    

                    </div>

                    <?

                        if ($rowcount<=3)

                            {

                                echo "<br />";

                            }

                    

            $count++;

            $rowcount++;

            if($rowcount>=5 && $count<$num)

                {    

                    

                     if($count>6 )

                         {    

                            $counted=$count-10;

                            echo "<div class='report_prev'><a href='index.php?mode=reports&amp;count=".$counted."'>&#8592;Previous Reports</a></div>";

                        }

                    

                        echo "<div class='report_more'><a href='index.php?mode=reports&amp;count=".$count."'>More Reports&#8594;</a></div>";

                    break;

                }

            

        }

    if($count>=$num)

        {    

            $newcount=6-$rowcount;

            $count=$count+$newcount;

            $counted=$count-12;

            echo "<div class='report_prev'><a href='index.php?mode=reports&amp;count=".$counted."'>&#8592;Previous Reports</a></div>";

        }

?>

```

the link index.php?mode=full\_report&championship=\<? echo $championship; ?\> etc call links to the index.php page and calls a object class

```php
 <div id="home"><object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="781" height="408" id="templates/textbox1" align="middle">
<param name="allowScriptAccess" value="sameDomain" />
<param name="movie" value="templates/textbox1.swf" />
<param name="quality" value="high" />
<param name="bgcolor" value="#000000" />
<embed src="templates/textbox1.swf" quality="high" bgcolor="#000000" width="781" height="408" name="textbox2" align="middle" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
</object></div>

```

this in turn calls textbox1.swf which has a textbox with dynamic text that has been converted to a symbol and the actionscript in the symbol is

onClipEvent (load) {  
loadVariables(“[http://localhost/motorcross-news/templates/textbox1.php](http://localhost/motorcross-news/templates/textbox1.php)”, this, “GET”);  
}

now if I hardcode the championship, track and date variables into the actionscript then all works fine ie

onClipEvent (load) {  
loadVariables(“[http://localhost/motorcross-news/templates/textbox1.php?championship=Eastern](http://localhost/motorcross-news/templates/textbox1.php?championship=Eastern) Centre&track=Lyng&date1=14-10-2007”, this, “GET”);  
}

but as the original click came from a dynamically crated list of race reports I need the actionscript to be able to pass the variables from the orgimal click to textbox1.php

the code for textbox1.php is

```php

<?PHP
require("connect.php");
$championship=$_REQUEST['championship'];
$date1=$_REQUEST['date1'];
$track=$_REQUEST['track'];
$sql="SELECT * FROM report WHERE championship = '$championship' AND track = '$track' AND date1 = '$date1'";
$rs=mysql_query($sql);
$i=0;
$num=mysql_num_rows($rs);
while ($row=mysql_fetch_array($rs))
        {
            $report=$row("rep1");
        }
        
print "myVar=$report";
?>
 

```

any help would be greatly appreciated

I know I have posted this in flash but I am comfortable with the php and MySQL but I am having trouble passing the variables throught the flash file