MySql - Loop - CHeck File

[gcclinux]

I am new to python and find it frustrating as python does not seem to conform to any low-level language :-)

I have the following code that woks:

def clean_db():
	cur.execute("SELECT file FROM detection")
	result = cur.fetchall()
	for row in result:
			print(row)

I am trying to do this but it does NOT work

def clean_db():
	cur.execute("SELECT file FROM detection")
	result = cur.fetchall()
	for row in result:
  	   	[i]if os.path.exists(row[0]): [/i]
			print(row[0])

I get the following error:

    print(row[0])
                ^
TabError: inconsistent use of tabs and spaces in indentation

Can someone please advise?

[ThomasL]

As the error message says, your indentation is messed up.
Only use 4 spaces for each indentation, DO NOT USE TABS.
Set up your IDE, text editor, whatever you use, to insert 4 spaces if you press TAB key.

def clean_db():
    cur.execute("SELECT file FROM detection")
    result = cur.fetchall()
    for row in result:
        if os.path.exists(row[0]):
            print(row[0])