RE: [PHP-DB] Re: Multi search function (help)

2004-05-28 Thread Gavin Amm
For what it's worth, if you store your form fields in an array, you can loop through the array to search for isset empty on each array element and have the array add the fields that are relevant to your sql statement. Doing this will also ensure that you won't have to modify your script (that

[PHP-DB] subquery

2004-05-28 Thread Brock Jimmy D Contr 74MDSS/SGSI
I'm trying to use a delete subquery in Oracle (using SQL) and it is preventing me from deleting when no records are found in the SELECT statement. DELETE roles WHERE roleid NOT IN (SELECT DISTINCT roleid FROM users WHERE roleid='Staff Member'; There are no records in the USERS table that

[PHP-DB] using php to manage multiple databases

2004-05-28 Thread frank dziuba
Hi, I have a need to create a web interface that will be used to connect to many, separate MySQL databases. Basically, it's a central php web application that will make connections to one of perhaps 500-1000 different MySQL servers to do some simple queries, then disconnect. Each server