Are you getting a error Lost Connection to Server error? If you are reconnect to the server every time you issue the SQL request. OR issue the command set GLOBAL wait_timeout=28000; Then issue the select
DVP ---- Dathan Vance Pattishall http://www.friendster.com > -----Original Message----- > From: Scott Klarenbach [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 31, 2005 10:58 AM > To: My SQL > Subject: Call a function from a select statement? > > Is this not the proper way to use a function in a select statement? > > SELECT > t.field1, > t.field2, > functionPerformAdditionalQueryFromField(t.field2) AS 'customField' > FROM Table t > > I'd like to perform the function on every row in the result > set, and store the returned value of that function in EACH > row, as a custom field. > > It works from the command line, but in PHP... > > the result set comes back the FIRST time, but then I lose my > connection to the database, and need to restart the service > in 2003 server. > > Very frusterating...any help is appreciated. > > -- > 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]
