editing multiple emails

[brown2005]

			$get_emails = mysql_query("SELECT * FROM emails");

		while($row = mysql_fetch_assoc($get_emails))
		{

			$curr_email = $row['emails_email'];
			$curr_id = $row['emails_id'];

			$email = strtolower($curr_email);
			$email = rtrim($email);
			$email = ltrim($email);									
			$email = mysql_escape_string($email);

			$del = mysql_query("UPDATE emails SET emails_email=$email WHERE emails.emails_id=$curr_id LIMIT 1");
		        
    		echo "$email added to database<br>";
    					
		}

 

hi i have the above code to take emails from my database and string them to lower and remove any white space left on the left or right of the entry, but it is not working.

 

any help please

[mikesta707]

perhaps you meant

emails.email='$email'

 

in any case you have to wrap varchars with single quotes

 

[brown2005]

lmao. my god im a plonker. cant believe i missed that. thanks