[PHP-DB] Building WHERE SQL clauses

2008-09-15 Thread Mike Sullivan
Hello all. I'm using PHP to build a query for a database that consists of multiple tables, all with identical attribues. A typical syntax try looks like this: SELECT * FROM chico, harpo WHERE operator = Bill OR operator = Jessica MySQL responds with this: Couldn't execute query.Column

Re: [PHP-DB] Building WHERE SQL clauses

2008-09-16 Thread Mike Sullivan
be normalised or something... Stephen Wellington On Mon, Sep 15, 2008 at 4:06 PM, Mike Sullivan [EMAIL PROTECTED] wrote: Hello all. I'm using PHP to build a query for a database that consists of multiple tables, all with identical attribues. A typical syntax try looks like this: SELECT

Re: [PHP-DB] Building WHERE SQL clauses

2008-09-17 Thread Mike Sullivan
Chris [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Mike Sullivan wrote: Hi all thanks for the responses! What I have is a 6 table db that has each table created from the output of 6 identical laboratory machines (chico, harpo, ...). The out put is a text file which I import