[shuttle_wave]

this code doesnt seem to update the status colum where steam id =...

PHP Code:

    if ($matches[1] == "Successful")
    {
        mysql_select_db(SQL_DB, $sql_conn);
        mysql_query("UPDATE inviter SET Status = 'INVITED'
WHERE Steamid = '%s';", $invite_steam_id);
    } 


[joaquimandrade]

PHP Code:

    if ($matches[1] == "Successful")
    {
        mysql_select_db(SQL_DB, $sql_conn);
        mysql_query(sprintf("UPDATE inviter SET Status = 'INVITED'
WHERE Steamid = '%s';", $invite_steam_id));
    } 


[lynettekecds]

Originally Posted by joaquimandrade if ($matches[1] == "Successful") { mysql_select_db(SQL_DB, $sql_conn); mysql_query(sprintf("UPDATE inviter SET Status = 'INVITED' WHERE Steamid = '%s';", $invite_steam_id)); } [/code]

I do not fully understand the sample, Could you give more details? Would you pls offer the related documentation?

[Seta00]

Originally Posted by lynettekecds I do not fully understand the sample, Could you give more details? Would you pls offer the related documentation?

http://linux.die.net/man/3/sprintf

[Styles]

Most people don't use string formating in php, why not sure, it's just not that common. Most people just do something like

"UPDATE inviter SET Status = 'INVITED'
WHERE Steamid = '". mysql_real_string_escape($var) . "'"

Remember to use mysql_real_string_escape on ANY variable RIGHT before it gets inserted! Otherwise you can be vulnerable to sql injections. Writing a small class to handle all db interactions is probably a good idea.