Help with variables and combining variables

[Darkmatter5]

Here's my code:

 

$query1="UPDATE games SET title='$_POST[title]', descr='$_POST[descr]' WHERE game_id=$rowcon[game_id]";
$query2="UPDATE game_genres SET genre_id='$_POST[genre]' WHERE game_id=$rowcon[game_id]";
for($i=1;$i<=2;$i++) { $result=mysql_query($query."$i") or die(mysql_error()); }

 

How can I get the mysql_query to run "mysql_query($query1)" and "mysql_query($query2)"?

[premiso]

Use arrays

 

<?php
$querys=array();
$querys[]="UPDATE games SET title='$_POST[title]', descr='$_POST[descr]' WHERE game_id=$rowcon[game_id]";
$querys[]="UPDATE game_genres SET genre_id='$_POST[genre]' WHERE game_id=$rowcon[game_id]";

foreach ($querys as $sql) {
    $result = mysql_query($sql) or die(mysql_error());
}

?>

 

The other method would be something like this:

$query1="UPDATE games SET title='$_POST[title]', descr='$_POST[descr]' WHERE game_id=$rowcon[game_id]";
$query2="UPDATE game_genres SET genre_id='$_POST[genre]' WHERE game_id=$rowcon[game_id]";
for($i=1;$i<=2;$i++) { $result=mysql_query(${"query" . $i}) or die(mysql_error()); }

 

But I would suggest using arrays.