CptnChainsaw

Hi, If I wanted to join on another table would the query be something like this: SELECT a.email FROM a LEFT JOIN b ON b.email=a.email LEFT JOIN c ON c.email=a.email WHERE b.email IS NULL AND c.email IS NULL I tried this and its not quite right. I would only want to return records from table a if they are not in b and c. Any further suggestions would be appreciated as always. Thank you

Hi, Thank you for that, that's exactly what I was looking for. Cheers

Hi, Can anyone suggest a better way to write this query? I only want to find email addresses in table "a" if they are not in table "b". SELECT a.email FROM a, b WHERE a.email != b.email LIMIT 0 , 30 Cheers in advance. CptnChainsaw

Cheers shlumph, I think that's what I'm looking for. I'll do some more thinking on this, got a feeling its enough to get me going though, thanks again

Hi, I'm wanting to design an interface to the database to make it easier to save/select records to the database etc. Using an off the shelf ORM or framework isn't an option at the moment. So I'm looking to build my own so that existing code can be ported over time. Currently I've got something like this: $data->setTables(array('pay_support_cases')); $data->setFields(array('firstname', 'lastname', 'email', 'question')); $data->setRequest($_POST); $data->save(); This simply saves the data in the $_POST array to the table and fields passed in to the set methods. Calling the save method simply generates a query and executes it. This is going to become problematic with lots of tables etc. So I would be looking for something like an object for each table so if I had a "user" table I could do: $user->save(); I'm not sure how best to go about this, can anyone give me any pointers? Cheers in advance