Re: Update issue - more then likely simple problem

On Thu, Dec 18, 2003 at 01:39:57PM +1100, Eric Holmstrom wrote: > > What im trying to do is read the information from a field in a table called > PARTNO. Then add RU to the front of whatever is in the PARTNO field. > > So far i have this. > > //connect details rarara > //query > $query= "SELECT PARTNO FROM russell2 "; Didn't you say the table was called "PARTNO", not "russell2"? > // make a query to get old stuff from DB col > $oldstuff = mysql_query($query, $conn) or die(mysql_error()); > while ($new = mysql_fetch_array($oldstuff)){ > $final = $new['PARTNO']; > //new infomation i want to add infront of PARTNO data > $newstuff = 'RU'; > //Combining the two resluts together > $results = $newstuff.$final; > // just use this to check it was going through properly > print_r($results<br>); > } > > The problem i have to get it to update. If i add this (see below) inside the > while statement it continually loops, and outside it doesnt work. > > $update = "UPDATE rocket SET PARTNO = '$results''"; > mysql_query($update); > > I know the answer is simple but i seem to be stuck on it. I don't think you can just update a row that you just fetched within the same query. If you do this in PHP, you should split the update into a separate loop. Of course, it would be faster and more efficient to have MySQL do it for you: UPDATE rocket SET PARTNO = CONCAT('RU',PARTNO)