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>  



Reply via email to