Hi everybody.
I've installed php 4.03 then 4.04 on a Win NT4 sp6a server with a MSSQL SERVER 7.
Because of a huge speed difference between php and asp, i would like to use php from now to developp all my pages.
But i've got a problem !!!
i've a loop like this :
while () {
[...]
$strsql = "DECLARE @newid int"
$strsql .= "INSERT ... "
$strsql .= "SET @newid = @@IDENTITY "
$strsql .= "INSERT ... (@newid,...)"
mssql_query($strsql)
}
And only the first loop is inserted and others iterations fail !!!
Why ?!?
Please help me to solve this problem, 'cause i have to use stored procedure after that, and i know that i'll have many more pbm with them !!
Thx --------------------> A french php user !
I've installed php 4.03 then 4.04 on a Win NT4 sp6a server with a MSSQL SERVER 7.
Because of a huge speed difference between php and asp, i would like to use php from now to developp all my pages.
But i've got a problem !!!
i've a loop like this :
while () {
[...]
$strsql = "DECLARE @newid int"
$strsql .= "INSERT ... "
$strsql .= "SET @newid = @@IDENTITY "
$strsql .= "INSERT ... (@newid,...)"
mssql_query($strsql)
}
And only the first loop is inserted and others iterations fail !!!
Why ?!?
Please help me to solve this problem, 'cause i have to use stored procedure after that, and i know that i'll have many more pbm with them !!
Thx --------------------> A french php user !