RE: [PHP] Warning: Sybase message: Incorrect syntax near 't'.
| From: | Mark Roedel | Date: | Mon, 01 Oct 2001 15:25:08 +0000 |
| Subject: | RE: [PHP] Warning: Sybase message: Incorrect syntax near 't'. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-69460@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Caleb Carvalho [mailto:havanero@hotmail.com]
> Sent: Monday, October 01, 2001 4:04 AM
> To: php-general@lists.php.net
> Subject: [PHP] Warning: Sybase message: Incorrect syntax near 't'.
>
>
> Hi am trying to add data from html form, and it seems like
> the line 14 in my script,
>
> $sybase_query="INSERT into problem
>
> VALUES('$product','$pro_title','$description','$solution')";
> $sybase_result=sybase_query($sybase_query);
>
> Warning: Sybase message: Incorrect syntax near 't'. (severity 15) in
> /var/www/html/process.php on line 14
>
> Problem Title : Doesn\'t work
If I'm remembering right, Sybase would prefer to see this as
Problem Title : Doesn''t work
(That is, a single-quote within a string that you're passing off to
Sybase should be escaped by another single-quote, not by a slash.)
---
Mark Roedel | "Blessed is he who has learned to laugh
Systems Programmer | at himself, for he shall never cease
LeTourneau University | to be entertained."
Longview, Texas, USA | -- John Powell