{<?
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("db") or die(mysql_error());
$result = mysql_query("SELECT * FROM product")
or die(mysql_error());
$row = mysql_fetch_array( $result );
echo "product: ".$row['product'];
echo " price : ".$row['price'];
?>}
Your problem is that you have to store your connection in a variable.
<?php
$dbconn = mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("db", $dbconn);
$result = mysql_query("SELECT * FROM product", $dbconn);
$row = mysql_fetch_array( $result );
echo "product: ".$row['product'];
echo " price : ".$row['price'];
?>
It's very recommended to use mysqli
or PDO instead, since the mysql
extension is now deprecated in PHP.