[PHP-DB] Temporary Tables in MySQL

) 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 :-(

-- . 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 :-(

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

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

, 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

-- . 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?

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?

/ 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

-- . 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

, 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

. 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