Item mall for arcturus (error) twilight i need you

[poreotix]

Add item and All Close -
Warning: mssql_query() [function.mssql-query]: message: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). (severity 16) in C:\AppServ\www\itemmall.php on line 20

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\itemmall.php on line 20
ERROR!

[MentaL]

[harry12]

you really know how to use .php

[poreotix]

Harry tell it to me please :)

[bierdopje]

Would be helpful if you post us the itemmall.php file, or atleast the query...

[poreotix]

<?
//***** IME - (ITEM MALL ENGINE)******


//Config----------------------------
$mysecretfile='LogItemMallProcess.txt';
$myServer = "127.0.0.1";
$myUser = "USERNAME";
$myPass = "PASSWORD";
$myDB = "SHO";


echo "Add item and All Close\r\n";
//Data from FORM------------------
$AccountName=$_POST['account'];
echo $AccountName . "-";
$ItemCode=$_POST['binCODE'];
echo $ItemCode;
$conn=mssql_connect($myServer,$myUser,$myPass);
mssql_select_db($myDB);
$sql = "exec sp_warehousedeposit "$AccountName","$ItemCode"";
$res = mssql_query($sql);
if(!$res) {
die("ERROR!");
mssql_close($conn);
} else {
mssql_close($conn);
$f=fopen($mysecretfile,"a");
fputs($f, "User -".$AccountName." ItemCode - ".$ItemCode."\r\n");
fclose($f);
print "Tnx!!!";
}

[hijakob]

I can help you out with this. But you need to show the complete code as for there may be an error outside of the form you have pasted here.

Feel free to send me a PM.


Hij.

[bierdopje]

<?
//***** IME - (ITEM MALL ENGINE)******


//Config----------------------------
$mysecretfile='LogItemMallProcess.txt';
$myServer = "127.0.0.1";
$myUser = "USERNAME";
$myPass = "PASSWORD";
$myDB = "SHO";


echo "Add item and All Close\r\n";
//Data from FORM------------------
$AccountName=$_POST['account'];
echo $AccountName . "-";
$ItemCode=$_POST['binCODE'];
echo $ItemCode;
$conn=mssql_connect($myServer,$myUser,$myPass);
mssql_select_db($myDB);
$sql = "exec sp_warehousedeposit "$AccountName","$ItemCode"";
$res = mssql_query($sql);
if(!$res) {
die("ERROR!");
mssql_close($conn);
} else {
mssql_close($conn);
$f=fopen($mysecretfile,"a");
fputs($f, "User -".$AccountName." ItemCode - ".$ItemCode."\r\n");
fclose($f);
print "Tnx!!!";
}

Your code looks fine although I would change

$conn=mssql_connect($myServer,$myUser,$myPass);
mssql_select_db($myDB);

to

$conn=mssql_connect($myServer,$myUser,$myPass, $myDB);

and

$res = mssql_query($sql);
if(!$res) {
die("ERROR!");
mssql_close($conn);
} else {
mssql_close($conn);

to

if(!mssql_query($sql))
die("ERROR!");
mssql_close($conn);

Thereby I would highly recommend you to validate your form input (Post data) to prevent
empty rows in your database or SQL injection, which is possible now.

However, I don't know what is causing your error. I need more information. It even might be in your database.