Inserting into database problem

[Mark_Nordstrom]

<?php  

if (isset($_POST["submit"])) {  

$db=mysql_connect("localhost", "user","pass");  

mysql_select_db("database",$db);  

$sql = "INSERT INTO stats (name, team, pos, ab, hits) VALUES  ('$name','$team','$pos','$ab','$hits','$name2','$t
eam2','$pos2','$ab2','$hits2')"; 
$result = mysql_query($sql);  

echo "There you go.\n";  

}  

else {  

?>  

What is wrong with this ?? I get no errors when inserting but it does not put data into database.

[Radon3k]

Try making it just:

<?php if($_POST['submit'] == "VALUE FOR SUBMIT BUTTON") { ?>

[Mark_Nordstrom]

Nope dont work. What im trying to do is say i make a form. theres 2 players names. I want 2 rows entered. BUT i want all the rows to have same GAMEID #. I can get 2 rows entered if i use 2 querys but i wanna do it with 1 query

[seby]

the problem probably is in the form. Post the form (more code..)

[Mark_Nordstrom]

<form method="post" action="<?php echo $PHP_SELF?>">
<br>
<table width="90%" border="1">
<tr>
<td width="31%">Name</td>
</tr>
<tr>
<td><input name="gameid" type="hidden" id="gameid"> <select name="name" id="name">
<?php
do {

?>
<option value="<?php echo $row_player['name']?>"><?php echo $row_player['name']?></option>
<?php
} while ($row_player = mysql_fetch_assoc($player));
$rows = mysql_num_rows($player);
if($rows > 0) {
mysql_data_seek($player, 0);
$row_player = mysql_fetch_assoc($player);
}
?>
</select></td>
</tr>
<tr>
<td height="28"><input name="gameid2" type="hidden" id="gameid2"> <select name="name2" id="name2">
<?php
do {

?>
<option value="<?php echo $row_player['name']?>"><?php echo $row_player['name']?></option>
<?php
} while ($row_player = mysql_fetch_assoc($player));
$rows = mysql_num_rows($player);
if($rows > 0) {
mysql_data_seek($player, 0);
$row_player = mysql_fetch_assoc($player);
}
?>
</select></td>
</tr>
</table>
<p><br>
</p>
<p><br>
<br>
<input type="submit" name="submit" value="Submit">
</p>
</form>

Im using some PHP To fill the drop down menus

[altexis]

1) $result = mysql_query($sql);
insert sql statements don't have results .. so just leave it as
mysql_query($sql);

2) you dont get an error statement because you don't ask for it, so rewrite your query command to:
mysql_query($sql) or die(mysql_error());

3) does your php server has magic quotes on???
IF NOT: then a user will eventually use quotes or backslashes and throw your script, so use the mysql_escape_string() function before each variable:
$sql = "INSERT INTO stats (name, team, pos, ab, hits) VALUES ('".mysql_escape_string($name)."','".mysql_escape_string($team)."','".mysql_escape_string($pos)."', ...

note: mysql_escape_string() is equivalent to addslashes() but prefer it because addslashes() has some problems with certain code pages

[tsinka]

Hi,

I think there is an error in your insert statement. Extend your mysql_query to:

$result = mysql_query("...") or die("Error: ".mysql_error()."<br>\n";

The problem I see is that you selected four fields in your query for insertion but try to insert data into more than four fields.

Change your query so that it includes all fields, e.g.

$sql = <<< EOSQL
INSERT INTO stats 
(name, team, pos, ab, hits,name2,team2,pos2,ab2,hits2) 
VALUES
('$name','$team','$pos','$ab','$hits','$name2','$team2','$pos2','$ab2','$hits2')
EOSQL;

or

$sql = <<< EOSQL
INSERT INTO stats 
(name, team, pos, ab, hits)
VALUES
('$name','$team','$pos','$ab','$hits'),
('$name2','$team2','$pos2','$ab2','$hits2')
EOSQL;

if you want to insert two rows into the table.