Calling MySql stored procedure
Posted: Wed Nov 16, 2005 4:32 pm
Hi all,
Im a newbie. I have a database that has stored procedures outputing statements.
Procedure Printer()
begin
...
if ... then select 'there is a problem with A';
elseif ... then select 'A is much bigger than B';
...
end if;
if ... then select 'C is clear';
...
end if;
end;
I can see the outputs in MySql.
mysql> call printer()
+---------------------------------+
| there is a problem with A |
+---------------------------------+
| there is a problem with A |
+---------------------------------+
1 row in set (0,05 sec)
+---------------------------------+
| A is much bigger than B |
+---------------------------------+
| A is much bigger than B |
+---------------------------------+
1 row in set (0,05 sec)
+-------------+
| C is clear |
+-------------+
| C is clear |
+-------------+
1 row in set (0,05 sec)
Query OK, 0 rows affected (0,06 sec)
My question is, how can I get php to put all these rows on my page?
Please help. I've been stuck on this for a while now and am begining to think I cant do this. I've been looking almost everywhere!
Mbe.
Im a newbie. I have a database that has stored procedures outputing statements.
Procedure Printer()
begin
...
if ... then select 'there is a problem with A';
elseif ... then select 'A is much bigger than B';
...
end if;
if ... then select 'C is clear';
...
end if;
end;
I can see the outputs in MySql.
mysql> call printer()
+---------------------------------+
| there is a problem with A |
+---------------------------------+
| there is a problem with A |
+---------------------------------+
1 row in set (0,05 sec)
+---------------------------------+
| A is much bigger than B |
+---------------------------------+
| A is much bigger than B |
+---------------------------------+
1 row in set (0,05 sec)
+-------------+
| C is clear |
+-------------+
| C is clear |
+-------------+
1 row in set (0,05 sec)
Query OK, 0 rows affected (0,06 sec)
My question is, how can I get php to put all these rows on my page?
Please help. I've been stuck on this for a while now and am begining to think I cant do this. I've been looking almost everywhere!
Mbe.