On 03/09/2010 9:27 p, Hank 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 query/table.
Jangita | +256 76 91 8383 | Y! & MSN: jangita@stripped
Skype: jangita | GTalk: jangita.nyagudi@stripped