MYSql, CGI web page search code not working

[Kirk McDonald]

Fred wrote:
> Yeah, I already tried that (except you have a , after name.
> 
> Your code produces the same error:
> 
>  NameError: name 'name' is not defined
> 
> I know I am close!! Just missing some small thing...
> 

Oh, duh. I forgot something:

#!/usr/local/bin/python
print "Content-Type: text/html\n"
import MySQLdb
import cgi

form = cgi.FieldStorage()

db=MySQLdb.connect(host = 'localhost', db = 'phone')
cursor=db.cursor()
cursor.execute("Select * from phone where name=%s order by name",
     (form['name'].value,))

result = cursor.fetchall()
for record in result:
     print '<p>'
     print record[0]
     print '--'
     print record[1]
     print '--'
     print record[2]
     print '--'
     print record[3]
     print '</p>'

The comma is intentional: the MySQLdb wants the argument(s) as a tuple.