arrays in queries

Anon

I want to use an array inside of my query like this:

mysql_query ("INSERT INTO player VALUES ( '','Y', '$player_array[1][1]')");

But When I run this I get only Array[1] inside of my table, not the actual player name... If I use echo $player_array[1][1] I do get the right value... What am I missing here?

Thanks

kostik

Try to write the query with quotes inside:

'".$player_array[1][1]."'

Anon

Try putting curly brackets around any array or object references in strings like this:

mysql_query ("INSERT INTO player VALUES ( '','Y', '{$player_array[1][1]}')");

That way, the interpreter knows exactly what the name of the variable is and can substitute the value without you having to drop out of the string.

Anon

Yeah!

{} worked perfectly!

On the same note, I have 18 elements in each subarray, how can I loop inside of the array without having to explicitely write each value $player_array[$i][1...18]?

Can I put PHP loops inside of SQL or do I have to use SQL code for that?

th4nx

amarok

$player_array[$i][1...18]

The best way I can think of is to put everything in a string first. You can then use foreach to loop through values:

$sql="INSERT INTO player VALUES";
foreach ($player_array as $player) {
foreach($player as $item) {
$sql.=" ( '','Y', '$item'),";
}
}

This will give you a trailing "," which you can get rid of with:

$sql=preg_replace(",$", "", $sql);

and then execute the query:

mysql_query($sql);

Hope this works, I haven't tested it! Incidentally, I find it useful always to put queries into a variable first, and then pass the variable to mysql(), rather than a literal string. That way, if anything goes wrong wit your query, you can echo it out.

Good luck!