hiii...i ran into a problem with my QUERY in mysql and the addslashes() function in php...heres my problem :
my query is the following:
$SQL = sprintf("INSERT INTO articles
(artName, artDate, artAuthor, artSource, artURL, active, artSum)
VALUES('%s', '%s', '%s', '%s', '%s', '%s', '%s')",addslashes($artName), addslashes($artDate), addslashes($artAuthor), addslashes($artSource),
addslashes($artURL), addslashes($active), addslashes($artSum));
$query = mysql_query($SQL);
ALL THE MYSQL TYPES FOR THE FIELDS IN THIS TABLE "articles" are text or date except for "artSum" which is a blob.
No here's the problem...when i view the date from the db that i have inserted...the only field who's slashes are striped is "artSum"..all the other fields still have their slashes...does mysql get rid of the slashes? do i need to actually call stripslashes() before i view? does the "no stripping of slashes" have to do with my field types in the db?
PLEASE IF ANYONE COULD HELP ME =(
my query is the following:
$SQL = sprintf("INSERT INTO articles
(artName, artDate, artAuthor, artSource, artURL, active, artSum)
VALUES('%s', '%s', '%s', '%s', '%s', '%s', '%s')",addslashes($artName), addslashes($artDate), addslashes($artAuthor), addslashes($artSource),
addslashes($artURL), addslashes($active), addslashes($artSum));
$query = mysql_query($SQL);
ALL THE MYSQL TYPES FOR THE FIELDS IN THIS TABLE "articles" are text or date except for "artSum" which is a blob.
No here's the problem...when i view the date from the db that i have inserted...the only field who's slashes are striped is "artSum"..all the other fields still have their slashes...does mysql get rid of the slashes? do i need to actually call stripslashes() before i view? does the "no stripping of slashes" have to do with my field types in the db?
PLEASE IF ANYONE COULD HELP ME =(