Email Issue

[dicamille]

I need to strip the @ symbol from a value in a textbox that i am using in a sql query....help!!!

[LordShryku]

[man]str_replace[/man]

[dicamille]

Here is the code I am using...requiredUserName is the email address that the user enters into a form in order to log on

<?php
$conn = mysql_connect("localhost", "mpi-erie", "multi1erie");
mysql_select_db("mpi-erie_MPI", $conn);
$test ="SELECT * FROM Customer WHERE Email =$requiredUserName";
$datatest = mysql_query($test,$conn);

[tommynanda]

Originally posted by dicamille
I need to strip the @ symbol from a value in a textbox that i am using in a sql query....help!!!

so do u want to strip @ from email address thats retrieved from SQL db?

... then just add this to your code
$vartemp = mysql_fetch_row($datatest);
str_replace("@","","$vartemp[0]");

Assuming that your first column is email ID of user

this would do something like
[e-mail] to metommynanda.com

If this isnt wat u looking for... give more details

TommYNandA

[dicamille]

when i run the code as is, i get this error

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '@.com' at line 1

this is why i thought i might have to strip the @ symbol