Dynamic sites - <title> change

TheSameFace

Hi, how can I change the <title>???</title> on a dynamic page. My site is build using php and mysql DB.
Thnx

Please, if you have an example for this case send me also the URL.

jpmoriarty

You use php...

either:

or echo "<title>".date("l")."'s page</title>";

will out put "Monday's page", "Tuesday's page" etc as the title.

TheSameFace

I have a mysql database with the brief description of private accommodation properties. So, every property has it's own name (Family Cusack self-catering accommodation). Is it possible to out put the field "title" from the DB into the <title>Family Cusack ...</title> in the the <head> section?

jpmoriarty

just in the same way you'd put it into your main page.

so it would be something along the lines of:

<title>

<?php echo $row["title"] ?>

</title>

Assuming that the $row array contained the results from your query.

TheSameFace

Hm, it's doesn't work! I don't know why?!? I did everything you've said, but the title is now blank, without any output.
What could go wrong?

jpmoriarty

ah now hold on a second. You'll notice i said

Assuming that the $row array contained the results from your query.

. What i've given you wont work on it's own - you need to establish a connection to the database, run a query to return the values that you need, and then take those results and add them to an array. THEN you can use what i've given you to take the results from the array and put them into your title.

I dont have my code book with me to explain all the above steps to you, but sugegst that you check out www.php.net and read up about connecting to mysql - all the info is there, and it's just being lazy if you ask people to rewrite it for you here without even bothering to read up about it yourself! If you have any problems then come back by all means.

If you're struggling with this i'd also suggest you get a book - I use "web development with PHP and MySQL" by luke someone and laura welling (or laura someone and luke welling, cant remember which) - it's a very good book and it explains everything well.

TheSameFace

John, thank you very much for the help! Yes, I know that I have to struggle also alone with problem and can't expect from anybody to resolve the problem for me! Thnx

jpmoriarty

Youll need something along the lines of:

<?
@ $db = mysql_pconnect("[i]sqlserver[/i]", "[i]user[/i]", "[i]password[/i]");
  if (!$db)
  {
    echo "<p>Could not connect to database - please try again later.</p>";
  }
  mysql_select_db("[i]dbname[/i]");
  $query = "select * from [i]table[/i]";
  $result = mssql_query($query);
  $num_results = mssql_num_rows($result);

for ($i = 0; $i < $num_results ; $i++)
{
  $row = mssql_fetch_array($result);
  echo $row["[i]column title[/i]"]
}
?>

That wil connect you to the server, select the database, run the query and add the results to an array.