AlliedModders - PHP+SQL Need help

I want get ID which have autoincrement value and save to variable because i want sue it in next table.

I dont knwo why it dont work and result is every time 0 or unknown value

I tried it rework 150x nothing works i really dont knwo where is problem :(

Im parsig variables here:

Code:

$url = filter_input_array( INPUT_GET );

                $url['sms'] = trim( $url['sms'] );

                $url['credit'] = intval( trim( $url['credit'] ) );

                $url['real_credit'] = intval( trim( $url['real_credit'] ) );

                $url['time'] = trim( $url['time'] );

                $url['id'] = intval( trim( $url['id'] ) );

                $url['customer_text'] = trim( $url['customer_text'] );

                $url['custom_NICK'] = trim( $url['custom_NICK'] );

                $url['custom_STEAMID'] = trim( $url['custom_STEAMID'] );

                $url['custom_PASSWORD'] = trim( $url['custom_PASSWORD'] );

                $url['refip'] = $_SERVER['REMOTE_ADDR'];

Here is main program:

Code:

$result = @mysql_query( "INSERT INTO `".$mysql_prefix."sms_keys` (`sms_text`, `sms_credit`, `sms_real_credit`, `sms_time`, `sms_id`, `sms_customer_text`, `sms_custom_nick`, `sms_custom_steamid`, `sms_custom_password`, `sms_refip`) VALUES ('".mysql_real_escape_string( $url['sms'] )."', '".mysql_real_escape_string( $url['credit'] )."', '".mysql_real_escape_string( $url['real_credit'] )."', '".$url['time']."', '".$url['id']."', '".mysql_real_escape_string( $url['customer_text'] )."', '".mysql_real_escape_string( $url['custom_NICK'] )."', '".mysql_real_escape_string( $url['custom_STEAMID'] )."', '".mysql_real_escape_string( $url['custom_PASSWORD'] )."', '".mysql_real_escape_string( $url['refip'] )."')" ) or die (mysql_error());

            logfile( "../log.txt", "a", " Write to Mysql Database Sucessfull!");

            mysql_close($db_connect);



            $mysqli2_host = "MOJHOST";

            $mysqli2_user = "MOJUSER";

            $mysqli2_pass = "MOJEHESLO";

            $mysqli2_name = "MOJEMENO";

            $mysql2_prefix = "MOJPREFIX";

        

            $db_connect2 = @mysql_connect( $mysqli2_host, $mysqli2_user, $mysqli2_pass );

            $db_select2 = @mysql_select_db( $mysqli2_name );



            if( !$db_connect2 || !$db_select2 )

                { 

                    logfile( "../log.txt", "a", "MySQL Connect Error (".mysql_error().") ".mysql_errno() );

                }

                else    

                {

                    $result = @mysql_query( "INSERT INTO `".$mysql2_prefix."amxadmins` (`username`, `password`, `access`, `flags`, `steamid`, `nickname`, `ashow`, `days`) VALUES ('".mysql_real_escape_string( $url['custom_NICK'] )."', '".mysql_real_escape_string( $url['custom_PASSWORD'] )."', '".mysql_real_escape_string( 'bnopqrstz')."', '".mysql_real_escape_string( 'a')."', '".mysql_real_escape_string( $url['custom_STEAMID'] )."', '".mysql_real_escape_string( $url['custom_NICK'] )."', '".mysql_real_escape_string( '0')."', '".mysql_real_escape_string( '30')."')" ) or die (mysql_error());                    

$id = @mysql_query( "SELECT `id` FROM `".$mysql2_prefix."amxadmins` WHERE (`username`, `password`, `access`, `flags`, `steamid`, `nickname`, `ashow`, `days`) = ('".mysql_real_escape_string( $url['custom_NICK'] )."', '".mysql_real_escape_string( $url['custom_PASSWORD'] )."', '".mysql_real_escape_string( 'bnopqrstz')."', '".mysql_real_escape_string( 'a')."', '".mysql_real_escape_string( $url['custom_STEAMID'] )."', '".$url['custom_NICK']."', '".mysql_real_escape_string( '0')."', '".mysql_real_escape_string( '30')."')" ) or die (mysql_error());                        

$id = (int) $row['id'];

$answer = "  ".$id." ";

exit( $answer );

                    $result2 = @mysql_query( "INSERT INTO `".$mysql2_prefix."admins_servers`(`admin_id`, `server_id`, `custom_flags`, `use_static_bantime`) VALUES ('".mysql_real_escape_string( '$id')."', '".mysql_real_escape_string( '6')."', '".mysql_real_escape_string( 'bnopqrstz')."', '".mysql_real_escape_string( 'no' )."') ") or die (mysql_error());

                    logfile( "../VIP_LOG/vip_act_log.txt", "a", "Write to Mysql Database Sucessfull! " );

When i remove

Code:

$id = (int) $row['id'];

I got this:

Code:

Resource id #9

(id is not good)

This works for me in phpmyadmin SQL it return good value in this example 67

Code:

SELECT `id` FROM `amx_amxadmins` WHERE (`username`, `password`, `access`, `flags`, `steamid`, `nickname`, `ashow`, `days`) = ("HODNOTA", "HODNOTA", "bnopqrstz", "a", "HODNOTA", "HODNOTA", "0", "30");

Can you help please? :cry: