hi
i'm creating my own mysql function (udf), in which i need to query the database for specific values according to the provided parameter values without the use of mysql_connect() or mysql_real_connect() function, therefore i need access to the current MYSQL type structure that was created when query that issued my function was called
e.g.
i do a querry in my application (php, java, whatever) like:
select * from db.table where column > myfunction(param1, param2);
in myfunction() i want to use the connection already established to mysql server in my application and issue another query
is that even possible? if so how?
thanx
i'm creating my own mysql function (udf), in which i need to query the database for specific values according to the provided parameter values without the use of mysql_connect() or mysql_real_connect() function, therefore i need access to the current MYSQL type structure that was created when query that issued my function was called
e.g.
i do a querry in my application (php, java, whatever) like:
select * from db.table where column > myfunction(param1, param2);
in myfunction() i want to use the connection already established to mysql server in my application and issue another query
is that even possible? if so how?
thanx