Adding unknown amt of rows to database

[Anon]

Is there a way that I can automate the below?

The max I will need is $d20.

if ($d1 != ""){
mysql_query ("INSERT INTO GR (playerid, gameid) VALUES ('$d1' ,'$gameid')");

}
if ($d2 != ""){
mysql_query ("INSERT INTO GR (playerid, gameid) VALUES ('$d2' ,'$gameid')");

}
if ($d3 != ""){
mysql_query ("INSERT INTO GR (playerid, gameid) VALUES ('$d3' ,'$gameid')");

}
if ($d4 != ""){
mysql_query ("INSERT INTO GR (playerid, gameid) VALUES ('$d4' ,'$gameid')");

}

---

Also, I have an unknown amount of fields that could be added to this database. I am using check boxes. The only way I found to automate this was to have a variable be the text box name and have it +1 every new row. Thus I get d1 d2 d3 d4 etc. Is there a better way?

Thanks.

[Anon]

Tip: Learn the array function:
Se: http://www.php.net/array

#

Example of how to read the data..

#
$i=0;
while($i < 21) {
if ( !($d[$i])) {

or you can use this:

if ($d[$i] != "") {

mysql_query ("INSERT INTO GR (playerid, gameid) VALUES ('$d[$i]' ,'$gameid')");
$i++;
}
}
#

The script above loops until $i = 21.

#

Note: You must write your

variables in arrays. You can

do it like this:

#
$d["1"] = "variable";
$d["2"] = "variable";
$d["3"] = "variable";
$d["4"] = "variable";

[marty_arl]

the best advice that i can give you is to first put the values into an array, and then preform whatever you want to do with the values once theyre in there. makes the code more readable, and in most cases, it makes it shorter.

$darray[0]=$d1;
$darray[1]=$d2;
$darray[2]=$d3;
...
$darray[19]=$d20;

foreach ($darray as $something)
{
if ($something != "")
{
mysql_query ("INSERT INTO GR (playerid,gameid) VALUES ('$something' ,'$gameid')");
}
}

hope this helps,
marty vw