This is a rough outline of the series of commands necessary to connect, query and display rows in a table.

try: 
  import MySQLdb
  connection = MySQLdb.connect(host="mysql.aero.und.edu", user="rfillion", passwd="password-goes-here", db="rfillion" )
except:
  print "Could not connect to database."
  import sys
  sys.exit(0)

cursor = connection.cursor(MySQLdb.cursors.DictCursor)

query = 'select * from notes'
cursor.execute(query)

for line in cursor.fetchall():
  id = line['id']
  date = line['date']
  content = line['content']
  print "ID: %i, DATE: %s, CONTENT: %s<br/>" % (id, date, content)

for line in cursor.fetchall():
  print "ID: %(id)i, DATE: %(date)s, CONTENT: %(content)s<br/>" % line

• Google