Re: 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" <dcrosker@hpl.ca> To: <php-windows@lists.php.net> 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:Shaffin.Bhanji@novell.com] > Sent: Friday, June 27, 2003 12:39 PM > To: dcrosker@hpl.ca; cristic@iakt.rdsnet.ro; php-windows@lists.php.net > Subject: RE: [PHP-WIN] Re: or die problem > > > It might help if you can post your code snippet! > > >>> "Croskerry, Dan" <dcrosker@hpl.ca> 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:cristic@iakt.rdsnet.ro] > <mailto:cristic@iakt.rdsnet.ro]> > Sent: Friday, June 27, 2003 10:18 PM > To: php-windows@lists.php.net > <mailto:php-windows@lists.php.net> > 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 > cristic@interakt.ro <mailto:cristic@interakt.ro> > "Dan Croskerry" < dcrosker@hpl.ca > <mailto:dcrosker@hpl.ca> > wrote in > message > > news:944AF5792FE8D411A7810002A5070498084172C7@corvus.hamilton.ca > > <mailto:news:944AF5792FE8D411A7810002A5070498084172C7@corvus.hamilton.ca> > ... > > 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> > > > >