RE: Python related MySQL question

[mathias fatene]

Look at db.use_result() and db.store_result() here :
http://www.birgerblixt.com/doc/packages/python-mysql/MySQLdb-2.html#ss2.
2

Best Regards

Mathias FATENE
 
Hope that helps
*This not an official mysql support answer
 


-Original Message-
From: Smelly Socks [mailto:[EMAIL PROTECTED] 
Sent: mardi 26 avril 2005 06:20
To: mysql@lists.mysql.com
Subject: Re: Python related MySQL question


Hi!

I am porting a function library app I wrote in PHP to Python.  At work
they only use Python.  I've researched how to connect to a MySql
database using Python, and how to retrieve rows.  However, I am
wondering how to do the
following:

I can do this in Python =  $da=MYSQL_QUERY(select *  from prefs where
user_name='$user_name'  ); I can do this in Python =
$peek=mysql_fetch_array($da);

I cannot do the following:
$title   =$peek[4];  //title window
$logic   =$peek[5];  //logic window

Can anyone shed light on how to get the pieces of the array and stick
them into variables?

Thanks very much!

Cheers!

-Warren




- Original Message -
From: Spenser [EMAIL PROTECTED]
To: David Bailey [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Thursday, April 14, 2005 12:27 PM
Subject: Re: book advice


 Check out MySQL Tutorial by Luke Welling (MySQL Press).  It's easy 
 to understand and not overwhelming.


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Python related MySQL question

[Smelly Socks]

Hi!

I am porting a function library app I wrote in PHP to Python.  At work they
only use Python.  I've researched how to connect to a MySql database using
Python, and how to retrieve rows.  However, I am wondering how to do the
following:

I can do this in Python =  $da=MYSQL_QUERY(select *  from prefs where
user_name='$user_name'  );
I can do this in Python =  $peek=mysql_fetch_array($da);

I cannot do the following:
$title   =$peek[4];  //title window
$logic   =$peek[5];  //logic window

Can anyone shed light on how to get the pieces of the array and stick them
into variables?

Thanks very much!

Cheers!

-Warren




- Original Message -
From: Spenser [EMAIL PROTECTED]
To: David Bailey [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Thursday, April 14, 2005 12:27 PM
Subject: Re: book advice


 Check out MySQL Tutorial by Luke Welling (MySQL Press).  It's easy to
 understand and not overwhelming.


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]