Write SQL Query PHP Comform?

[equipment]

This is something I put together, I would like to know, how does it have to be rewritten to be PHP comform?

 

    # The Insertion Into the Database
    
    
    
    $db_connect = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
    

    
    $sql_query = sprintf(
            
            "set @newid = convert(
                
              ( select 
               max(convert( (substring(tag_id, 2)) , unsigned integer))+1
               from tags), char(10) );

                set @newid = if(length(@newid) = 1, concat('0', @newid), @newid);
                set @newid = concat('c', @newid);

                INSERT INTO tags (tag_id, tag_name, tag_description, added_by_user_id,
                                creation_date, last_edited)
                VALUES (@newid, '%s', '%s', 7, now(), '0')",
            
                mysqli_real_escape_string($db_connect, $tag_name),
                mysqli_real_escape_string($db_connect, $tag_description)
            
            
            );
    
    $sql_query_run = mysqli_query($db_connect, $sql_query);

 

As of yet I could execute the script and would not get error messages, though also no data would be entered into the table.

[requinix]

If by "PHP comform" you mean "work", then

 

mysqli_query() can't run multiple queries. Luckily mysqli_multi_query can.

[equipment]

Thanks a lot, worked like a charm.

 

It can be that easy as well.