I have created a MySQL file whose primary key is an email address (since it is unique). However, when I try to select a matching record it does not like the @ sign in it. I am not sure how to tackle this. Do I modify the code to use (at) in place of the @ sign? Do I make a 2 part primary key, where username is part one and URL is part 2 and I never have to enter the @ sign at all? Or, do I rewrite my code (somehow) to get around the @ sign problem?
Snippets of code:
===================== the SQL table
CREATE TABLE userTable
( emailAddress varchar(50) primary key,
personName varchar(30) not null,
passWord varchar(30) not null,
it pulls this emailID from post method from previous form
$sql = "SELECT * FROM $dbtableName where emailAddress = $emailid";
It complains about this SQL statement
I would appreciate any help on this!