street;
// trenne strings
$length = strlen($street);
$found = -1;
for ($z=0;($found == -1 && $z<$length);$z++) {
if (is_numeric(substr($street,$z,1))) {
$found = $z;
}
}
if ($found != -1) {
$street_new = trim(substr($obj->street,0,$found));
$house_number = trim(substr($obj->street,$found,($length - $found)));
$sql = "
UPDATE customer_addresses
SET
street = '".mysql_real_escape_string($street_new)."',
house_number = '".mysql_real_escape_string($house_number)."'
WHERE id=".$obj->id."
";
// echo "
$street
".$sql;
mysql_query($sql);
}
}
?>