SELECT SCOPE_IDENTITY() with PHP....ahhhhh!

This message is being cross posted to:

alt.comp.lang.php
alt.php.sql
microsoft.public.sqlserver.programming


I have two tables, bars & contacts. Using 1 form to input information about
both the bar and the contact I need to be sure that the contact_id for that
session is input in the appropriate bar_id. Seems easy enough...... I was
told to use SCOPE_IDENTITY, however, I can't seem to get any identity
besides null. I have emailed by host to see how to set up an identity
column, but have not heard from them yet. Right now bar_id and contact_id
are set as auto_increment fields.....

Can anyone help? The source is at sevennites.com/new/insert.html (view
source).
The form is at sevennites.com/new/add.php3

Thank you!

Could you show the SQL code you are actually using???

--
http://www.aspfaq.com/
(Reverse address to reply.)




"Rizyak" <ryan@latitude47.com> wrote in message
news:ca299t$s6m$1@nntp1.u.washington.edu...
> This message is being cross posted to:
>
> alt.comp.lang.php
> alt.php.sql
> microsoft.public.sqlserver.programming
>
>
> I have two tables, bars & contacts. Using 1 form to input information
about
> both the bar and the contact I need to be sure that the contact_id for
that
> session is input in the appropriate bar_id. Seems easy enough...... I was
> told to use SCOPE_IDENTITY, however, I can't seem to get any identity
> besides null. I have emailed by host to see how to set up an identity
> column, but have not heard from them yet. Right now bar_id and contact_id
> are set as auto_increment fields.....
>
> Can anyone help? The source is at sevennites.com/new/insert.html (view
> source).
> The form is at sevennites.com/new/add.php3
>
> Thank you!
>
>