$connect=mysql_connect('localhost', 'clanhost_frgn1', 'dumbo5');
if(!$connect){
die('unable to connect to mysql server');
}
echo "connected..."."<br>";
mysql_select_db("clanhost_frgn1", $connect);
$query="SELECT Part_Name FROM `orders`";
$result=mysql_query($query) or die("unable to retrieve pn: ".mysql_error()."<br>");
$row = mysql_fetch_array($result);
foreach($row as $value){
print($value."<br>");
}
mysql_close($connect);
basically, I'm trying to get the contents of this table, and print them, but it just prints
mysql_fetch_array() returns both numeric and named fields, this explains the two of the same. The other part is, mysql_fetch_array() only returns 1 record found at a time. You need a loop.