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

PHP Code:

$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]

PHP Code:

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.

PHP Code:

$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,

PHP Code:

<? 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.

PHP Code:

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


[vietkieu_cz]

PHP Code:

<? 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.