Re: [PHP] searching tables

2005-05-23 Thread John Nichel
Sebastian wrote: I am quite aware of a mysql mailing list. I don't feel like joining another list, anyway, move along,.. I've already solved the problem without your help, but from others on this list. So you feel it's a-okay for *you* to post off topic questions because *you* don't feel like

Re: [PHP] searching tables

2005-05-23 Thread Sebastian
I am quite aware of a mysql mailing list. I don't feel like joining another list, anyway, move along,.. I've already solved the problem without your help, but from others on this list. John Nichel wrote: Sebastian wrote: I'd like to know if it is possible to perform a search across multiple

Re: [PHP] searching tables

2005-05-23 Thread John Nichel
John Nichel <[EMAIL PROTECTED]> wrote: We are currently away on holiday, until 16th June. I will respond with your email on my return. Thanks James Nunnerley Lookie, lookie php list controler peopleanother reason for an active moderator. -- John C. Nichel ÜberGeek KegWorks.com 716.8

Re: [PHP] searching tables

2005-05-23 Thread John Nichel
Sebastian wrote: I'd like to know if it is possible to perform a search across multiple mysql tables within a single query. eg, i have two tables with different column names: news: title | newstext faqs: topic | faqstext currently i am just searching the news table with a query as such: SEL

Re: [PHP] searching tables

2005-05-23 Thread Chris Boget
> I'd like to know if it is possible to perform a search across multiple > mysql tables within a single query. Look into UNION. thnx, Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] searching tables

2005-05-23 Thread Greg Donald
On 5/23/05, Sebastian <[EMAIL PROTECTED]> wrote: > I'd like to know if it is possible to perform a search across multiple > mysql tables within a single query. http://dev.mysql.com/doc/mysql/en/union.html -- Greg Donald Zend Certified Engineer http://destiney.com/ -- PHP General Mailing List (