in my php5 code i want to use the UNIX_TIMESTAMP function to convert a datetime to a unix timestamp without using php code to convert as i believe this way is quicker but how do you then get the unix timestamp out of the rowset ie how to index into the rowset to get the integer unix timestamp out
Aşağıda veritabanı şeması bir özeti
age int(5)
user varchar(256)
created timestamp CURRENT_TIMESTAMP
$query="SELECT user, UNIX_TIMESTAMP(created) FROM accounts WHERE age='$age'" ;
$result = mysql_query($query) or die ('Error querying domain');
while($row = mysql_fetch_array($result))
{
$callerid = $row['callerid'];
$created_ts = $row['created'];
etc....