PHP database delete repeat records and add up totals

[coldfission]

I have a database full of order records for our website. My goal is to delete people from the same 'address' field and add up the 'total' into one record. Can i get some example code on how this would be done?

[MadTechie]

try

 

SELECT email
FROM users
GROUP BY email
HAVING ( COUNT(email) = 1 )

 

[coldfission]

OK i used that in my code, but not I need to search WHERE address=$address. But, some poeple typed their address in with single or double quotes. How would I delete all characters that would mess up the query? I was looking at the ereg_replace, but i couldn't figure it out

 

thanks for your help

[MadTechie]

my last post was for an MySQL Query, to clean up the input to the database you can use addslashes($data)

 

if you did want to clear out the quotes via ereg_replace (not need with add slashes)

but i think this would do it

$data = "hello's"
$result = ereg_replace("\"'", '', $data);