[Resolved] iframe vs ?

lmayer4

Morning,

General question:

I have a form that needs to have a tracking number attached. The ideal way to go would be create on insert but I can't make that work because of the dynamic insert script I have, which I've attached.

The other option I have is using an iframe instead but I can't make that work either.

Can anyone point me in the right direction?

Thanks so much.

Laura

alexu_

Your insert() function could return the inserted ID after running the query.

return mssql_insert_id();

so you can get this value from outside the class and pass it further. I don't know more about your form, so this is all I can say.

AstroTeg

You need to tweak your insert function to return the auto incremented ID (or in this case, the tracking number). If I remember correctly, with MS SQL, you had to do the insert, keep the same session open, and then run SELECT @@IDENTITY and the value of this 2nd query would be your auto increment ID. But its been a while. You should probably search google which should have all sorts of info on this.

AstroTeg

Originally posted by alexu'

return mssql_insert_id();

I did a search on php.net and that function is not built into PHP's MS SQL function set. I think you might be thinking of MySQL which has mysql_insert_id().

alexu_

You are right, on MS SQL the only solution is the one with "SELECT @@IDENTITY".

my mistake

lmayer4

So if I'm understanding what you are saying is that the last function:

function insert($table, $fld, $val)
{
$query = "INSERT INTO $table (%s) VALUES (%s)";
$query = sprintf($query, implode(",", $fld), implode(",", $val));
$result = mssql_query($query) or die;

should be kept open before I pass the $result and manipulate the tracking number then?

alexu_

no... you should return at the end:

function insert($table, $fld, $val)
{
$query = "INSERT INTO $table (%s) VALUES (%s)";
$query = sprintf($query, implode(",", $fld), implode(",", $val));
$result = mssql_query($query) or die;
....

$ret_result=mssql_query("SELECT @@IDENTITY");
return mssql_result($ret_result,0,0);
}

and be careful not to close the connection before that

lmayer4

Oh I see what your doing! The problem is I need to take that and make it a tracking number that can be referenced for the user. So it has to go into the table as well.

lmayer4

Thanks for all your help. I figured it out. I was, as usual making it wayyy to difficult. I already had RequestID which is an identity field being inserted so I just pulled that.

Need a caffeine injection or something. I didn't know about the select @@identity so I even learned something today!

Thanks so much again.

Laura