Thread: PHP/MySql problems
View Single Post
  #2  
Old 07-30-2006, 12:08 PM
cook cook is offline
OSP Starters
  
Join Date: Jul 2006
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
cook is on a distinguished road
Default
Splendor, welcome to this forum

You need to use mysql_escape_string() in your queries where you expect a string with a ' in it. The single quote is used to SQL to enclose a string, so if you get one passed from php, then it thinks it's reached the end of a string.

Glad to help you -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - PHP/MySql problems
Thread: PHP/MySql problems
View Single Post
  #2  
Old 07-30-2006, 12:08 PM
cook cook is offline
OSP Starters
  
Join Date: Jul 2006
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
cook is on a distinguished road
Default
Splendor, welcome to this forum

You need to use mysql_escape_string() in your queries where you expect a string with a ' in it. The single quote is used to SQL to enclose a string, so if you get one passed from php, then it thinks it's reached the end of a string.

Glad to help you -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote