Create gang not working :/

[WarMad]

im not sure whats wrong it says gang created but all it does is take the money and does not inter in into the database not the info under users or under gangs

 

global $ir, $userid;
$c= 1000000;
if($ir['money'] < $c)
{
die("You don't have enough money. You need \${$c}.");
}
if($ir['gang'])
{
die ("You're already in a gang!");
}
if($_POST['submit'])
{
$name=htmlspecialchars($_POST['name']);
$desc=htmlspecialchars($_POST['desc']);
mysql_query("INSERT INTO gangs VALUES('','$name','$desc','','','','',0,0,100,$userid,$userid,5,0,0,'')");
$i=mysql_insert_id();
mysql_query("UPDATE users SET gang=$i,money=money-$c where userid=$userid");
echo "gang created!";
}
else
{
echo "<h3> Create A gang</h3><form action='creategang.php' method='post'>
<input type='hidden' name='submit' value='1' />Name:<input type='text' name='name' /><br />
Description:<br /> <textarea name='desc' cols='40' rows='7'></textarea> 
<br /><input type='submit' value='Create gang for \${$c}' /></form>";
}

[Guest]

Turn on errors, look through the logs find the error

[SRB]

Add error reporting to this line;

 

mysql_query("INSERT INTO gangs VALUES('','$name','$desc','','','','',0,0,100,$userid,$userid,5,0,0,'')");

 

To become;

 

mysql_query("INSERT INTO gangs VALUES('','$name','$desc','','','','',0,0,100,$userid,$userid,5,0,0,'')") or die (mysql_error());

 

And see what error it tells you.

[WarMad]

doing that now thanks lol i havent coded in a while im trying to get back into it still refreshing my mind

[WarMad]

thanks guys i fixed it

[SRB]

Problem was?

I am guessing incorrect column count...

[WarMad]

ya thats exactly what it was

- - - Updated - - -

ya thats exactly what it was