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

Reply via email to