[PHP] pobierz, plaintext 
else {
  mysql_query("DELETE FROM g_as_ps WHERE p_id=".$p['p']." AND a_id=".$p['id_a']);
 
  mysql_query("UPDATE g_p SET a_id=0 WHERE p=".$p['p']);
 
  $msg = "załatwione";
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
else {
  $r = $pdo->exec("DELETE FROM g_as_ps WHERE p_id=".$p['p']." AND a_id=".$p['id_a']);
 
  $q = $pdo->exec("UPDATE g_p SET a_id=0 WHERE p=".$p['p']);
 
  $msg = "załatwione";
}
[PHP] pobierz, plaintext 

Cytat(Kshyhoo @ 4.04.2014, 16:16:58 )

[PHP] pobierz, plaintext 
else {
  mysql_query("DELETE FROM g_as_ps WHERE p_id=".$p['p']." AND a_id=".$p['id_a']);
 
  mysql_query("UPDATE g_p SET a_id=0 WHERE p=".$p['p']);
 
  $msg = "załatwione";
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
else {
  $r = $pdo->exec("DELETE FROM g_as_ps WHERE p_id=".$p['p']." AND a_id=".$p['id_a']);
 
  $q = $pdo->exec("UPDATE g_p SET a_id=0 WHERE p=".$p['p']);
 
  $msg = "załatwione";
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
else
{
 $pdo->query('DELETE FROM g_as_ps WHERE p_id='.$p['p'].' AND a_id='.$p['id_a']);
  $pdo->query('UPDATE g_p SET a_id=0 WHERE p='.$p['p']);
 $msg = 'załatwione';
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
{
  $r = $pdo->prepare("DELETE ...
  $r->execute();
 
  $r = $pdo->prepare("UPDATE...
  $r->execute();
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$pdo->query('DELETE FROM g_as_ps WHERE p_id='.$p['p'].' AND a_id='.$p['id_a']);
$pdo->query('UPDATE g_p SET a_id=0 WHERE p='.$p['p']);
[PHP] pobierz, plaintext 

[HTML] pobierz, plaintext 
<a href="?go=association&amp;leave=ok">opuść</a>
[HTML] pobierz, plaintext 

[PHP] pobierz, plaintext 
} elseif(!empty($_GET['leave'])) {
  require_once('function/association_leave.php');
  $msg = association_leave($User);
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
else {
  // odejdź
$d = $pdo->prepare("DELETE FROM g_associations_players 
				WHERE player_id=".$player['player']." 
				AND association_id=".$player['id_association']);
$d->execute();
 
$u=$pdo->prepare("UPDATE g_players 
				SET id_association=0 
				WHERE player=".$player['player']);
$u->execute();
 
$msg = "done";
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$msg = association_leave($User)
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
} elseif(!empty($_GET['leave'])) {
  require_once('function/association_leave.php');
  $msg = association_leave($User);
  echo $msg."<hr/>";
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
{
  $r = $pdo->prepare("DELETE ... );
  $r->execute();
 
  $r = $pdo->prepare("UPDATE... );
  $r->execute();
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
 $r = $pdo->prepare("DELETE ... );
$r->execute();
$r->closeCursor();
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$pdo->exec("DELETE FROM g_associations_players WHERE player_id=".$player['player']." AND association_id=".$player['id_association']);
if(!$pdo->exec()) print_r($pdo->errorInfo());
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
mysql_query("INSERT INTO messages (m_od, m_do, wiadomosc, data) 
		     SELECT 1, user, '".$txt."', now()
		     FROM users");
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$m_od = 1;
$wiadomosc = 'PDO to zło';
 
$b = $pdo->prepare("INSERT INTO messages (m_od, m_do, wiadomosc, data) 
				SELECT :m_od, :user, :txt, now()
				FROM users");
$b->bindValue(":m_od", $m_od);
$b->bindValue(":wiadomosc", $wiadomosc);
$b->execute();
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$b->bindValue(":user", 'user');
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$m_od = 1;
$wiadomosc = 'PDO to zło';
 
$b = $pdo->prepare("INSERT INTO messages (m_od, m_do, wiadomosc, data)
                    SELECT :m_od, user, :txt, now()
                    FROM users");
$b->bindValue(":m_od", $m_od);
$b->bindValue(":wiadomosc", $wiadomosc);
$b->execute();
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$del = $pdo->exec("DELETE FROM messages WHERE m_od=$user");
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
echo $del;
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$ile = mysql_affected_rows();
if($ile == 0)
  return "nie usunięto";
else
  return "usunięto";
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
if($del == 0)
  return "nie usunięto";
else
  return "usunięto";
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
function del_mess($user, $id) {
  global $pdo;
  $id = (int)$id;
  $user = (int)$user;
 
  /* mysql_query("DELETE FROM messages WHERE id=$id AND m_do=$user"); */
  $del = $pdo->exec("DELETE FROM messages WHERE id=$id AND m_do=$user");
 
  /* if(mysql_affected_rows() == 0) { */
  if($del == 0) {
    return "nie usunięto";
  } else {
    return "usunięto";
  }
 
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
if(!empty($_GET['del'])) {
  require_once('del_mess.php');
  $msg = del_mess($User['user'], $_GET['del']);
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$del = $pdo->prepare();
$del->execute("DELETE FROM messages WHERE m_od=$user");
 
$ile = $del->rowCount();
if($ile == 0)
  return "nie usunięto";
else
  return "usunięto";
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
if(!empty($_GET['del'])) {
  require_once('del_mess.php');
  $msg = del_mess($User['user'], $_GET['del']);
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
if(!empty($_POST['m_do']) && !empty($_POST['txt'])) {
  require_once('send_mess.php');
  $msg = send_mess($User['user'], $_POST['m_do'], $_POST['txt']);
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
echo $msg. '
  <form ...>
 
  </form>
';
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$ts = $pdo->query("SELECT * 
			    FROM g_ts 
			    WHERE user_id=".$User['user']);
 
while($t = $ts->fetch()) { // <-- linia 73
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
SELECT name, ..., SUM(r1) AS suma_r1
[PHP] pobierz, plaintext