Hi,
I am currently working pn a PHP script that pulls data from a Mysql database. I want the search results to include my header file which is located @ /home/cpfc/www/ssi/top.html
However when I use
include(\"/home/cpfc/www/ssi/top.html\");
include("/home/cpfc/www/ssi/top.html"); is parsed rather than the file- What gives?
Here is my code below
<?PHP
// Connection Details
$login="";
$pass ="";
$db=mysql_connect("localhost",$login,$pass);
// Select Databse (Squad)
mysql_select_db("squad",$db);
// Original select statement
// Select Table (squad_orig2)
//$sql="select * from squad_orig2";
$sql="select * from squad_orig2";
if((isset($details)) && ($details != ""))
$sql .= " where Name like '$details'";
// Send SQL call to DB
$result=MySQL_query($sql,$db);
while($myrow=MySQL_fetch_array($result))
{
// Grab Data
$name=$myrow["Name"];
$DOB=$myrow["DOB"];
$PlaceofBirth=$myrow["PlaceofBirth"];
$Nationality=$myrow["Nationality"];
$Height=$myrow["Height"];
$Weight=$myrow["Weight"];
$Fee=$myrow["Fee"];
$Position=$myrow["Position"];
$SquadNo=$myrow["SquadNo"];
$International=$myrow["International"];
$Signed=$myrow["Signed"];
$Clubs=$myrow["Clubs"];
$review1 =$myrow["review1"];
$bbsreview =$myrow["bbsreview"];
$Img1 =$myrow["Img1"];
// Display our results
echo "
<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">
<HEAD>
<TITLE>$name CPFC BBS Crystal Palace Squad</TITLE>
<META NAME=keywords CONTENT= crystal palace fc, cpfc, crystal palace, crystal palace bbs, crystal palace football club, Selhurst, Eagles >
<META NAME=description CONTENT= CPFC : Crystal Palace football club unoffical bulletin boards and resources for CPFC>
<LINK rel=stylesheet type=text/css href=http://www.cpfc.org/styles/1.css>
</HEAD>
<BODY bgcolor=#FFFFFF background=http://www.cpfc.org/ubb/bk2.gif topmargin=0 leftmargin=0>
include(\"/home/cpfc/www/ssi/top.html\");
<BR>
<BR>