[Resolved] Creating dynamic page titles

lizzyd

Hiya!

I'm just having a little trouble making my page titles dynamic. Can anyone have a look at the code below and tell me what's wrong with it?


<head>
<?php
include ("misc.php");

$connection = mysql_connect($host,$user,$password)
	or die ("Couldn't connect to server");

$db = mysql_select_db($database,$connection)
	or die ("Couldn't select database");


//Select information about the chosen hotel
$query = "SELECT EstablishmentName,Town,County FROM hotel WHERE Hotel_Id='".$_GET['Hotel_Id']."'"; 

$result = mysql_query($query)
	or die ("Couldn't execute query");

?>

<title><?php echo $EstablishmentName . ", " . $Town . ", " . $County . ", UK"; ?></title>


</head>

The Hotel_Id is the only information i'm passing in the url. Is there some rule about what i can include inside the head tags that i don't know about? i'd be grateful if someone could maybe point me in the direction of a tutorial or something! thanks very much in advance!

lizzyd

cahva

After result, add:

list( $EstablishmentName,$Town,$County )=mysql_fetch_row($result);

..So you forgot to fetch the result. This works also:

<?php
//Select information about the chosen hotel
$query = "SELECT EstablishmentName,Town,County FROM hotel WHERE Hotel_Id='".$_GET['Hotel_Id']."'"; 

$result = mysql_query($query)
    or die ("Couldn't execute query");

$row=mysql_fetch_array($result);

?>


<title><?php echo $row['EstablishmentName'] . ", " . $row['Town'] . ", " . $row['County'] . ", UK"; ?></title>

lizzyd

whoops - of course!! sorry for being so stupid, cahva - thanks so much for replying!

lizzyd