[PHP][MYSQL] Pokazywanie danych z bd o id Opcje

[Dizzy]

Oto mój skrypt:

[PHP] pobierz, plaintext 
<?php
include 'Konfiguracja/Konfiguracja.php';
if (isset($_GET['id'])){
   $id=$_GET['id'];
   } else {
   $id='';}
include 'menu_pokaz.php';
  @$polaczenie = mysql_pconnect("$db_host","$db_user", "$db_pass");
  if (!$polaczenie) {
    echo "Nie udało się nawiązać połączenia z serwerem.";
    exit;
   }
  mysql_select_db("$db_name");
  if(!mysql_select_db("$db_name")) {
   echo "Nie udało się połączyć z bazą";
   exit;
  }
$zapytanie = mysql_query("SELECT id,user_date,user_acc,user_pass,user_ip,user_notatka,srv_type,player1,player2,pl
yer3,player4,player5,player6,player7,player8,player9,player10,player11,player12,
layer13,player14,player15,player16,player17,player18,player19,player20 FROM `users_extra` WHERE `user_login`='$username' id='".$_GET['id']."' ");
$login = mysql_fetch_array($zapytanie);
$user_date = $login['user_date'];
$user_acc = $login['user_acc'];
$user_pass = $login['user_pass'];
$user_ip = $login['ip'];
$user_notatka = $login['user_notatka'];
$srv_type = $login['srv_type'];
$player1 = $login['player1'];
$player2 = $login['player2'];
$player3 = $login['player3'];
$player4 = $login['player4'];
$player5 = $login['player5'];
$player6 = $login['player6'];
$player7 = $login['player7'];
$player8 = $login['player8'];
$player9 = $login['player9'];
$player10 = $login['player10'];
$player11 = $login['player11'];
$player12 = $login['player12'];
$player13 = $login['player13'];
$player14 = $login['player14'];
$player15 = $login['player15'];
$player16 = $login['player16'];
$player17 = $login['player17'];
$player18 = $login['player18'];
$player19 = $login['player19'];
$player20 = $login['player20'];
if ($_SESSION['zalogowany'] == 1) { 
if ($_SESSION['user_type'] == 1 || $_SESSION['user_type'] == 2 || $_SESSION['user_type'] == 3) {
echo "<table border=\"1\" width=\"50%\" style=\"border-collapse: collapse\">
  <tr>
      <td colspan=\"2\">
      <p align=\"center\"><b>$user_acc</b></td>
  </tr>
  <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
  </tr>
  <tr>
      <td width=\"20%\" align=\"right\">Data nadejścia:</td>
      <td>$user_date</td>
  </tr>
  <tr>
      <td width=\"20%\" align=\"right\">Notatka:</td>
      <td>$user_notka</td>
  </tr>
  <tr>
      <td width=\"20%\" align=\"right\">Typ serwera:</td>
      <td>$srv_type</td>
  </tr>
  <tr>
      <td width=\"20%\" align=\"right\">Adres IP:</td>
      <td>$user_ip</td>
  </tr>
  <tr>
      <td width=\"20%\" align=\"right\">&nbsp;</td>
      <td>&nbsp;</td>
  </tr>
  <tr>
      <td width=\"20%\" align=\"right\"><b>Account name:</b></td>
      <td>$user_acc</td>
  </tr>
  <tr>
      <td width=\"20%\" align=\"right\"><b>Password:</b></td>
      <td>$user_pass</td>
  </tr>
  <tr>
      <td width=\"20%\">
      <p align=\"right\"><b>Lista postaci:</b></td>
      <td>$player1<br>
          $player2<br>
          $player3<br>
          $player4<br>
          $player5<br>
          $player6<br>
          $player7<br>
          $player8<br>
          $player9<br>
          $player10<br>
          $player11<br>
          $player12<br>
          $player13<br>
          $player14<br>
          $player15<br>
          $player16<br>
          $player17<br>
          $player18<br>
          $player19<br>
          $player20<br>
          </td>
  </tr>
  <tr>
      <td width=\"20%\">&nbsp;</td>
      <td>&nbsp;</td>
  </tr>
  <tr>
      <td width=\"20%\">&nbsp;</td>
      <td>&nbsp;</td>
  </tr>
</table>";
} else {
echo ""; }
} else {
echo "Niejestes zalogowany";
}
mysql_close();
?>
[PHP] pobierz, plaintext 

Ma on pokazac pełne dane danych o id (id='".$_GET['id']."') czyli wywołanych z linka:
index.php?show=log&id=931

A pokazuje mi pustą tabele a nad nią error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/sites/yoyo.pl/t/i/tibiahunter/strony/log.php on line 19

19 linijka to:
$login = mysql_fetch_array($zapytanie);

[artur_dziocha]

błąd w zaopytaniu

[PHP] pobierz, plaintext 
<?php
$zapytanie = mysql_query("SELECT id,user_date,user_acc,user_pass,user_ip,user_notatka,srv_type,player1,player2,pl
yer3,player4,player5,player6,player7,player8,player9,player10,player11,player12,
layer13,player14,player15,player16,player17,player18,player19,player20 FROM `users_extra` WHERE `user_login`='$username' id='".$_GET['id']."' ") or die(mysql_error);
?>
[PHP] pobierz, plaintext 

i wklej
i chyba powinno być

[PHP] pobierz, plaintext 
<?php
WHERE `user_login`='$username' AND id='".$_GET['id']."'
?>
[PHP] pobierz, plaintext 

Ten post edytował artur_dziocha 29.11.2008, 10:17:13

[Dizzy]

No po tym co mi dałes teraz pisze tylko:
mysql_error

[artur_dziocha]

oj

[PHP] pobierz, plaintext 
<?php
or die(mysql_error())
?>
[PHP] pobierz, plaintext 

Ten post edytował artur_dziocha 29.11.2008, 10:19:13

[Dizzy]

A teraz taki błąd mam o0
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `user_login`='Dizzy' AND id='929'' at line 1

[artur_dziocha]

pokaz jezszcze raz całe zapytanie z AND

[Dizzy]

Oto i one:

[PHP] pobierz, plaintext 
<?php
$zapytanie = mysql_query("SELECT id,user_date,user_acc,user_pass,user_ip,user_notatka,srv_type,player1,player2,pl
er3,player4,player5,player6,player7,player8,player9,player10,player11,player12,l
yer13,player14,player15,player16,player17,player18,player19,player20 FROM `users_extra` WHERE WHERE `user_login`='$username' AND id='".$_GET['id']."' ") or die(mysql_error());
?>
[PHP] pobierz, plaintext 

Widze 2 where 0o

Poprawiłęm oraz pare literówek niema żadnego błędu ale dane też sie nie pokazują o0

Ten post edytował Dizzy 29.11.2008, 10:29:41

[artur_dziocha]

widocznie nie ma żadnych rekordów

[PHP] pobierz, plaintext 
<?php
if(mysql_num_rows($zapytanie)>0) {
echo "coś jest";
}
else{
echo "nie znaleciono rekordu";
}
?>
[PHP] pobierz, plaintext 

[Dizzy]

Wyświetla "coś jest"
I są napewnoo...

[artur_dziocha]

no to tutaj cos mnie gra

[PHP] pobierz, plaintext 
<?php
if ($_SESSION['zalogowany'] == 1) {
if ($_SESSION['user_type'] == 1 || $_SESSION['user_type'] == 2 || $_SESSION['user_type'] == 3) {
?>
[PHP] pobierz, plaintext 

spróbuj wyśweitlić cos przed ifami
lub tytaj

[PHP] pobierz, plaintext 
<?php
</tr>
</table>";
} else {
echo "cos nie tak"; }
}
?>
[PHP] pobierz, plaintext