MySQL Stored Procedure that returns query result

Is it possible that a MySQL function/stored procedure returns a query result?

Because I want to have this on PHP:

SET @csum:=0; 

SELECT 
    datvalor AS 'Date', 
    company AS 'Company', 
    (@csum:=@csum + amount) AS 'Sum'
FROM tbl_test
ORDER BY datvalor

but PHP can´t run multiple lines, right?

I've searched but everyone says th开发者_如何学JAVAat a procedure can't return a table. How will you solve this?

I don't want to put the Sum calculation on php, the goal here is too generate everything on MySQL

Tks

---

No, PHP can run multiple lines query. You just to concatenate strings.

e.g.

$sql = "";

$sql .= "SELECT ";
 $sql .= "   datvalor AS 'Date', ";
 $sql .= "   company AS 'Company', ";
 $sql .= "   (@csum:=@csum + amount) AS 'Sum'";
$sql .= " FROM tbl_test";
$sql .= " ORDER BY datvalor";

---

After more research, I've found that the way is use mysqli (MySQL Improved) instead of mysql, just don't know the little details (yet)