text to blob

[tejaskokje]

Hello,

I have a huge text field which I want to update in one of mysql columns which is of BLOB datatype.

I tried simple update like
UPDATE exp_templates SET template_data ='$newString' WHERE template_name='caguirre_archives';

where template_data is of BLOB data type.

This gives me syntax error.

Where am I going wrong

Tejas Kokje
University of Southern California

[drawmack]

try this

<?php
$sql = 'UPDATE exp_templates SET template_data ="' . str_replace('"',"''",$newString) . '" WHERE template_name="caguirre_archives"';
mysql_query($sql);
?>

[tejaskokje]

Thanks it worked. But I am not sure where I was wrong. Please comment.

Tejas Kokje
Student
University of Southern California