If you notice he has it commented out. I doubt that that was the problem.
I read somewhere a while ago about a difference in operator precedence between || and or. Perhaps the die is being invooked first? Charles Killmer -----Original Message----- From: Stephen [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 12:01 PM To: Croskerry, Dan Cc: Windows Helplist (PHP) Subject: Re: [PHP-WIN] Re: or die problem Dan, mssql_query($sql); // or die ("insert failed") When you use or die, you must NOT have a ; on the end of the mssql_query eg mssql_query( $MyQuery ) OR die( 'Error' ); Notice the ; only goes on to the end of the or die command. Stephen ----- Original Message ----- From: "Croskerry, Dan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 5:43 PM Subject: RE: [PHP-WIN] Re: or die problem > 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> > > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
