Posting into a MSSQL Database

[ScottieFromNM]

I am trying to post values into a mssql database and having some trouble. I create a detail_id in the first query and want to pass this detail_id to several other queries to insert into several other tables. It creates the detail_id in the first table, but doesn't pass it on, when I try to retrieve it. Here is my code:

------------------------------------------------------------------------------------------------------------------
$query1 = "INSERT INTO Detail(date_con tacted, user_id, issue_type, ref_by, contact_type, contact_descr, date_added, time_added)
VALUES '$date_contacte d','$REMOTE_USE R', '$issue_type_id ','$ref _type_id','$typ e_id','$contact _descr','$today ','$time')";

$mssql_result = mssql_query($qu ery1);

$get_id = "SELECT detail_id FROM Detail where issue_type='$is sue_type_id' and ref_by='$ref_ty pe_id'";

$mssql_result = mssql_query($ge t_id);
$row = mssql_fetch_ass oc ($mssql_result) ;
$NewDetail = intval ( $row['detail_id']);
$detail_id=$New Detail;

$query2 = "INSERT INTO Contact(detail_ id, user_id, date_contacted, contact_type, first_name, last_name, address, city, state, zip, email, phone, ext, alt_phone, contacted_by, start_time, end_time, total_time, email_content)

VALUES ($NewDetail, '$REMOTE_USER', '$date_contacte d','$type_id', '$first_name', '$last_name', '$address', '$city', '$state', '$zip', '$email', '$phone', '$ext', '$alt_phone', '$contacted_by_ id', '$start_time', '$end_time', '$total_time', '$email_content ')";

$mssql_result = mssql_query($qu ery2);
-------------------------------------------------------------------------------------------------------------------

The values from the form are going into the database, it just isn't getting the detail_id from the first query and putting into the second table.

Any help would be greatly appreciated!

[kovik]

MySQL has a nifty little function called mysql_insert_id () which gets the primary key value of the last insert statement. Just another reason MySQL is better. :-P

print_r($row) so that you can see if the data is even being retrieved.

[ScottieFromNM]

MySQL has a nifty little function called mysql_insert_id () which gets the primary key value of the last insert statement. Just another reason MySQL is better. :-P

print_r($row) so that you can see if the data is even being retrieved.

The data is going into the database, it is just not getting the detail_id from the previous query.

[kovik]

The data is going into the database, it is just not getting the detail_id from the previous query.

I didn't say the data wasn't going in, I'm saying that you might not be getting the data out. That's what $row is. print_r($row) and tell us what the contents are.

[ScottieFromNM]

I didn't say the data wasn't going in, I'm saying that you might not be getting the data out. That's what $row is. print_r($row) and tell us what the contents are.

I get the following error:
Warning: mssql_fetch_ass oc(): supplied argument is not a valid MS SQL-result resource in /var/www/html/victim/victim_form.php

[kovik]

I get the following error:
Warning: mssql_fetch_ass oc(): supplied argument is not a valid MS SQL-result resource in /var/www/html/victim/victim_form.php

-_-
What did you change? print_r() only prints data like echo, but prints the elements as well. All I want you to do is get the contents of $row displayed to the screen.

[ScottieFromNM]

-_-
What did you change? print_r() only prints data like echo, but prints the elements as well. All I want you to do is get the contents of $row displayed to the screen.

Okay get the following:

Array ( [detail_id] => 252 )

This is the same result every time I run the query.

[ScottieFromNM]

Okay get the following:

Array ( [detail_id] => 252 )

This is the same result every time I run the query.

It is now working. I guess the following line:

$get_id = "SELECT detail_id FROM Detail where issue_type='$is sue_type_id' and ref_by='$ref_ty pe_id'";

The "where" portion of this was causing the problem. Once I commented this out it started working. Thank you for your help on this issue.