<?
mysql_connect('localhost');
mysql_select_db('foo');
$result = mysql_query(
"select id, email,
date_format(ts,'%W %M %D, %Y %r') as d
from users order by ts");
if($result) {
while($row = mysql_fetch_assoc($result)) {
echo "$row[id] - $row[email] - $row[d]<br />\n";
}
} else {
echo mysql_error();
}
?>