Trouble with a period in filename in database

[travelbuff]

Hi all:

Hoping you can help me w/something. I have a db table with file names stored in it including the extension. I want to use that field in a WHERE clause but php/mysql thinks that the period is defining table.column so it returns an unkown column error. Here is my syntax:

@mysql_query("DELETE FROM images 
WHERE image_name = $image_id LIMIT 1") 
OR DIE ('Could not remove image from image table: ' . mysql_error());

$image_id would be something like xyz123.jpg.

Any thoughts?

Thanks

[paulnaj]

Hi,

I think you need single-quotes around the value ...

<?php
$sql = "
DELETE FROM images
WHERE image_name = '".$image_id."'
LIMIT 1
";

@mysql_query($sql) or die('Could not remove image from image table: ' . mysql_error());
?>

Paul 🙂

PS. I never embed variables myself ... much easier to debug, read and a tad faster not to!

[travelbuff]

That worked Pualnj, thanks....but I don't understand?

I have some other statements that do not have single quotes:

@mysql_query("DELETE FROM specials WHERE special_id = $special_id LIMIT 1") or die('Could not delete resort: '. mysql_error());

but in these $special_id is an integer...is that why those work?

[paulnaj]

Hi again,

In MySQL statements, you have to use quotes for non-numeric (or equivalent) values, so I would imagine that special_id is a number rather than character based.

Paul.