It's a straight forward update statement. Like I said, it works, the data is written to the DB even with the or die so I'm not sure why the die is invoked. $sql = "UPDATE Helpline SET morn_pers='".$FV['morn_pers']."', aft_pers='".$FV['aft_pers']."', eve_pers='".$FV['eve_pers']."', "; $sql .= " notes='".$FV['notes']."' WHERE help_date='".$FV['insertDate']."' "; $result = mssql_query($sql); // or die ("insert failed")
-----Original Message----- From: Shaffin Bhanji [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:39 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-WIN] Re: or die problem It might help if you can post your code snippet! >>> "Croskerry, Dan" <[EMAIL PROTECTED]> 27/06/2003 12:28:13 pm >>> There is no error message. It happens mostly when I am doing an update or insert statement. There is no problem with the sql because the data gets written to the db. If I use or die it still writes to the db but the or die kills the processing. It's strange. -----Original Message----- From: Cristian MARIN [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 10:18 PM To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Subject: [PHP-WIN] Re: or die problem Maybe not the query is the problem, maybe the connection or the authentication ... Try executing the sql without the die part and then print out the mysql_error() if the mysql_errno()!=0 mysql_query($your_query_here); if (mysql_errno()!=0){ die (mysql_error()); } -- ------------------------------------------------- Cristian MARIN - Developer InterAKT Online ( www.interakt.ro <http://www.interakt.ro> ) Tel: +4021 312.53.12 Tel/Fax: +4021 312.51.91 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> "Dan Croskerry" < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote in message news:[EMAIL PROTECTED] <mailto:news:[EMAIL PROTECTED]> ... > I'm new to the windows platform for php development and I have been > having problems with the or die function when running sql queries. It > is being called even when I run a valid query. I have tested it with > valid queries and it is always triggered. I have had to stop using it > which is not good. I > never had problems with or die when I was working in a linux > environment. > > Does anyone know if there is a setting in the php.ini file that I have > to set for or die to work? My DB is MS SQL 2000. > > Thanks in advance, > Dan > -- PHP Windows Mailing List ( http://www.php.net/ <http://www.php.net/> ) To unsubscribe, visit: http://www.php.net/unsub.php <http://www.php.net/unsub.php> -- PHP Windows Mailing List ( http://www.php.net/ <http://www.php.net/> ) To unsubscribe, visit: http://www.php.net/unsub.php <http://www.php.net/unsub.php>