insterting into table trouble

[mrfatass]

well i made form and im trying to instert into my table but it doesnt seem to be working just says

The query is:
INSERT into roster values ('jhgjhg', 'ghgh', 'ghgh', 'ghgh', 'ghg', 'hghg', 'hgh', 'ghgh', 'ghg', 'hg', 'hghg', 'hghg', 'hgh', '', 'ghghg', 'hg', 'hghg', 'hghg', 'hghg', 'hggh', 'hgh', 'ghgh', 'ghgh', 'ghg', 'hgh', 'hgh')
The query could not be executed

here is the form itself

<form method="post" action="/ecl/admin/index.php?pid=roster_handle">

<table>
<tr>
<td>

&nbsp; Alias:</td><td> <input type="Text" name="Array[alias]" size="41">
</td>
</tr>
<tr>
<td>
&nbsp; First name:</td><td>  <input type="Text" name="Array[first]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Last name: </td><td><input type="Text" name="Array[last]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Position:</td><td> <input type="Text" name="Array[position]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Email:</td><td> <input type="Text" name="Array[email]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Location:</td><td> <input type="Text" name="Array[location]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Favorite Weapon:</td><td> <input type="Text" name="Array[weapon]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Favorite Map:</td><td> <input type="Text" name="Array[map]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Quote:</td><td> <input type="Text" name="Array[quote]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Windows Sensitivity:</td><td> <input type="Text" name="Array[sensitivity]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; CS Sensitivity:</td><td> <input type="Text" name="Array[cssensitivity]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; CS Resolution:</td><td> <input type="Text" name="Array[resolution]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Extra Mouse Settings:</td><td> <input type="Text" name="Array[extramousesettings]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Refresh Rate:</td><td> <input type="Text" name="Array[refreshrate]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Vsync Setting:</td><td> <input type="Text" name="Array[vsync]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Manufacturer:</td><td> <input type="Text" name="Array[manufacturer]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Operating System:</td><td> <input type="Text" name="Array[os]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; CPU:</td><td> <input type="Text" name="Array[cpu]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Memory:</td><td> <input type="Text" name="Array[memory]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; HardDrive:</td><td> <input type="Text" name="Array[harddrive]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Video Card:</td><td> <input type="Text" name="Array[videocard]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Sound Card:</td><td> <input type="Text" name="Array[soundcard]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Moniter:</td><td> <input type="Text" name="Array[moniter]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Keyboard:</td><td> <input type="Text" name="Array[keyboard]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Mouse:</td><td> <input type="Text" name="Array[mouse]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; Mousepad:</td><td> <input type="Text" name="Array[mousepad]" size="41"></td>
</tr>
<tr>
<td>

&nbsp; CS Career:</td><td> <textarea rows="7" cols="40" name="Array[career]"></textarea></td>
</tr>
<tr>
<td>

&nbsp; Submit:</td><td> <input type="Submit" name="submit" value="Enter information"></td>
</tr>
</table>

</form>

and the handle page

<?

/* this page receives and handles the information generated by roster_form.php */

// trim the incoming data

$Array["alias"] = trim
($Array["alias"]);

$Array["first"] = trim
($Array["first"]);

$Array["last"] = trim
($Array["last"]);

$Array["position"] = trim
($Array["position"]);

$Array["email"] = trim
($Array["email"]);

$Array["location"] = trim
($Array["location"]);

$Array["weapon"] = trim
($Array["weapon"]);

$Array["map"] = trim
($Array["map"]);

$Array["quote"] = trim
($Array["quote"]);

$Array["sensitivity"] = trim
($Array["sensitivity"]);

$Array["cssensitivity"] = trim
($Array["cssensitivity"]);

$Array["extramousesettings"] = trim
($Array["extramousesettings"]);

$Array["refreshrate"] = trim
($Array["refreshrate"]);

$Array["vsync"] = trim
($Array["vysnc"]);

$Array["manufacturer"] = trim
($Array["manufacturer"]);

$Array["os"] = trim
($Array["os"]);

$Array["cpu"] = trim
($Array["cpu"]);

$Array["memory"] = trim
($Array["memory"]);

$Array["harddrive"] = trim
($Array["harddrive"]);

$Array["videocard"] = trim
($Array["videocard"]);

$Array["soundcard"] = trim
($Array["soundcard"]);

$Array["moniter"] = trim
($Array["moniter"]);

$Array["keyboard"] = trim
($Array["keyboard"]);

$Array["mouse"] = trim
($Array["mouse"]);

$Array["mousepad"] = trim
($Array["mousepad"]);

$Array["career"] = trim
($Array["career"]);

// set the variables for the database access

$Host = "localhost";

$User = "***";

$Password = "***";

$DBName = "****";

$TableName = "roster";


$Link = mysql_connect ($Host, $User, $Password);

$Query = "INSERT into $TableName values ('$Array[alias]', '$Array[first]', '$Array[last]', '$Array[position]', '$Array[email]', '$Array[location]', '$Array[weapon]', '$Array[map]', 
'$Array[quote]', '$Array[sensitivity]', '$Array[cssensitivity]', '$Array[extramousesettings]', '$Array[refreshrate]', '$Array[vsync]', '$Array[manufacturer]', '$Array[os]', '$Array[cpu]', 
'$Array[memory]', '$Array[harddrive]', '$Array[videocard]', '$Array[soundcard]', '$Array[moniter]', '$Array[keyboard]', '$Array[mouse]', '$Array[mousepad]', '$Array[career]')";

print ("The query is:<br>$Query<p>\n");

if (mysql_db_query ($DBName, $Query, $Link)) {
	print ("The query was successfully executed<br>\n");
} else {
	print ("The query could not be executed<br>\n");

}
mysql_close ($Link);

