· 7 years ago · Aug 28, 2018, 07:24 AM
1SQL Syntax with PHP [closed]
2$query = mysql_query("SELECT * FROM users_entity WHERE id = ".mysql_insert_id());
3
4$query = mysql_query("SELECT * FROM users_entity WHERE oauth_provider = 'twitter' AND oauth_id = ".$user_info->id);
5$result = mysql_fetch_array($query);
6
7// If not, let's add it to the database
8if(empty($result)){
9 $query = mysql_query("INSERT INTO users_entity (oauth_provider, oauth_id, oauth_username, oauth_token, oauth_secret) VALUES ('twitter', {$user_info->id}, '{$user_info->name}', '{$access_token['oauth_token']}', '{$access_token['oauth_token_secret']}')");
10$query = mysql_query("SELECT * FROM users_entity WHERE id = ".mysql_insert_id());
11
12SELECT ... WHERE id =