can't get rid of the comma

[jeff5656]

I have a variable called $row['full_name'] that is usually like this : Smith, John.

I want to split it into 2 variables for first and last names like this:

$query = "SELECT full_name, id_incr from name_db";
$results = mysql_query ($query);
while ($row = mysql_fetch_array ($results)){
$newlastname = $row['full_name'];
if (preg_match('/^[^,]+(?=,)/', $row['full_name'], $match)) {
    	$newlastname = $match[0];
	echo $newlastname;
}

The $newlastname is: Smith.  So far so good.  But then, But after I do this:

list($newlastname,$newfirstname) = explode(' ',$row['full_name']);
echo $newlastname."<br>";

the $newlastname has a comma at the end:

Smith,

How do I chaneg the explode so that there isn't a comma at the end?

[wildteen88]

Why not just do

list($newlastname,$newfirstname) = explode(', ',$row['full_name']);

 

Or (untested)

list($newlastname, $newfirstname) = preg_split('~,\s+~', $row['full_name']);

 

[jeff5656]

explode(', ',$row['full_name']); did it.  Thanks!