mysql-python error "AttributeError: cursor"

[geddy]

My OS: Ubuntu 7.04 distribution
Mysql: Server version: 5.0.38-Ubuntu_0ubuntu1.2-log Ubuntu 7.04 distribution
mysql-python:1.2.2
python:2.5

when I run the following script:
import MySQLdb
conn = MySQLdb.connection('localhost', 'root', '', 'books');
c=conn.cursor()
cur = conn.cursor();
cur.execute('select * from orders');
row = cur.fetchone();
print row;


I get error message:
Traceback (most recent call last):
File "mysql_demo.py", line 7, in <module>
c=conn.cursor()
AttributeError: cursor

Please help!!!!

[jlm699]

I don't know alot about the MySQLdb module (only postgresql modules)... but a quick google of the documentation reveals the following...
http://dustman.net/andy/python/MySQL...3.html#MySQLdb
Read about the connect() function and how cursor is a member of an object returned by that function. I think you may not be actually establishing a connection when you use connection()

[geddy]

But the script run correctly on the other machine

[jlm699]

But the script run correctly on the other machine

What is the difference between the two machines then? It can't be a problem with the code if it already runs.. it must be a problem with the machine itself.