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
