Jump to content

How to select form other table in one clause?


d22552000

Recommended Posts

$sql = "UPDATE `" . $v . "` SET `" . $row['Action Name'] . "` = `" . $row['Action Name'] . "`+1 WHERE ..."TABLE.JOBS...COLUMN.ACTION TIME"... <= 1";
    mysql_query($sql) or die (mysql_error());
    echo $v . " Updated!";

 

where I put: "..."TABLE.JOBS...COLUMN.ACTION TIME"... " is a fake represention of what I watn to do.

 

This mysql code puts me in the "BUIDLINDS" table... but I want to use "ACTION TIME" from teh JOBS table in my "Where. bla bla bla  = bla" section.  HOW I DO THIS?

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.