MySQLdb

Kill Joy g.ricioppo at gmail.com
Sun Nov 22 15:36:09 CET 2009


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


K



More information about the Python-list mailing list