[HTML] pobierz, plaintext 
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pomier1/public_html/xml/imagegallery/content.php on line 16
[HTML] pobierz, plaintext 

[PHP] pobierz, plaintext 
   1.
      <?php
   2.
 
   3.
      $linkID = mysql_connect($host, $user, $pass) or die("Nie mozna polaczyc z serwerem baz danych.");
   4.
      mysql_select_db($database, $linkID) or die("Nie mozna znalesc bazy danych.");
   5.
      //odczyt//
   6.
      $query = "SELECT galerie.g_nazwa, pod_galerie.pg_tytul, pod_galerie.pg_tresc, thumb, big FROM galerie, pod_galerie WHERE galerie.g_id=pod_galerie.g_id";
   7.
      $result = mysql_query($query);
   8.
      echo $return1='<content Name="GALERIA">';
   9.
      $tmp = "";
  10.
      $tmp2 = "";
  11.
      $counter = 0;
  12.
      while ($row = mysql_fetch_array($result)) {
  13.
      if ($tmp2 != $row['g_nazwa']) {
  14.
      if ($counter != 0) {
  15.
      $return.='</gallery>';
  16.
 
  17.
      }
  18.
      $tmp2 = $row['g_nazwa'];
  19.
      }
  20.
 
  21.
      if ($tmp != $row['g_nazwa']) {
  22.
      $return.='<gallery Name="' . $row['g_nazwa'] . '">';
  23.
      $tmp = $row['g_nazwa'];
  24.
      }
  25.
 
  26.
      $return.='<image Thumb="' . $row['thumb'] . '"' . 'Large="' . $row['big'] . '"' . 'Caption="' . $row['pg_tytul'] . '">
  27.
      <copy><![CDATA[' . $row['pg_tresc'] . ']]></copy>
  28.
      </image>';
  29.
      $counter++;
  30.
      if ($counter== mysql_num_rows($result)) {
  31.
      $result.="</gallery>";
  32.
      }
  33.
 
  34.
      }
  35.
      $return.='</content>';
  36.
      echo $return;
  37.
      //koniec
  38.
      ?>
[PHP] pobierz, plaintext