Hi there,

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 ";

// 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.

Thankyou
Eric Holmstrom

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to