On 03/09/2010 9:26 p, Hank wrote:
> On Fri, Sep 3, 2010 at 6:23 AM, Jangita<jangita@stripped> wrote:
>> On 02/09/2010 8:30 p, Hank wrote:
>>> Simple question about views:
>> Have you tried "running away from the problem :-)" by doing...
>> CREATE PROCEDURE `combo`(theid INT)
>> (SELECT * FROM table1 WHERE id = theid)
>> (SELECT * FROM table2 WHERE id = theid);
>> then calling it using
>> call combo(value);
> Wow - thanks. This works perfectly. I'm assuming I can use "call
> combo(value)" in PHP and it returns the result set as if it were a
> proper table?
Yes! it should work just like a table.
Jangita | +256 76 91 8383 | Y! & MSN: jangita@stripped
Skype: jangita | GTalk: jangita.nyagudi@stripped