[cohan1279]

Im trying to update a column in a table, thruogh a signup. basicly its for counting members.

PHP Code:

function saveCountryData (&$country, $data)
{
    global $countrydb, $lockdb;
    if ($lockdb)
        return;
    $items = explode(" ",$data);
    $update = "";
    $i = 0;
    while ($tmp = $items[$i++])
    {
        $data = $country[$tmp];
        if (is_numeric($data))
            $update .= "$tmp=$data";
        else
        {
            sqlQuotes($country[$tmp]);
            $update .= "$tmp='$data'";
        }
        if ($items[$i]) $update .= ",";
    } 


PHP Code:

    
    
      mysql_query("INSERT INTO $countrydb (members);");
    $ucountry = loadCountry(mysql_insert_id());
    
    $ucountry = $ucountry++;
    saveCountryData($ucountry,"members"); 


CREATE TABLE country (
  id tinyint unsigned NOT NULL auto_increment,
  name tinytext NOT NULL,
  pres mediumint unsigned NOT NULL default 0,
  vpres mediumint unsigned NOT NULL default 0,
  gov mediumint unsigned NOT NULL default 0,
  tres mediumint unsigned NOT NULL default 0,
  ally1 smallint unsigned NOT NULL default 0,
  ally2 smallint unsigned NOT NULL default 0,
  ally3 smallint unsigned NOT NULL default 0,
  war1 smallint unsigned NOT NULL default 0,
  war2 smallint unsigned NOT NULL default 0,
  war3 smallint unsigned NOT NULL default 0,
  cash bigint unsigned NOT NULL default 100000,
  peasants bigint unsigned NOT NULL default 1000,
  omistrp bigint unsigned NOT NULL default 0,
  dmistrp bigint unsigned NOT NULL default 0,
  armtrp bigint unsigned NOT NULL default 0,
  lndtrp bigint unsigned NOT NULL default 0,
  flytrp bigint unsigned NOT NULL default 0,
  seatrp bigint unsigned NOT NULL default 0,
  wizards bigint unsigned NOT NULL default 0,
  offense float(5,3) NOT NULL default 1.000,
  defense float(5,3) NOT NULL default 1.000,
  bpt float(5,3) NOT NULL default 1.000,
  costs float(5,3) NOT NULL default 1.000,
  magic float(5,3) NOT NULL default 1.000,
  ind float(5,3) NOT NULL default 1.000,
  pci float(5,3) NOT NULL default 1.000,
  expl float(5,3) NOT NULL default 1.000,
  mkt float(5,3) NOT NULL default 1.000,
  food float(5,3) NOT NULL default 1.000,
  runes float(5,3) NOT NULL default 1.000,
  farms float(5,3) NOT NULL default 1.000,
  pic tinytext NOT NULL,
  url tinytext NOT NULL,
  motd text NOT NULL,
  members smallint NOT NULL default 0,
  tag tinytext NOT NULL,
  password tinytext NOT NULL,
  PRIMARY KEY (id)
) TYPE=MyISAM;

ok im very new to php and mysql whats wrong with this code? i cant seem to update members no matter what i try.....


FATAL ERROR: Failed to update country data members='' for country #!

Please help!