not creating foreign kye table please help me

[ramyasri]

hii friends

i am trying to retrieve data from table but at the time of running that code server showing following error mysql_fetch_array() expects parameter 2 to be long, resource given in C please let me know my mistake ....


my code is here:

<?php
$dbhost='localhost';
$dbuser='root';
$dbpass='';
$conn=mysql_connect($dbhost,$dbuser,$dbpass);
$sql="SELECT option1 FROM quiz ORDER BY RAND() LIMIT 10";
mysql_select_db("goget");
$retval=mysql_query($sql) or die(mysql_error());
while ($r=mysql_fetch_array($retval,$conn))
{
echo $r['option1']."<br/>";
}
?>

[OctoberWind]

From php.net

array mysql_fetch_array ( resource $result [, int $result_type = MYSQL_BOTH ] )

result

The result resource that is being evaluated. This result comes from a call to mysql_query().

result_type

The type of array that is to be fetched. It's a constant and can take the following values: MYSQL_ASSOC, MYSQL_NUM, and MYSQL_BOTH.

$retval=mysql_query($sql, $conn) or die(mysql_error());
while ($r=mysql_fetch_array($retval,MYSQL_BOTH))
{
echo $r['option1']."<br/>";
}