# Perl quoting issue in CGI script (MySQL program)

**URL:** <https://forum.kirupa.com/t/perl-quoting-issue-in-cgi-script-mysql-program/279390>\
**Category:** programming\
**Created:** [January 14, 2009, 7:42am UTC](https://forum.kirupa.com/t/perl-quoting-issue-in-cgi-script-mysql-program/279390 "2009-01-14T07:42:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![iamhere](https://avatars.discourse-cdn.com/v4/letter/i/c57346/32.png) [@iamhere](https://forum.kirupa.com/u/iamhere)\
**Post date:** [January 14, 2009, 7:42am UTC](https://forum.kirupa.com/t/perl-quoting-issue-in-cgi-script-mysql-program/279390/1 "2009-01-14T07:42:47Z")

</div>

Hi,  
I have this line in my CGI Perl script:

$sth=$dbh-\>prepare (qq {INSERT INTO reviews VALUES (’$ary[0]’,’$reviewername’,’$topic’,’$review’,‘DATE\_FORMAT(CURDATE(),"%D %M, %Y"’) } ) ;

, but I keep getting “0000-00-00” in the “date” field in the database. How must I quote it so that the ‘DATE\_FORMAT’ part is interpolated?

Thanks.