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!