NOT IN select query not working
I want to  fetch some values from database except already fetched values,

Here is the query,I want to fetch the values that where not in first fetch,

`$qry="select value,name,number from test where value=10";`
`$rslt=mysql_query($qry);`
`$arr=mysql_fetch_assoc($rslt);`



`$qry2="select value,name,number from test where value NOT IN ('$rslt')";`
`$rslt2=mysql_query($qry2);`

`while($arr2=mysql_fetch_assoc($rslt2))`
`{`
`echo "<pre>";`
`print_r($arr2);`
`echo "<pre>";`
`}`

Please help

Thanks
NOT IN select query not working
===

I want to  fetch some values from database except already fetched values,

Here is the query,I want to fetch the values that where not in first fetch,

`$qry="select value,name,number from test where value=10";`
`$rslt=mysql_query($qry);`
`$arr=mysql_fetch_assoc($rslt);`



`$qry2="select value,name,number from test where value NOT IN ('$rslt')";`
`$rslt2=mysql_query($qry2);`

`while($arr2=mysql_fetch_assoc($rslt2))`
`{`
`echo "<pre>";`
`print_r($arr2);`
`echo "<pre>";`
`}`

Please help

Thanks