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) }