<style>
.indent-lvl-1 { margin-left:20px; display:block; }
</style>
<p class="code-example">
from django.shortcuts import render_to_response<br />
import MySQLdb<br />
<br />
def book_list(request):<br />
<span class="indent-lvl-1">db = MySQLdb.connect(user='me', db='mydb', passwd='secret', host='localhost')</span>
<span class="indent-lvl-1">cursor = db.cursor()</span>
<span class="indent-lvl-1">cursor.execute('SELECT name FROM books ORDER BY name')</span>
<span class="indent-lvl-1">names = [row[0] for row in cursor.fetchall()]</span>
<span class="indent-lvl-1">db.close()</span>
<span class="indent-lvl-1">return render_to_response('book_list.html', {'names': names})</span>
</p>