[PHP-DB] Re: SQL Query - Using variable from another SQL Query

I think you don't need to break this into two queries... this is really a SQL question, not a PHP question... Just do a "join" on the two tables: * where table1.cal_id = table2.cal_id and then have a where clause that does all your filtering: * and table1.Date > now() and table2.cal_cate

[PHP-DB] Re: EXISTS syntax for SELECT INTO?

irst. Does SQL support the EXISTS > keyword for SELECT INTO statements (I'm running PG7)? > > If not, is there another way to do it in SQL? I'd rather not do it > programmatically. > > Thanks in advance, > Tony > Mike Morris The Music Place 161

[PHP-DB] Re: boolean values in postgresql

about a CHAR(1) with "Y"/"N" (or "T"/"F") and use a trigger to enforce it. Or you could use the small int and have 0/1... the validating trigger's the point... Mike Morris The Music Place 1617 Willowhurst Avenue San Jose, CA 95125 (408) 445

[PHP-DB] SSL connection between PHP4 & PostgreSQL ???

.g., "requiressl=true", etc... If not possible in PHP4, is it in PHP5? Any help greatly appreciated! MikeM Mike Morris The Music Place 1617 Willowhurst Avenue San Jose, CA 95125 (408) 445-ARTS (2787) Your Free Historical Quote: Above all

[PHP-DB] Re: Safe / Secure Login Script

m that I've guessed a valid username, then I can go about guessing the password. If I don't know which is wrong, the number of possibilities is increased geometrically. Mike Morris The Music Place 1617 Willowhurst Avenue San Jose, CA 95125 (408) 445-ARTS (2787) -