Jump to content


php-mysql


  • Please log in to reply
3 replies to this topic

#1 Guest_Anonymous_*

Guest_Anonymous_*
  • Guests

Posted 20 August 2003 - 04:04 PM

When I try to make insert or update
ex: insert into t1 (flt) values (\'Magnus\')
I get this error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near \'\'Magnus\')\' at line 1


What shall I do?

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 22 August 2003 - 08:35 AM

Post the actual PHP code, there may be an error in the way you are constructing the query.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#3 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 26 August 2003 - 07:32 PM

My email reply to you got bounced.

Post your code in the forum.

Private consultations 35 euro/hr, 50 euro minimum, payable in advance, especially for bouncing email addresses.
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#4 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 27 August 2003 - 12:37 AM

try using stripslashes(); against the sql if it is being transferred.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users