Feb-07-2019, 06:39 PM
When i go to phpmyadmin and give
When in script this runs
SELECT * FROM jobs WHERE clientID = (SELECT id FROM clients WHERE name = "Άκης Τσιάμης") and YEAR(lastvisit) = 2017 ORDER BY lastvisit DESCi get 2 results as expected.
When in script this runs
elif '=' not in name + year: cur.execute( '''SELECT * FROM jobs WHERE clientID = (SELECT id FROM clients WHERE name = %s) and YEAR(lastvisit) = %s ORDER BY lastvisit DESC''', (name, year) )i get NO results at all. That is what i dont understand, why its behaving differently.