On 03/09/2010 9:27 p, Hank wrote:
> On 02/09/2010 8:30 p, Hank wrote:
>>>
>>> Simple question about views:
>>>
>>>
>> Hank,
>> Have you tried "running away from the problem :-)" by doing...
>>
>> CREATE PROCEDURE `combo`(theid INT)
>> BEGIN
>> (SELECT * FROM table1 WHERE id = theid)
>> UNION
>> (SELECT * FROM table2 WHERE id = theid);
>> END$$
>>
>> 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?
>
> -Hank
>
Yes it should work just like a query/table.
--
Jangita | +256 76 91 8383 | Y! & MSN: jangita@stripped
Skype: jangita | GTalk: jangita.nyagudi@stripped
