Php mysql

1

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”);
}

thx