Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Assistance needed for “special query” Deleting info in two tables

Assistance needed for “special query” Deleting info in two tables

Thread began 3/06/2012 2:45 pm by sjones435326 | Last modified 3/06/2012 4:37 pm by sjones435326 | 1062 views | 3 replies

3/06/2012 2:45 pmsjones435326

Assistance needed for “special query” Deleting info in two tables

Hello, I have a site I’m working on now that has many tables. I’m trying to figure out a custom query that would achieve the following:

Two tables – COMPANIES - LOCATIONS

customer_id is the relational link between the two. I have created all of the pages with the Data Assist Wizzard. However when using the company_Delete.php page I also need it to delete all of the locations that are listed under that customer_id in the LOCATIONS table.

Right now this is what code looks like for the DELETE statement.
$WA_Sql = "DELETE FROM `" . $WA_table . "` WHERE " . $deleteParamsObj->sqlWhereClause;

Can anyone help to achieve this

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.