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:

1 2 3 4 5

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

1 2 3 4 5 6

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:

1 2 3

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.

1 2 3 4 5 6

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