Oh, it's wrong even in your previous code. Your SQL statement - you don't supply gname as argument, but you hardcode gname in it. So it thinks gname is column and understand the sql condition as column name = column gname
it should be
it should be
c.execute("SELECT guardstart FROM guardwatch WHERE name=?", gname)