Wierd WordPress Function

Note: This post is over a year old and the content may no longer be accurate.

Well here is a wierd thing. At the moment I’m trying to write my first WordPress plugin (for an image gallery). Everthing I posted to the database seemed to be getting wrapped with tags. After 20 minutes of tearing my hair out, here is why:

I was using the following code:
$gallery_name = $_POST['gallery_name'];
$gallery_name = escape($gallery_name);

$result = $wpdb->query("INSERT INTO...;
This saved say ‘

monkey

‘ to the database when all I wanted was ‘monkey’ – the answer? Well i should have been using:
$gallery_name = $wpdb->escape($gallery_name);
Who would have thought so stupidly simple and such a bugger to find. Still the most useful bit of PHP I know is:
echo('

'); 
print_r($_POST); 
echo('

');
After all if you are going to tear your hair out it is better to be safe than sorry.