d22552000 Posted July 13, 2007 Share Posted July 13, 2007 $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? Link to comment https://forums.phpfreaks.com/topic/59887-how-to-select-form-other-table-in-one-clause/ Share on other sites More sharing options...
hackerkts Posted July 14, 2007 Share Posted July 14, 2007 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. Link to comment https://forums.phpfreaks.com/topic/59887-how-to-select-form-other-table-in-one-clause/#findComment-297890 Share on other sites More sharing options...
cooldude832 Posted July 14, 2007 Share Posted July 14, 2007 the mysqli functions has a query in query function read up on it on php.net Link to comment https://forums.phpfreaks.com/topic/59887-how-to-select-form-other-table-in-one-clause/#findComment-297892 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.