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.