how to Pass the timestamp into the vbdate() function to return a readable date????

[vietkieu_cz]

I would like to Select time edited by xxx to show them on my custom page
i've tried


$query = "SELECT dateline FROM post WHERE postid = 2";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo " {$row['dateline']}";
}

but it shows something like 1160411620 not Last edited by vietkieu_cz : Today at 5:16pm. Reason: example time

thanks

[nico_swd]

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo vbdate('dS M Y H:i:s', $row['dateline'], true)
}


EDIT:

The loop isn't necessary if you want to fetch one row only. You can do this instead.

$query = "SELECT dateline FROM post WHERE postid = 2";
$result = mysql_query($query);
$postinfo = mysql_fetch_array($result);

echo vbdate('dS M Y H:i:s', $postinfo['dateline'], true)

[vietkieu_cz]

This is my php file,


<? include 'includes/config.php';

$conn2 = mysql_connect(
$config['MasterServer']['servername'], $config['MasterServer']

['username'], $config['MasterServer']['password']);

//Chon CSDL de lam viec
mysql_select_db(
$config['Database']['dbname'], $conn2)
or die("Cannot connect.");

$query = "SELECT dateline FROM post WHERE postid = 2";
$result = mysql_query($query);
$postinfo = mysql_fetch_array($result);

echo vbdate('dS M Y H:i:s', $postinfo['dateline'], true)

mysql_close($conn2);
?>

it shows
Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in C:\AppServ\www\354\test.php on line 19

what did i do wrong?

[nico_swd]

My bad, I forgot a semicolon at the end of this line.


echo vbdate('dS M Y H:i:s', $postinfo['dateline'], true);

[vietkieu_cz]

<? include 'includes/config.php';

$conn2 = mysql_connect(
$config['MasterServer']['servername'], $config['MasterServer']

['username'], $config['MasterServer']['password']);

//Chon CSDL de lam viec
mysql_select_db(
$config['Database']['dbname'], $conn2)
or die("Cannot connect.");

$query = "SELECT dateline FROM post WHERE postid = 2";
$result = mysql_query($query);
$postinfo = mysql_fetch_array($result);

echo vbdate('dS M Y H:i:s', $postinfo['dateline'], true);

mysql_close($conn2);
?>
still not work


Fatal error: Call to undefined function: vbdate() in C:\AppServ\www\354\test.php on line 17

[nico_swd]

Include global.php.