Call to undefined function insert()..Help anyone

PHP
1

this is my code…is there any error in my logic


<?php
session_start();
include_once("conn.php");
$ass=mssql_query("Select * from tblAssign where TicketNo='$_SESSION[tick]' and AssignTo='$_SESSION[username]'");
$count = mssql_num_rows($ass);
if ($count < 1) {
insert($_SESSION[tick],$_POST['msg'],$_SESSION[username],$_POST['pic'],$_POST['status'],$_SESSION[name],$con);
header('location:supportreport.php');
function insert($tick,$msg,$AssngTo,$pic,$status,$createby,$con){
mssql_query("sp_assign @tick='$tick',@uname='$AssngTo',@pic='$pic',@stat='$status',@Create='$createby'");
mssql_query("sp_post @tick='$tick',@msgby='$AssngTo',@msg='$msg'");
	mssql_close($con);
}

}
else{
insert($_SESSION[tick],$_POST['msg'],$_SESSION[username],$con);
header('location:supportreport.php');
function insert($tick,$msg,$AssngTo,$con){
mssql_query("sp_post @tick='$tick',@msgby='$AssngTo',@msg='$msg'");
mssql_close($con);
}
}
?>
2

Maybe because you are calling insert() before you have described it?

Off Topic:

$ass?

3

^^ Not to mention you’re defining your function twice… and inside an if…then statement. Try this:


<?php
session_start();
include_once("conn.php");

function insertAss1($tick,$msg,$AssngTo,$pic,$status,$createby,$con){
    mssql_query("sp_assign @tick='$tick',@uname='$AssngTo',@pic='$pic',@stat='$status',@Create='$createby'");
    mssql_query("sp_post @tick='$tick',@msgby='$AssngTo',@msg='$msg'");
    mssql_close($con);
}

function insertAss2($tick,$msg,$AssngTo,$con){
    mssql_query("sp_post @tick='$tick',@msgby='$AssngTo',@msg='$msg'");
    mssql_close($con);
}

function countAsses() {
    $ass=mssql_query("Select * from tblAssign where TicketNo='$_SESSION[tick]' and AssignTo='$_SESSION[username]'");
    return mssql_num_rows($ass);
}

if (countAsses() < 1) {
    insertAss1($_SESSION[tick],$_POST['msg'],$_SESSION[username],$_POST['pic'],$_POST['status'],$_SESSION[name],$con);
    header('location:supportreport.php'); 
}
else{
    insertAss2($_SESSION[tick],$_POST['msg'],$_SESSION[username],$con);
    header('location:supportreport.php');
}
?>

:smiley:

4

Thanks Steve it works…