At 16:09 06/01/2003 06/01/2003, Doug Parker wrote:
I have a relational database issue that I'll simplify for the sake of this post. [...] So it would be like this:

id | company_id | status | company
1 46 Active Jones Inc.
2 54 Inactive Baker Inc.

Using SQL the following SELECT should be the solution:

SELECT, company_id, status, company
FROM projects, clients
WHERE projects.company_id =

You can of course add any other filter in the WHERE clause using the usual AND OR NOT operators.

Of course you have to embed this command in an appropriate PhP statement, e.g. using the odbc library, and having an open connection $conn to the DB:

odbc_exec($conn, 'SELECT ... ');

Hope this will be enough to solve your problem.

Paolo Bonavoglia

Cannaregio 3027/R
30121 V E N E Z I A
Sito del Liceo Foscarini
Astronomia e Calendari

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to