func GetTotalCount() *sql.Rows {
query := "SELECT count(id) AS count FROM content"
return sqlmodel.Query(query)
}
func CheckUserID(contentID int, userID uint32) *sql.Rows {
query := "SELECT id FROM content WHERE id=? AND userID=?"
return sqlmodel.Query(query, contentID, userID)
}
func GetGuest(offset, perpage int) *sql.Rows {
query := "SELECT content.id,content,content.userID, username,time FROM content,user WHERE content.userID=user.id"
query += " ORDER BY time DESC LIMIT ?, ?"
return sqlmodel.Query(query, offset, perpage)
}
