unexpected t_variable

[Talguy]

I have just started to experimenting with the pdo class with much success but when I tried to perform a select stat where the field was equal to a value i got this error.

here is the code

$results = $db->prepare("SELECT category_name FROM gallery_category WHERE    category_id='" $photo_category_id "'");					
$results->execute();
$photo_category = $results->fetch(PDO::FETCH_ASSOC);

[thorpe]

Your not using any concatination. Use either...

 $results = $db->prepare("SELECT category_name FROM gallery_category WHERE category_id='". $photo_category_id ."'");

or...

 $results = $db->prepare("SELECT category_name FROM gallery_category WHERE category_id='$photo_category_id'");