473,498 Members | 1,977 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

problems with @ symbol in varchar field

I am trying to do a search on a varchar field containing email addresses,
however the @ symbol seems to be creating problems, any suggestions? Current
code:

use strict;
use CGI::Carp "fatalsToBrowser";
use CGI ":standard";
use DBI;
use CGI qw(param);
my $email = param('email');
my ($dbh, $sth);

$dbh = DBI->connect("DBI:mysql:user:localhost","database","pa ssword");
my $sth = $dbh->prepare("SELECT * FROM database WHERE email = $email");
$sth->execute;

my @record = $sth->fetchrow();
my $email = $record[0];
my $balance = $record[14];
print"Content-type:text/html\n\n";
print
"<font face=\"Verdana, Arial\" size=\"1\" color=\"#006600\">$email
$balance</font>";
print "\n";
$sth->finish;

$dbh->disconnect;
Jul 19 '05 #1
0 1403

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
540
by: noViagraHere | last post by:
I am trying to do a search on a varchar field containing email addresses, however the @ symbol seems to be creating problems, any suggestions? Current code: use strict; use CGI::Carp...
2
2767
by: Ryan | last post by:
I am having problems creating a new table with a default and auto increment such as this... CREATE TABLE `customer` ( `cust_id` INT( 5 ) DEFAULT '00000' NOT NULL AUTO_INCREMENT , `cust_name`...
0
1641
by: Nico den Boer | last post by:
Hi all, I'm working with: MySql: Database server: mysql-4.1.7-essential-win ODBC driver: MyODBC-3.51.10-x86-win-32bit Administrator: mysql-administrator-1.0.14-win Query browser:...
4
5763
by: Russell | last post by:
I'm having a fit with a query for a range of dates. The dates are being returned from a view. The table/field that they are being selected from stores them as varchar and that same field also...
0
2419
by: Marko Poutiainen | last post by:
Situation: We had to make our SQLServer 2000 database multi-lingual. That is, certain things (such as product names) in the database should be shown in the language the user is using (Finnish,...
10
70991
by: Techie | last post by:
what's the difference of the two data types?
2
3546
by: rustyc | last post by:
Well, here's my first post in this forum (other than saying 'HI' over in the hi forum ;-) As I said over there: ... for a little side project at home, I'm writing a ham radio web site in...
0
27206
by: maheshmohta | last post by:
Background Often while remodeling legacy application, one of the important tasks for the architects is to have an optimum usage of storage capabilities of database. Most of the legacy applications...
2
6637
by: karinmorena | last post by:
I'm having 4 errors, I'm very new at this and I would appreciate your input. The error I get is: Week5MortgageGUI.java:151:cannot find symbol symbol: method allInterest(double,double,double)...
0
7125
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7002
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7165
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7203
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6885
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
1
4908
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3093
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
1
656
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
290
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.