Query problem

[jclout]

I'm new to PHP but I think I might like it. Here's my problem. I get an error when trying to get the number of records. I think the query is right but not sure. Any help would be great.
<?
mysql_connect(localhost, *, *);
$query = mysql_query("SELECT corain.name FROM coriantype INNER JOIN corain ON coriantype.typeId = corain.type WHERE coriantype.typename=\"Grays\"");
$result = mysql(ctsolidsurface_com, $query);
$num = mysql_numrows($result);
$i = 0;
$j = 0;
$rownum = 0;

	while($i < $num) {

		if($j == $rownum) {
		echo "<TR>";
		$rownum += 13;
		}

	echo "<TD>";
	echo mysql_result($result,$i,"subtype");
	echo "</TD>";
	++$j;	
		if($j == $rownum) {
		echo "</TR>";
		}
	$i++;}	
	?>

[Frederick]

Try changing this first from

coriantype.typename=\"Grays\"");

to

coriantype.typename= 'Grays' ");

[jclout]

Didn't work still puzzled

[cgraz]

select your database using mysql_select_db() after mysql_connect() and

$result = mysql(ctsolidsurface_com, $query);

should be

$result = mysql_query($query) or die(mysql_error());

Cgraz