than you for your answer but...

[Steve]

thank you for the clue of double quoting the html when inserting into the
database.... but I still get the error. the problem seems to be that I have
quotes INSIDE the html code as well (links and pix) so, i still get this
error.
 
"
Database Selected: candlecatalog
Query: insert into Products
(ProdID,ProdName,ProdType,ProdDesc,Price,Pic,Buy) Values ("VOALM","Almond
Votive","Votive","Our Almond scented Candles are melon
colored","1.25","","""<a href="HYPERLINK
"http://www.ccnow.com/cgi-local/cart.cgi?meltingpot_VOALM_http://www.themelt
ingpotonline.net/candleshop.html"><img"http://www.ccnow.com/cgi-local/cart.c
gi?meltingpot_VOALM_http://www.themeltingpotonline.net/candleshop.html";><img
src="HYPERLINK
"http://www.ccnow.com/images/buy_button_f.gif"http://www.ccnow.com/images/bu
y_button_f.gif" border="0" /> </a>""") 
Results
Error 1064: 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
'href="HYPERLINK
"http://www.ccnow.com/cgi-local/cart.cgi?meltingpot_VOALM_h"http://www.ccnow
.com/cgi-local/cart.cgi?meltingpot_VOALM_h
"
 
the code i want to insert is:
 
"<a href="HYPERLINK
"http://www.ccnow.com/cgi-local/cart.cgi?meltingpot_VOALM_http://www.themelt
ingpotonline.net/candleshop.html"><img"http://www.ccnow.com/cgi-local/cart.c
gi?meltingpot_VOALM_http://www.themeltingpotonline.net/candleshop.html";><img
src="HYPERLINK
"http://www.ccnow.com/images/buy_button_f.gif"http://www.ccnow.com/images/bu
y_button_f.gif" border="0" /> </a>"
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.0/342 - Release Date: 5/17/2006