stripslashes in Mysql query var

[monkeybidz]

I have this small piece of a query, there is a var $fulltxt in it that I need to stripslashes for, how would the code look?

 

$query1 = "SELECT distinct link_id, url, title, description, $fulltxt, size FROM ".$mysql_table_prefix."links WHERE link_id in ($inlist)";

	$result = mysql_query($query1);
	echo mysql_error();

 

Thanks in advance!

[kenrbnsn]

Either

<?php
$query1 = "SELECT distinct link_id, url, title, description, " . stripslashes($fulltxt) . ", size FROM ".$mysql_table_prefix."links WHERE link_id in ($inlist)";

	$result = mysql_query($query1);
	echo mysql_error();
?>

or

<?php
$fulltxt = stripslashes($fulltxt);
$query1 = "SELECT distinct link_id, url, title, description, $fulltxt, size FROM ".$mysql_table_prefix."links WHERE link_id in ($inlist)";

	$result = mysql_query($query1);
	echo mysql_error();
?>

 

Ken

[monkeybidz]

I had already tried both of those, but I think I am missing something or stripslashes is probably not what I need.

 

What I am trying to do is get $fulltxt from database. The information is there via addslashes. Example, if I insert something like this to database:

 

What's your name?

 

It will be inserted and appear as in database : What\'s your name?

 

Now, when I query it, it on shows as : What

 

Seems to stop at the slash.

[kenrbnsn]

That's different. You need to put the column name in the select clause, not the value.

 

Plus you shouldn't use addslashes when adding data into the database, use mysql_real_escape_string which escapes many more problematic characters.

 

If you explain what you're trying to do with the retrieved data & how you're doing it, we can help you.

 

Ken

[monkeybidz]

It is for links page: Example: Title, Description and Link

 

Yoursite(Title)

Yoursite is free test site. (Description)

http://www.yoursite.com (Url)

 

The description is in the database, just will not fully appear for some sites when a \ is in the description.