Exec('SELECT `id`,`title` FROM `goods` WHERE power=0 ');
while(list($id,$name) = $DB->FetchRow($row_query2)) {
$pattern = '/[0-9]+W/';
preg_match($pattern,$name,$matches);
if(!empty($matches)) {
$watts = $matches[0];
$watts = str_replace('W','',$watts);
$DB->Exec('UPDATE goods SET power='.$watts.' WHERE id='.$id);
echo $name.' '.$watts.'
';
}
$pattern = '/[0-9]+w/';
preg_match($pattern,$name,$matches);
if(!empty($matches)) {
$watts = $matches[0];
$watts = str_replace('W','',$watts);
$DB->Exec('UPDATE goods SET power='.$watts.' WHERE id='.$id);
echo $name.' '.$watts.'
';
}
}
?>