so before I will do finance, I've wanted to build very simple site, where you could register, login and save in database how many times you've clicked a button. Problem is that I can't pass an argument, counter of clicks into site from database, when I perform this in application.py:
klik=db.execute("SELECT clicks FROM dane WHERE nick = :nick",nick=request.form["nick"])
return render_template("zabawa.html",klik=klik)
then in zabawa.html I have this line of code: {{klik}}
in h2 paragraph
but the output on site is: [{'clicks': 0}]
and I want only 0.
Table 'dane' has columns nick,password,email,id and clicks of course.
I would appreciate any kind of help.