Not printing mySQL SELECT statement to html page?

[hoggie1790]

Hi, im new to the forums so sorry if this is posted in the wrong place or formatted incorrectly.

 

I have a mySQL database that i want to access and retrieve the price of items in a table. From the instructions i have followed i cant seem to get it to work.

 

Basically when i load the page it simply prints: query("SELECT * FROM Wines") as $row) { print $row['price']; } ?>  rather than the price of wine in my database.

 

Heres my code:

<?php
$WineDB = new PDO(				
'mysql:host=(HostName);
dbname=wines',					
'abc123',				
'XXXXXX'
);
foreach($WineDB->query("SELECT * FROM Wines") as $row)
{
      print $row[‘price’];
}
?>

 

Maybe im missing some punctuation?

 

Thanks in advance for any help.

[AbraCadaver]

PHP is not installed or your page extension is not .php?

[Maq]

How are you calling the page?