11-30-2005, 11:42 AM
|
|
WebProWorld Member
|
|
Join Date: Aug 2003
Location: Jersey City, NJ
Posts: 71
|
|
ok
Quote:
email addresses?
I use PERL with SQL and with PERL you need a backslash before the @ symbol.
For example
email@email.com would fail (Syntax error)
email\@email.com would be OK
With SQL Blank inputs may fail
Of cause you can't ask users to input this, so the code has to add it.
Typical SQL line, note single quote even for blanks, except with numbers:-
INSERT INTO `compare_data1` VALUES ('Bookplace Ltd', 'Books', 'Books', 'HOUSE TO LET, A', 'Books', 'HOUSE TO LET, A', 10.99, 0, 'ukpounds', '', '', 'http://www.awin1.com/awclick.php?gid=21734&mid=321&awinaffid=25014&p=ht tp://www.thebookplace.co.uk/bookplace/display.asp?cid=awin&isbn=1404366571', 200, 200);
'', above is a single quote then a null then a single quote.
|
TrafficProducer, I think i understand what your saying. but it doesn't use PERL. The script is all PHP and uses the MySql DB
The script worked just fine up until a few days ago.
__________________
It's better to do business with me than against me!
|