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 (chic

Re: [PHP-DB] Building WHERE SQL clauses

2008-09-16 Thread Mike Sullivan
uot;Bill" OR h.operator ="Jessica" >> >> However if those tables really are identical I would suggest having a >> good look at your >> database design to see if it can be normalised or something... >> >> Stephen Wellington >> >> On

[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 '