Hi,

I would suggest removing @ in front of the sybase_query. This way your code will 
produce warnings and messages from the server. That could help you debugging. You 
could also try to execute the query in Query Analyzer on the SQL Server.

- Frank

> Please take a look into my simple php code.  Why does
> this program die on "query2 failed" but a new record
> acturally is inserted into table "pub_info"?
> 
> I asked this question last week, but didn't get any
> answer so far. If you don't see any problem in there,
> please let me know. This is my last try!
> 
> Please help me!
> 
> <?
> $conn=sybase_connect("xxx","xxx","xxxxxxxx");
> sybase_select_db("pubs",$conn);
> 
> $result=@sybase_query("select * from authors",$conn)
> or die("query1 failed");
> sybase_free_result($result);
> 
> $result=@sybase_query("insert into pub_info
> values(0001,null,'test')",$conn) or die("query2
> failed");
> sybase_free_result($result);
> 
> $result=@sybase_query("select * from pub_info",$conn);
> sybase_free_result($result);
> ?>
> 
> working environment: SunOS5.8, php4, freetds, MSSQL
> Server
> 
> 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]
> 
> 
> 




-- 
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]

Reply via email to