[PHP-DB] Temporary Tables in MySQL

2001-07-22 Thread Alnisa Allgood
) AS searchable, memberid FROM members I get massive errors. I'm reading MySQL from New Riders, but I can't seem to figure this out based on the information they've provided. Alnisa -- . Alnisa Allgood Executive Director Nonprofit Tech (ph

RE: [PHP-DB] Another SELECTING problem :-(

2001-08-09 Thread Alnisa Allgood
-- . Alnisa Allgood Executive Director Nonprofit Tech (ph) 415.337.7412 (fx) 415.337.7927 (url) http://www.nonprofit-techworld.org (url) http://www.nonprofit-tech.org (url) http://www.tech-library.org

RE: [PHP-DB] Another SELECTING problem :-(

2001-08-09 Thread Alnisa Allgood
empid, COUNT(empid) FROM emp_cont GROUP BY empid HAVING COUNT(empid) 1 I tend to use either group by or having, so forgot that having can be used to limit a group by. But this statement should work for you, as well. Alnisa -- . Alnisa Allgood

Re: [PHP-DB] Another SQL Question

2001-08-13 Thread Alnisa Allgood
these different implementations of SQL occasional kill me. Alnisa -- . Alnisa Allgood Executive Director Nonprofit Tech (ph) 415.337.7412 (fx) 415.337.7927 (url) http://www.nonprofit-techworld.org (url) http://www.nonprofit

Re: [PHP-DB] Another SQL Question

2001-08-13 Thread Alnisa Allgood
, mdfaq_category cat 3 where faq_cat.cat_id (+) = cat.id 4 group by cat.id, cat.name; Funny, I think I just sent you something somewhat similar. Glad it worked. Alnisa -- . Alnisa Allgood Executive Director Nonprofit Tech (ph

Re: RE: RE: RE: [PHP-DB] Query construction

2001-08-21 Thread Alnisa Allgood
-- . Alnisa Allgood Executive Director Nonprofit Tech (ph) 415.337.7412 (fx) 415.337.7927 (url) http://www.nonprofit-techworld.org (url) http://www.nonprofit-tech.org (url) http://www.tech-library.org . Nonprofit Tech E

RE: [PHP-DB] How can you hide database login passwd in yourscript?

2001-09-05 Thread Alnisa Allgood
web root. Alnisa -- . Alnisa Allgood Executive Director Nonprofit Tech (ph) 415.337.7412 (fx) 415.337.7927 (url) http://www.nonprofit-techworld.org (url) http://www.nonprofit-tech.org (url) http://www.tech-library.org

Re: [PHP-DB] Using PHP with filemaker?

2001-09-12 Thread Alnisa Allgood
/ to test. Alnisa -- . Alnisa Allgood Executive Director Nonprofit Tech (ph) 415.337.7412 (fx) 415.337.7927 (url) http://www.nonprofit-techworld.org (url) http://www.nonprofit-tech.org (url) http://www.tech-library.org

Re: [PHP-DB] PHP/MySQL Library Catalog System

2002-01-10 Thread Alnisa Allgood
-- . Alnisa Allgood Executive Director Nonprofit Tech (ph) 415.337.7412 (fx) 415.337.7927 (url) http://www.nonprofit-techworld.org (url) http://www.nonprofit-tech.org (url) http://www.tech-library.org

Re: [PHP-DB] Concept help required

2002-01-10 Thread Alnisa Allgood
, telecommunications, protocols, routers, etc. The above explains the more complicated query between three tables, but you can also do this with a single table, or two tables. Alnisa -- . Alnisa Allgood Executive Director Nonprofit Tech (ph

Re: [PHP-DB] MySQL Query

2002-05-03 Thread Alnisa Allgood
. Alnisa -- . Alnisa Allgood Executive Director Nonprofit Tech (ph) 415.337.7412 (fx) 415.337.7927 (url) http://www.nonprofit-techworld.org (url) http://www.nonprofit-tech.org (url) http://www.tech-library.org