Starting to get desperate (need other PHP coders)

[CobraCom]

I'm starting to get desperate so I need help from other good PHP programmers.
I'm working on a registration page, which works except for this problem:

Registering an account into Account.dbo works, but then the code needs to fetch the AID from that table,
and register it into Login.dbo with that AID value.
The AID never gets caught, and using var_dump($aid), results in "NULL".

This is the code I'm using: (not the full code ofcourse).

$selAcq = mssql_query("SELECT AID FROM Account WHERE UserID='$name'");
$aid = $selAcq['AID'];
echo $aid;
$inLog  = "INSERT INTO Login(AID,UserId,Password,LastIP) VALUES('$aid','$name','$pass','$ip')";
mssql_query($inLog);

If anyone has the answer, post it.

[MentaL]

[Lambda]

I'm starting to get desperate so I need help from other good PHP programmers.
I'm working on a registration page, which works except for this problem:

Registering an account into Account.dbo works, but then the code needs to fetch the AID from that table,
and register it into Login.dbo with that AID value.
The AID never gets caught, and using var_dump($aid), results in "NULL".

This is the code I'm using: (not the full code ofcourse).

$selAcq = mssql_query("SELECT AID FROM Account WHERE UserID='$name'");
$aid = $selAcq['AID'];
echo $aid;
$inLog  = "INSERT INTO Login(AID,UserId,Password,LastIP) VALUES('$aid','$name','$pass','$ip')";
mssql_query($inLog);

If anyone has the answer, post it.

you need to fetch the result.

$selAcq = mssql_query("SELECT AID FROM Account WHERE UserID='$name'");
$fetch = mssql_fetch_array( $selAcq );
$aid = $fetch['AID'];
echo $aid;
$inLog = "INSERT INTO Login(AID,UserId,Password,LastIP) VALUES('$aid','$name','$pass','$ip')";
mssql_query($inLog);

[Asumi]

Lambda plz read my pm i send to you it's about something personal not any question about gunz or something just read

[CobraCom]

you need to fech the result.

That worked. Also, not to be rude, but didnt you quit gunz?

[wesman2232]

That worked. Also, not to be rude, but didnt you quit gunz?

Lambda is comming back cause he has the latest server files and official MAIET documents.

[bunny1995]

This might help you, http://forum.ragezone.com/f497/insta...server-518187/
and you need the final revolution gunz web maded by ~DN try searching i`m not sure if the post is still there.

[Solaire]

That worked. Also, not to be rude, but didnt you quit gunz?

Better do it in ODBC though.

$query = odbc_exec($connect,"SELECT AID FROM Account WHERE UserID = '$name'");
odbc_fetch_row($query);
$aid = odbc_result($query, 1);