easy - cant figure out how to put a url in the database without error

[jwk811]

		$thumbnail = "http://www.sportquadchat.com/images/avatars/" . $thumbnail;

$sql   = "UPDATE chat_users 
          SET picture_url = '$thumbnail'
		  WHERE id = $userId";  

 

the thumbnail itself will submit just fine. its when i add the url to the beginning and 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 'b1aafd32d4c8cdaf02ad8bc47365d4b9.jpg'' WHERE id = 33' at line 2

 

i tried changing it around but i cant figure out why it wont work.

[Mchl]

It's not easy if you can't figure it out obviously.

Can you post whole $sql content?

[soak]

try:

 

$thumbnail = mysql_real_escape_string("http://www.sportquadchat.com/images/avatars/" . $thumbnail);

 

[avvllvva]

What is the table field type  ????

 

if it is VARCHAR , change it to TEXT.... then try.

[Yesideez]

Why has no-one suggested urlencode() yet?

 

http://uk.php.net/urlencode

 

Then when pulling it from the database use urldecode()

 

http://uk.php.net/manual/en/function.urldecode.php

 

VARCHAR is perfectly fine - just make sure it is set long enough to hold a decent URL.

[Mchl]

Why has no-one suggested urlencode() yet?

 

There's hardly need for that in this case... There seems to be nothing that would break the query here. We don't know what is in $thumbnail however.

[Yesideez]

Good point - $thumbnail hasn't been verified although going by the sample query IN the OP's post I presumed it was standard text (part of the URL)