hoggie1790 Posted March 10, 2011 Share Posted March 10, 2011 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. Quote Link to comment Share on other sites More sharing options...
AbraCadaver Posted March 10, 2011 Share Posted March 10, 2011 PHP is not installed or your page extension is not .php? Quote Link to comment Share on other sites More sharing options...
Maq Posted March 10, 2011 Share Posted March 10, 2011 How are you calling the page? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.