How to select form other table in one clause?

[d22552000]

$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?

[hackerkts]

I'm not sure if you're asking this, but try reading this http://www.tizag.com/mysqlTutorial/mysqlupdate.php

just replace it with different table name.

[cooldude832]

the mysqli functions has a query in query function read up on it on php.net