SQL Procedures and Functions

[bowersbros]

If i were to make a SQL function or procedure, I assume I can store it in a seperate file (most likely .sql file) but how would i go about including it, and calling the function etc?

[jacek]

I'm not sure it's possible in a nice way, you can do a shell_exec as described here http://stackoverflow.com/questions/4027 ... les-in-php but that will open new connection for every query (slow) and uses shel_exec (slower).

Not tried, but could you do

[syntax=php]mysql_query(file_get_contents('thingy.sql'));[/syntax]
?

[bowersbros]

Apparently

[syntax=sql]mysql_query('call procedure_name()'); [/syntax]

Will work