[resolu] update kaputt

[YVES]

:mauvais:
bon, j'ai posté un peu vite, car cela va mieux ainsi....

Code PHP :

<?php

  session_start();

$id = $_SESSION['id'];

include 'connexion.php';

//on va chercher la position du joueur

$requete = mysql_query("SELECT posx, posy FROM membres WHERE id = ". $id .";") or die(mysql_error());

$rsa= mysql_fetch_assoc($requete);

$posx = $rsa['posx'];

$posy = $rsa['posy'];

//Là, on va chercher la ressource de la case sur la map qui correspond au X/Y de ton perso

$rsb = mysql_query("SELECT ressource FROM map WHERE posx=".$rsa['posx']." AND posy=".$rsa['posy']) or die(mysql_error());

$sql = mysql_fetch_assoc($rsb);

$ressource= $sql['ressource'];

$sql ="UPDATE membres SET stock1= '$ressource', qstock1=qstock1+1 WHERE id = ". $id .";"; 

mysql_query($sql) or die('Erreur SQL '.$sql.'<br>'.mysql_error());

if($rsb)

{

    $_SESSION['stock1']= $_SESSION['stock1']+'$ressource';

    $_SESSION['qstock1']=$_SESSION['qstock1']+1;

}

header("Location: page_membre.php");

mysql_close();

?>