MySQLdb

[Gerald Walker]

Kill Joy wrote:
> Hi all.
> 
> I have a mod_python script with two query:
> 
> 	cursor = db.cursor()
> 
> 	sql = 'SELECT * FROM users where username=\'' + username +'\''
> 	cursor.execute(sql)
> 	result = cursor.fetchall()
> 	num =  int(cursor.rowcount)
> 
> 	if num == 0 :
> 		sql2 = 'insert into users values (null, \'' + username + '\', \'' +
> password +'\', \'no\',\'fdfdf\')'
> 		cursor.execute(sql2)
                db.commit()
> 		warning = "Registration ok"
>
> 	else :
> 		warning = "EXIST!"
> 
> The first query is executed... but not the second. It doesn't insert.
> Why?
> I'm a newbie... sorry.
> 
> Many thanks.
> 

I added db.commit() after cursor.execute(sql2).