Revision: 8265
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at September 11, 2008 09:31 by stavelin
Initial Code
public function listAllMyPublishedArticles($uid) {
$query="SELECT article_tbl.aid,header,introduction,body,published_state, FROM_UNIXTIME(published_date, '%d/%m/%y %H:%i') as published_date FROM article_tbl, user_has_art_tbl WHERE user_has_art_tbl.uid= $uid AND user_has_art_tbl.aid = article_tbl.aid AND article_tbl.published_state = 1 ORDER BY aid desc";
$query=mysql_query($query)or die(mysql_error());
return $query;
}
Initial URL
Initial Description
Initial Title
from_unixtime sql
Initial Tags
sql, php, textmate, unix, function, query
Initial Language
PHP