Page 1 of 1

UPDATE a row with info that was just inserted.

Posted: Mon Dec 05, 2005 4:25 am
by davidprogramer

Code: Select all

echo "player id: $player_id<br>";
		echo "clan tag : $clan_tag<br>";
		echo "clan_name : $clan_name<br><br>";

		$sql_clans = 'SELECT * FROM `'.$sql_prefix.'_clans` WHERE `clan_tag` = `'.$clan_tag.'` '; 
		
		//store the query into a result 
		//perform the query 
		$result_clans = mysql_query($sql_clans) or die('SQL ['.$sql_clans.'] caused: '. mysql_error()); 

		echo "player id: $player_id<br>";
		echo "clan tag : $clan_tag<br>";
		echo "clan_name : $clan_name<br>";
		echo "clan_id : $clan_id<br>";
Output:
player id: 1
clan tag : {DOW}
clan_name : Dogs of War

SQL [SELECT * FROM `css_clans` WHERE `clan_tag` = `{DOW}` ] caused: Unknown column '{DOW}' in 'where clause'

Re: UPDATE a row with info that was just inserted.

Posted: Mon Dec 05, 2005 5:08 am
by foobar
There's an error in your SQL syntax:

Code: Select all

$sql_clans = 'SELECT * FROM `'.$sql_prefix.'_clans` WHERE `clan_tag` = "'.$clan_tag.'" ';
Table and field (column) names are quoted with `backticks` if at all. Strings are quoted with eithe 'single' or "double" quotes.

Posted: Mon Dec 05, 2005 5:15 am
by m3mn0n
Indeed. You don't need to refresh the page or anything, as long as the extraction is done after the insertion, you should be fine.

Posted: Mon Dec 05, 2005 5:36 am
by davidprogramer
I got as far as getting the clan id labeled as an unknown column. Shiznatix is helpin me out BIG time! Thanks guys.

Code: Select all

$sql = ' 
  INSERT INTO 
    '.$sql_prefix.'_clans 
      ( 
        `clan_name`, 
        `clan_tag`, 
        `clan_leader`, 
        `recieve_challenges`, 
        `clan_email`, 
        `clan_website`, 
        `clan_aim`, 
        `clan_msnm`, 
        `clan_icq`, 
        `clan_yim`, 
        `clan_xfire`, 
        `clan_viewemail` 
      ) 
VALUES 
      ( 
        "'.$clan_name.'", 
        "'.$clan_tag.'", 
        "'.$player_id.'", 
        "'.$clan_challenge.'", 
        "'.$clan_email.'", 
        "'.$clan_website.'", 
        "'.$clan_aim.'", 
        "'.$clan_msnm.'", 
        "'.$clan_icq.'", 
        "'.$clan_yim.'", 
        "'.$clan_xfire.'", 
        "'.$clan_viewemail.'" 
      ) 
'; 

$join_league = mysql_query($sql) or die(mysql_error().'  -> '.__LINE__);

$lastid = mysql_insert_id(); 
$sql = ' 
  SELECT 
    * 
  FROM 
    '.$sql_prefix.'_clans 
  WHERE 
    clan_id = "'.$lastid.'" 
'; 
$query = mysql_query($sql) or die(mysql_error().'  -> '.__LINE__);
		echo "player id: $player_id<br>";
		echo "clan tag : $clan_tag<br>";
		echo "clan_name : $clan_name<br>";
		
		$info = mysql_fetch_assoc($query);
		$clan_id = $info['clan_id'];
		$sql = 'SELECT * FROM `'.$sql_prefix.'_clans` WHERE clan_id = "'.$lastid.'" ';
		
		//store the query into a result 
		//perform the query 
		$query = mysql_query($sql) or die(mysql_error().'  -> '.__LINE__);
		echo "player id: $player_id<br>";
		echo "clan tag : $clan_tag<br>";
		echo "clan_name : $clan_name<br>";
		echo "clan_id : $clan_id<br>";
		
		$sql_players_update = mysql_query("UPDATE ".$sql_prefix."_players SET clan_id = '$clan_id' WHERE player_id = '$player_id'") or die(mysql_error().'  -> '.__LINE__);
FIXED!!! THANK YOU SHIZNATIX!