i have a aprocedure "simple_proc" i try to call her with mssql_query like this: ---------------------------------------------------------------- $q="exec simple_proc"; $ret = mssql_query($q,$__["db connection"]); ---------------------------------------------------------------- the result i get is: --------------------------------------------------------------- Resource id #20 -------------------------------------------------------------- insted of getting the resulets the proc is returning what should i do?? tnx noam. by the way ,if i use the sql server "Query Analyzer", i'm getting the wanted results -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php