Help with mysql php update

[Colin F]

OK, so you'll have to run through all those 40'000 things with a while() clause:

while($stock = $DB_site->fetch_array($upstck))
{


Then, parse the string:
fetch the first two chars:

$firstpart = substr($stock[stock],0,2);

fetch the last part

$lastpart = substr($stock[stock],4);

and put it all together:

$wholething = $firstpart . "00" . $lastpart;

all together that makes this:

PHP Code:

$upstck = $DB_site->query("SELECT stock FROM user");
while($stock = $DB_site->fetch_array($upstck))
{
$firstpart = substr($stock[stock],0,2);
$lastpart = substr($stock[stock],4);
$wholething = $firstpart . "00" . $lastpart;
//here's the place
} 


now I don't know what you want to do with the data, but do whatever you want where I placed the comment.