mysql and var

[txt3rob]

I have the following i am struggling with i'm not amazing with python.

Any one ideas i hear it's due to a tuple but not got a clue what that is haha!

Code: Select all

#Grab the SMS  to Tweet Contents
cursor.execute ("SELECT * FROM `twitter` WHERE `content` IS NOT NULL AND `messagesent` = 0 LIMIT 1")
# fetch all of the rows from the query
data = cursor.fetchall ()
for row in data :
	sql = "UPDATE `texts`  SET `messagesent` = 1 WHERE id = %s", row[id]
       cursor.execute	(sql)

[karl101]

assuming you have created your cursor with something like:

Code: Select all

cursor = myDB.cursor(cursorclass=MySQLdb.cursors.DictCursor)

and your twitter table has an 'id' column? then try this:

Code: Select all

sql = "UPDATE `texts`  SET `messagesent` = 1 WHERE id = %s"
cursor.execute   (sql,(row['id']))

Karl.

[txt3rob]

cheers for the reply karl