Tried that, but to no avail. I'm running Mysql 5.0.4 and PHP 5.0.4, and was hoping it is a bug in one of these, but I don't think so...
I can run the query as I said from the command line, but in PHP, I get a real_connect_error, immediately after executing the query... that is...the windows service shuts down at the completion of the query and needs to be manually restarted...(the service crashing, is what causes the real_connect_error)... On 5/31/05, Dathan Pattishall <[EMAIL PROTECTED]> wrote: > 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]