Jump to content

joining tables


deansaddigh

Recommended Posts

I am totaly making up some field names of course and in order to join to tables you have to have something that is in both tables that you can use to join.  For example,  client id.

 

Assuming that the clients table has a id field and the enquiries table has the client id as well you could do something like:

"SELECT enquiries.*, clients.id, clients.firstname, clients.lastname, clients.email FROM enquiries, clients 
WHERE enquiries.status = 'uncontacted' AND enquiries.clientid = clients.id $searchSQL $filterSQL $limitBy";

 

Link to comment
https://forums.phpfreaks.com/topic/187594-joining-tables/#findComment-990451
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.