problema con select

[gennahouse]

<?
include'db.php';
session_start(); 
mysql_error() 
mysql_fetch_row($result);
$sql="SELECT produzione FROM campi WHERE  `tipo` ='1' && `player_id` ='1'";

$result = mysql_query($sql);
$array = mysql_fetch_row($result);

mysql_fetch_row($result2);
$sql2 = "SELECT risorsa, risorsa_ora_update, risorse_spese FROM risorse WHERE `player_id` ='1' && 'risorse_id'='1' && tipo='1'";
$result2 = mysql_query($sql2);
$array2 = mysql_fetch_row($result2);

echo"$array[0]  $array2[0]  $array2[1]  $array2[2]  $array2[3]";
?>