[PHP-DB] What does these error message mean?

[jong jong]

I got the error messages with your help. Unfortunatly,
I didn't see any problem in these message. Here is the
messages on my browser by loading the php file:
  Changed database context to 'pubs'.
  Changed database context to 'pubs'.query2 failed!
  Changed database context to 'pubs'.query3 failed! 

It didn't tell me anything about why query failed. My
code is like this:
<?
  $conn=mssql_connect("xxx","xxx","xxxxxxxx");
  mssql_select_db("pubs",$conn);

  $result=mssql_query("select * from authors");
  echo mssql_get_last_message();
  if (!$result)
    echo "query1 failed!";
  mssql_free_result($result);

  $result=mssql_query("insert into pub_info values
                       (0001,null,'test1')");         

  echo "<p>".mssql_get_last_message();
  if (!$result)
    echo "query2 failed!";
  else
    mssql_free_result($result);

  $result=mssql_query("insert into pub_info values 
                       (0002,null,'test2')");
  echo "<p>".mssql_get_last_message();
  if (!$result)
    echo "query3 failed!";
  else
    mssql_free_result($result);
?>

When I look into the table on MSSQL Server, Record
"0001,null,test1" was inserted.
But no record "0002,null,test2". This makes me feel
that query2 and query3 failed on different reasons! 
Any one see why query2 failed and query3 failed?

Thanks,
jongjong

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]