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]

Reply via email to