1: 
2: 
3: 
4: 
5: 
6:

$abfrage = "SELECT * FROM meldeblatt WHERE schule LIKE '$schule'";
  $ergebnis = mysql_query($abfrage);
   while($row = mysql_fetch_object($ergebnis))
    {
     echo $row->schuladresse;
    }

1:

SELECT a.*, b.* FROM schulen a, betreuer b WHERE a.schulname = b.schulname AND a.schulname = 'dein schulname'

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18:

$abfrage = "SELECT a.*, b.*
           FROM meldeblatt a, betreuer b
           WHERE a.schule = b.schule
           AND WHERE a.schule = 'xxx'";

  $ergebnis = mysql_query($abfrage);
   while($row = mysql_fetch_object($ergebnis))
    {
    echo $row->schule;
    echo "<br>";
    echo $row->bundesland;
    echo "<br>";
    echo $row->familienname;
    echo "<br>";
    echo $row->vorname;
    echo "<br><br>";
    
    }

1:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\Programme\TSW\Apache2\htdocs\schuelerliga\sqlabfrage.php on line 11

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9:

$abfrage = "SELECT user, pw
           FROM pwl
           WHERE user = '$user'";
  $ergebnis = mysql_query($abfrage);
   while($row = mysql_fetch_object($ergebnis))
    {
     $pwl = $row->pw;
     $user = $row->user;
     }

1: 
2: 
3: 
4: 
5:

   
$row = mysql_fetch_object($ergebnis);
$pwl = $row->pw;
$user = $row->user;

1: 
2: 
3: 
4: 
5:

$row = mysql_fetch_row($ergebnis);
$pwl = $row[pw];
$user = $row[user];