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 Share on other sites More sharing options...
keeB Posted August 15, 2007 Share Posted August 15, 2007 INSERT DISTINCT .... I think Link to comment Share on other sites More sharing options...
fenway Posted August 20, 2007 Share Posted August 20, 2007 Double-post. Link to comment Share on other sites More sharing options...
Recommended Posts