# Php mysql

**URL:** <https://forum.kirupa.com/t/php-mysql/41373>\
**Category:** Uncategorized\
**Created:** [January 28, 2004, 11:48am UTC](https://forum.kirupa.com/t/php-mysql/41373 "2004-01-28T11:48:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![blx](https://avatars.discourse-cdn.com/v4/letter/b/f19dbf/32.png) [@blx](https://forum.kirupa.com/u/blx)\
**Post date:** [January 28, 2004, 11:48am UTC](https://forum.kirupa.com/t/php-mysql/41373/1 "2004-01-28T11:48:26Z")

</div>

hi,  
need help with this php code and the actionscript… I have a dj database and i call a php file which is dj.php. The code is below. i tried different actionscript but none were able to display the php file under flash. Is something wrong with my php code?

\<?php require\_once(‘Connections/DJ.php’);

mysql\_select\_db($database\_DJ);

if (empty($\_GET[‘djno’])) { ?\>

\<HTML\>\<HEAD\>\<META HTTP-EQUIV=“REFRESH” CONTENT=“1;URL=dj.php?djno=1”\>\</HEAD\>\</HTML\>

\<?php // header(“Location :dj.php?djno=1”);

exit();

}

$DJno=$\_GET[‘djno’];

//$DJno=1;

$queryDJ="SELECT DJ.NO, DJ.NOM as DJNom, DJ.BIOGRAPHIE, DJ.DISCOGRAPHIE, DJ.PHOTO

```
FROM DJ 

WHERE DJ.NO='".$DJno."' ";

```

$rsqueryDJ=mysql\_query($queryDJ);

$queryDJSoiree="SELECT SOIREE.NO as soireeNo, SOIREE.NOM as soireeNom, SOIREE.DATE, SOIREE.LIEU, SOIREE.FLYER

```
FROM SOIREE, PARTICIPE, DJ 

WHERE DJ.NO = PARTICIPE.DJNO AND PARTICIPE.SOIREENO = SOIREE.NO

AND DJ.NO='".$DJno."' ORDER BY SOIREE.DATE ";

```

$rsquerySoiree=mysql\_query($queryDJSoiree);

$nb = mysql\_num\_rows($rsquerySoiree);

?\>

\<html\>

\<head\>

\<title\>DJ VIEW\</title\>

\<meta http-equiv=“Content-Type” content=“text/html; charset=iso-8859-1”\>

\</head\>

\<body\>

\<?php

$no=null;

echo “\<br\>”;

$row = mysql\_fetch\_array($rsqueryDJ);

echo “NO: “.$row[‘NO’].”\<br\>”;

echo "  
Nom: “.$row[‘DJNom’].”\<br\>\<br\>";

echo "  
BIOGRAPHIE : “.$row[‘BIOGRAPHIE’].”\<br\>\<br\>";

echo "  
DISCOGRAPHIE : “.$row[‘DISCOGRAPHIE’].”\<br\>\<br\>";

echo "  
Photo : ";

if ($row[‘PHOTO’]\<\>"") { ?\>

\<img src="\<?php echo $row[‘PHOTO’]; ?\>"\>

\<?php

} else {echo “Pas de photo”; }

echo “\<br\>\<br\>”;

if ($nb\>1) {

for($i=0;$i\<$nb;$i++)

{

```
$row = mysql_fetch_array($rsquerySoiree);

echo"

```

NoSoiree :".$row[‘soireeNo’]."\<br\>";

```
echo "

```

NomSoiree : “.$row[‘soireeNom’].”\<br\>";

```
echo "

```

LIEU : “.$row[‘LIEU’].”\<br\>";

```
echo "

```

DATE : “.$row[‘DATE’].”\<br\>";

```
echo "

```

FLYER : “.$row[‘FLYER’].”\<br\>";

```
$no=$row['NO'];

echo "&lt;br&gt;"."&lt;br&gt;";

```

}

} else {

echo “Il n’y a pas de soirée pour ce DJ”;

}

?\>

\</body\>

\</html\>

anf this is one of the actionscript i tried

on (release) {  
\_lv= new loadVars();  
\_lv.load(“[http://www.neo-entertainment.com/dj.php?djno=1](http://www.neo-entertainment.com/dj.php?djno=1)”);  
}

thx