MYSQL only capturing part of an UPDATE

[slightlyeskew]

Hey all,

I'm trying to update about 300 entries in my db and I don't want to do it by hand!

I wrote a little script to update the field (the email address) and its only delivering part to the db.

The script

<?php

...
//assume a proper db connection
while($lastNamecounter2 <= $lastNamecounter)
{
		$temp = $lastNamearray[$lastNamecounter2];
		$EmailAddress = $temp.'@novatechnologies.net';
		$insertEmail = $db->query("UPDATE ShareholderNames SET Email_Address = '$EmailAddress'");
		$lastNamecounter2++;
		echo "$EmailAddress<br/>";
}
?>

I echoed it so that I could make sure it was printing out properly and it is.
I'm getting output such as:

[e-mail]
[e-mail]
[e-mail]

HOWEVER, when I look at my db, the field has been updated with :
@.net
@.net
@.net

This is boggling my mind. I've tried lots of different syntaxtual stuff but nothing is working.

Any input would be greatly valued. 😃

[cahva]

Ok, first. When you do this:

$db->query("UPDATE ShareholderNames SET Email_Address = '$EmailAddress'");

..you are updating EVERY row with that information because you are missing WHERE clause.

For the field being the domain only I can only quess that wour while loop is giving you empty $temp with the last iteration. You would be better off using foreach instead of while. eg:

foreach ($lastNamearray as $lname)
{
	$EmailAddress = $lname.'@novatechnologies.net';
	...
}