On roster there are this "Last Update", how can i get this on another site?

I can find it in the database, but i cant get the value out.

Here is my code:
(i have filled the host, name, user and pass in my code there is online)

Code: Select all

<?php
$db_host   = "host";
$db_name   = "name";
$db_user   = "user";
$db_passwd = "pass";


$roster = mysql_connect($db_host, $db_user, $db_passwd);

mysql_select_db('$db_name', $roster);

$date = mysql_query('SELECT `update_time` FROM `roster_guild`');

echo $date

?>

The result is: Resource id #3

What goes wrong?

Your forgot mysql_fetch

mysql_query returns a resource id, not data

Code: Select all

<?php
$db_host   = "host";
$db_name   = "name";
$db_user   = "user";
$db_passwd = "pass";


$roster = mysql_connect($db_host, $db_user, $db_passwd);

mysql_select_db('$db_name', $roster);

$result = mysql_query('SELECT `update_time` FROM `roster_guild`');

$date = mysql_fetch_array($result);

echo $date[0]

nice, thanks.

Another question, this is the timeformat i got.
2007-07-25 19:48:00

can i get the timeformat like this: 25-07-2007 19:48 or like this 25 jul 2007 - 19:48

can it be done?

Yes, pass the result through date()
http://us3.php.net/date

Code: Select all

<?php
$db_host   = "host";
$db_name   = "name";
$db_user   = "user";
$db_passwd = "pass";


$roster = mysql_connect($db_host, $db_user, $db_passwd);

mysql_select_db('$db_name', $roster);

$result = mysql_query('SELECT `update_time` FROM `roster_guild`');

$date = mysql_fetch_array($result);

echo date('FORMAT',strtotime($date[0]));

Thanks Zanix, its works fine.