brown2005 Posted April 12, 2006 Share Posted April 12, 2006 If i have1, 2, 3, 4, 5how can i update table1 field number for 5 records randomly? Link to comment https://forums.phpfreaks.com/topic/7195-update-numerous-records/ Share on other sites More sharing options...
shocker-z Posted April 12, 2006 Share Posted April 12, 2006 huh?? Dont get what you mean.. Link to comment https://forums.phpfreaks.com/topic/7195-update-numerous-records/#findComment-26182 Share on other sites More sharing options...
brown2005 Posted April 12, 2006 Author Share Posted April 12, 2006 you helped me on my other topic and you gave meUPDATE table2 SET `fieldname` = (SELECT letter FROM table1 ORDER BY RAND())but that didnt work..what i want to do istake say 10 records from one table....and update a field in 10 records from a different table but using the 10 above randomly Link to comment https://forums.phpfreaks.com/topic/7195-update-numerous-records/#findComment-26183 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.