db = MySQLdb.connect(host= "127.0.0.1",
                     user="root",
                     passwd="",
                     db="logindb")
query = db.cursor()

loop= 'true'
while (loop == 'true'):
    name=raw_input("Enter name:")
    username=raw_input("Enter Username:")
    password=raw_input("Enter Password:")
    confirm_password=raw_input("Re-Enter Password:")
    mail=raw_input("Enter E-mail:")
    dob=raw_input("Enter DOB:")
    bloodgrp=raw_input("Enter the bloodgroup:")
    city=raw_input("Enter city:")
    mobile=raw_input("Enter the mobile number:")
    if(password == confirm_password):
        query.execute("INSERT INTO `login` (`username`,`password`) VALUES(%s,%s)",username,password)
        query.execute("INSERT INTO `signup` (`name`) VALUES (%s)",name)
        query.execute("INSERT INTO `signup` (`mail`) VALUES (%s)",mail)
        query.execute("INSERT INTO `signup` (`dob`) VALUES (%s)",dob)
        query.execute("INSERT INTO `signup` (`bloodgrp`) VALUES (%s)",bloodgrp)
        query.execute("INSERT INTO `signup` (`city`) VALUES (%s)",city)
        query.execute("INSERT INTO `signup` (`mobile`) VALUES (%d,)",mobile)
        db.commit()
        print "saved"
    else:
        prnit "Failed"

File "signup.py", line 26
    query.execute("INSERT INTO `signup` (`name`) VALUES (%s)",name)
                                                                  ^
IndentationError: unindent does not match any outer indentation level