Database/Code ERROR Help

[friedstingray]

I have been trying to get this page to work but keep bumping into errors after errors.

i just want to connect to my database that is created and verified using mySQL.

i want to find out the cheapest price of a Category in this case CPU

whats wrong with the code?

==============================================

<?php

$dbh=mysql_connect ("localhost", "username", "*****") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("project");

$result = mysql_query(SELECT MIN( Price )  FROM Product WHERE Category =  "CPU" );

$lowestprice = mysql_result( $result  );

mysql_close();

echo $lowestprice;

?>

=============================================

keep getting parse error... sigh

any help will be greatly appreciated.

[leatherback]

One reason is for sure the , in

$lowestprice = mysql_result( $result, );

J.

[friedstingray]

oppss about the comma,

i have tried many combination according to my book

like

$lowestprice = mysql_result( $result, 0, 'price' );

$lowestprice = mysql_result( $result, 0);

$lowestprice = mysql_result( $result );

all result in error..

can anyone help me with this?

thanks