views:

95

answers:

3
import _mysql as mysql
db=mysql.connect('localhost','username','password','database')


db.query("""select * from news""")

result = db.store_result()


print result.num_rows()#two records

#how to loop? without cursor

print result.fetch_row()
+2  A: 

You should not be importing _mysql. Symbols that start with a single underscore are for private use. Import MySQLdb and read PEP 249 for its use.

Ignacio Vazquez-Abrams
+1  A: 

You can try this:

while True:
    record = result.fetch_row()
    if not record: break
    print record

I second @Ignacio's note of caution against using _mysql. Switch to import MySQLdb.

Manoj Govindan
A: 

I'm not sure how you plan on using the loop, but you could do something like this:

while x < result.num_rows():
    #do something for each row
    X += 1
Nick011