insert url link

[dodgeitorelse]

Hi guys, I tried to search for ths but get error for search daemon.

I am trying to insert into my database a url as a link. The url comes from a form.

 

the following code is what I have but it gives me "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 'http://www.xxxxxxxxx.net.au/site1/'>-=[xxxxxxxxx]=- User Created Maps Server'' at line 1"

 

$mysql_query  = "INSERT INTO websites (`clan`,`ip`,`port`,`site`) VALUES ('{$comment}','{$ip}','{$c_port}','<a href='$yoursite'>$comment</a>'";
    $mysql_result = mysql_query($mysql_query) or die(mysql_error());

 

if I change code to

$mysql_query  = "INSERT INTO websites (`clan`,`ip`,`port`) VALUES ('{$comment}','{$ip}','{$c_port}')";
    $mysql_result = mysql_query($mysql_query) or die(mysql_error());

it works.

 

any idea what I am doing wrong?

[dodgeitorelse]

I figured it out .......

 

$mysql_query  = "INSERT INTO `{$lgsl_config['db']['prefix']}{$lgsl_config['db']['table']}` (`type`,`ip`,`c_port`,`q_port`,`s_port`,`disabled`,`comment`,`cache`,`cache_time`,`site`) VALUES ('{$type}','{$ip}','{$c_port}','{$q_port}','{$s_port}','{$disabled}','{$comment}','','','<a href=\"$yoursite\" target=\"blank\">$comment</a>')";