Update 2 Tables

[unemployment]

Can I update two tables in 1 update query? capitalavailable belongs to the iQuestions table, not the companies table

 

$sql = "UPDATE `companies` SET

`companyname` = '${name}',

`companytag` = '${tag}',

`companywebsite` = '${website}',

`industry` = '${industry}',

`stage` = '${stage}',

`country` = '${country}',

`state` = '${state}',

`city` = '${city}',

`capitalavailable` = '{$capitalavailable}'

WHERE `companytag` = '${ctag}'";

[fugix]

i will do a couple so you can understand how to do this..

$sql = "UPDATE companies, iQuestions SET
                                 companies.companyname = '${name}',
                                 companies.companytag = '${tag}',
                                 companies.companywebsite = '${website}',
                                 companies.industry = '${industry}',
                                 companies.stage = '${stage}',
                                 companies.country = '${country}',
                                 companies.state = '${state}',
                                 companies.city = '${city}',
                                 iQuestions.capitalavailable = '{$capitalavailable}'
                              WHERE companies.companytag = '${ctag}'";

 

hope this helps