[DougieC]

Try this
INSERT into roster ( the, name, of, your, columns)
Values (the, values, for, each, column)

and you should add this when you do a query for example
$result = mysql_query($sql) or die("Invalid Insert: " . mysql_error() );
it gives an error message

[mrfatass]

so is should look like this?

<?

/* this page receives and handles the information generated by roster_form.php */

// trim the incoming data

$Array["alias"] = trim
($Array["alias"]);

$Array["first"] = trim
($Array["first"]);

$Array["last"] = trim
($Array["last"]);

$Array["position"] = trim
($Array["position"]);

$Array["email"] = trim
($Array["email"]);

$Array["location"] = trim
($Array["location"]);

$Array["weapon"] = trim
($Array["weapon"]);

$Array["map"] = trim
($Array["map"]);

$Array["quote"] = trim
($Array["quote"]);

$Array["sensitivity"] = trim
($Array["sensitivity"]);

$Array["cssensitivity"] = trim
($Array["cssensitivity"]);

$Array["extramousesettings"] = trim
($Array["extramousesettings"]);

$Array["refreshrate"] = trim
($Array["refreshrate"]);

$Array["vsync"] = trim
($Array["vysnc"]);

$Array["manufacturer"] = trim
($Array["manufacturer"]);

$Array["os"] = trim
($Array["os"]);

$Array["cpu"] = trim
($Array["cpu"]);

$Array["memory"] = trim
($Array["memory"]);

$Array["harddrive"] = trim
($Array["harddrive"]);

$Array["videocard"] = trim
($Array["videocard"]);

$Array["soundcard"] = trim
($Array["soundcard"]);

$Array["moniter"] = trim
($Array["moniter"]);

$Array["keyboard"] = trim
($Array["keyboard"]);

$Array["mouse"] = trim
($Array["mouse"]);

$Array["mousepad"] = trim
($Array["mousepad"]);

$Array["career"] = trim
($Array["career"]);

// set the variables for the database access

$Host = "localhost";

$User = "****";

$Password = "******";

$DBName = "******";

$TableName = "roster";


$Link = mysql_connect ($Host, $User, $Password);

$Query = "INSERT into roster ('alias', 'FIRST', 'last', 'position', 'email', 'location', 'weapon', 'map', 'quote', 'sensitivity', 'cssensitivity', 'resolution', 'extramousesettings', 'refreshrate', 'vsync', 'manufacturer', 'os', 'cpu', 'memory', 'harddrive', 'videocard', 'soundcard', 'moniter', 'keyboard', 'mouse', 'mousepad', 'career') values ('$Array[alias]', '$Array[first]', '$Array[last]', '$Array[position]', '$Array[email]', '$Array[location]', '$Array[weapon]', '$Array[map]', 
'$Array[quote]', '$Array[sensitivity]', '$Array[cssensitivity]', '$Array[extramousesettings]', '$Array[refreshrate]', '$Array[vsync]', '$Array[manufacturer]', '$Array[os]', '$Array[cpu]', 
'$Array[memory]', '$Array[harddrive]', '$Array[videocard]', '$Array[soundcard]', '$Array[moniter]', '$Array[keyboard]', '$Array[mouse]', '$Array[mousepad]', '$Array[career]')";

print ("The query is:<br>$Query<p>\n");

if (mysql_db_query ($DBName, $Query, $Link)) {
	print ("The query was successfully executed<br>\n");
} else {
	print ("The query could not be executed<br>\n");

}

$result = mysql_query($sql) or die("Invalid Insert: " . mysql_error() ); 

mysql_close ($Link);
?>

[DougieC]

Sorry man the last part wasent very clear.
$result = mysql_query($sql) or die("Invalid Insert: " . mysql_error() );
is just an example to show the "or die("Invalid Insert: " . mysql_error() );" part of the query
in your case it should be

$result = mysql_db_query ($DBName, $Query, $Link) or die("Invalid Insert: " . mysql_error() );

without the if else clause
Your insert looks right to me now.

[mrfatass]

ok now when i input information into the form i get this

The query is:
INSERT into roster ('alias', 'FIRST', 'last', 'position', 'email', 'location', 'weapon', 'map', 'quote', 'sensitivity', 'cssensitivity', 'resolution', 'extramousesettings', 'refreshrate', 'vsync', 'manufacturer', 'os', 'cpu', 'memory', 'harddrive', 'videocard', 'soundcard', 'moniter', 'keyboard', 'mouse', 'mousepad', 'career') values ('g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', '', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g', 'g')
The query could not be executed
Invalid Insert: You have an error in your SQL syntax near ''alias', 'FIRST', 'last', 'position', 'email', 'location', 'weapon', 'map', 'quo' at line 1

Create table roster (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, alias varchar(50), first varchar(50), last varchar(50), position varchar(50), email varchar(50), location varchar(50), weapon varchar(50), map varchar(50), quote varchar(50), sensitivity varchar(50), cssensitivity varchar(50), resolution varchar(50), extramousesettings varchar(50), refreshrate varchar(50), vsync varchar(50), manufacturer varchar(50), os varchar(50), cpu varchar(50), memory varchar(50), harddrive varchar(50), videocard varchar(50), soundcard varchar(50), moniter varchar(50), keyboard varchar(50), mouse varchar(50), mousepad varchar(50), career TEXT)

i cant seem to find the error =/

[DougieC]

Well Dude you have 27 coloumn values and only 26 insert values
They need to be the same amount or it wont work 😉
For example:

Insert into blahblah ('col 1', 'col 2')
values ('value 1', 'value2')
if the value is null, it still needs to be in there eg ('value 1', ' ')

By the way does this forum seem to be really wide or is it just me?