Problem with adding quotations to a mysql insert statement
| From: | Richard Kurth | Date: | Mon, 15 Dec 2003 09:01:44 +0000 |
| Subject: | Problem with adding quotations to a mysql insert statement | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-172717@lists.php.net to get a copy of this message | ||
I need to add extra quotation marks in to the following insert command for
mysql.
I need one that is part of the info right before the |$wrapper resend and
right after the
$outgoing,nobody
$query = "insert into majordomoaliases
(domain,listname,var,address1,address2)values
(/"$domname/",\"$listname\",\"a\",\"$listdomain-$listname:\",\"
|$wrapper
resend -C $domaincf -l
$listname -h $listdomain $listdomain-$listname-$outgoing,nobody\")";
The whole line should look like this when it is printed out to the page it
will be written to from the database
"|/var/wrapper resend -C /var/domaincf -l list1 -h domain.com
domain.com-list1-outgoing,nobody"
I am totaly stuped on haw to add this extra quotation mark no mater what I
do I get mysql errors.