Help with select query

[golfinggod]

Hi can anyone help with my select query

$recordCount = "select Unique(Java) from vis_java";

$totalRowsResult = mysql_query($recordCount);


while($thisrow=mysql_fetch_row($totalRowsResult))
{

echo "oly";

}

I keep getting this error

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in c:\phpdev5\private\test.php on line 21

I am trying to print the word oly for each unique id.

[sneakyimp]

Originally posted by golfinggod

$recordCount = "select Unique(Java) from vis_java";

$totalRowsResult = mysql_query($recordCount);


while($thisrow=mysql_fetch_row($totalRowsResult))
{

echo "oly";

}

Maybe try this:

$recordCountSQL = "SELECT DISTINCT Java from vis_java";
$totalRowsResult = mysql_query($recordCountSQL)
  or die ("QUERY FAILED:" . mysql_error());
echo "Number of unique IDs:" . mysql_num_rows($totalRowsResult);
while($thisrow=mysql_fetch_row($totalRowsResult))
{
  echo "oly";
}

[golfinggod]

thanks for the help