jaymc Posted August 15, 2007 Share Posted August 15, 2007 $queryf = "UPDATE `gallery` SET `valid` = '2' WHERE `valid` = '1' LIMIT 1"; I have that query, as you can see its going to update valid to 2 if it can find an occurance of valid equalling one and if it does it will go about its business really well great! However, if it can find a match and do its update I want to know what the ID is of the row affected Can it be done? Link to comment https://forums.phpfreaks.com/topic/64983-update/ Share on other sites More sharing options...
keeB Posted August 15, 2007 Share Posted August 15, 2007 INSERT DISTINCT .... I think Link to comment https://forums.phpfreaks.com/topic/64983-update/#findComment-324326 Share on other sites More sharing options...
fenway Posted August 20, 2007 Share Posted August 20, 2007 Double-post. Link to comment https://forums.phpfreaks.com/topic/64983-update/#findComment-329221 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.