basic select statement working/not working

[david*]

hello, first post here!

 

this is a basic select statment that works a million times over but seems not to work now. i wonder if anyone can see any problems with it?

 

$query = "SELECT link FROM `images` WHERE hotel= $hotel ";



$result = @mysql_query($query);



if(!$result){

echo "not selcted";

}

else{

echo "selcted";

}

 

there is defo a column named \'link\' and column named \'hotel\' in a table named \'images\'.

 

i just put in the if statement for debugging at the mo...

 

if i cange $hotel to an actual name ie

hotel = \'my hotel\'

it works fine.

 

i have printed everything to the screen and the variable is defo being passed.

 

any ideas?

 

thanks in advance!

 

david*

[david*]

sorted it - silly me should have had

hotel=\'$hotel\'

 

david*