Liste ohne registrierung einsehen

[Netz]

Besten Dank.

Ich bin etwas weiter.

Das JOINen hat geklappt, ich kann es nur nicht ordentlich abfragen.

Jemand einen Tipp?

Code: Alles auswählen

$sql = "SELECT mem_leader, usr_id, row1id1.usd_value, row2id2.usd_value, row3id8.usd_value, row4id12.usd_value FROM adm_roles, adm_categories, adm_members, adm_users LEFT JOIN adm_user_data row1id1 ON row1id1.usd_usr_id = usr_id AND row1id1.usd_usf_id = 1 LEFT JOIN adm_user_data row2id2 ON row2id2.usd_usr_id = usr_id AND row2id2.usd_usf_id = 2 LEFT JOIN adm_user_data row3id8 ON row3id8.usd_usr_id = usr_id AND row3id8.usd_usf_id = 8 LEFT JOIN adm_user_data row4id12 ON row4id12.usd_usr_id = usr_id AND row4id12.usd_usf_id = 12 WHERE rol_id IN (6) AND rol_cat_id = cat_id AND cat_org_id = 1 AND mem_rol_id = rol_id AND mem_begin <= \"2010-09-15\" AND mem_end > \"2010-09-15\" AND mem_usr_id = usr_id AND usr_valid = 1 ORDER BY mem_leader DESC , row1id1.usd_value ASC";

$db_erg = mysql_query( $sql );
if ( ! $db_erg )
{
  die('Ungültige Abfrage: ' . mysql_error());
}

echo '<table border="1">';

while ($zeile = mysql_fetch_array( $db_erg, MYSQL_ASSOC))
{
  echo "<tr>";
  echo "<td>". $zeile ['row1id1'] ['usd_value'] . "</td>";
  echo "<td>". $zeile ['row2id2'] ['usd_value'] . "</td>";
  echo "<td>". $zeile ['row3id8']  ['usd_value'] . "</td>";
  echo "<td>". $zeile ['row4id12']  ['usd_value'] . "</td>";
  echo "</tr>";
}
echo "</table>";

[Netz]

Ich hab es geschafft!

Wenn ich es verschönert habe, poste ich meinen Weg, falls ihn jemand nachgehen möchte!

[Netz]

So, das ist noch nicht schön, aber funktioniert.

Code: Alles auswählen

<?php
// Error Reporting komplett abschalten
error_reporting(0);

// Zum Aufbau der Verbindung zur Datenbank
define ( 'MYSQL_HOST',      'mysql2.xxx.de' );
define ( 'MYSQL_BENUTZER',  'xxx' );
define ( 'MYSQL_KENNWORT',  'xxx' );
define ( 'MYSQL_DATENBANK', 'xxx' );

$db_link = mysql_connect (MYSQL_HOST, MYSQL_BENUTZER, MYSQL_KENNWORT);


$db_sel = mysql_select_db( MYSQL_DATENBANK )
   or die("Auswahl der Datenbank fehlgeschlagen");


$sql = 'SELECT mem_leader, usr_id, row1id1.usd_value as name, row2id2.usd_value as vorname, row3id3.usd_value as adresse, row4id8.usd_value as tele, row5id12.usd_value as mail FROM adm_roles, adm_categories, adm_members, adm_users LEFT JOIN adm_user_data row1id1 ON row1id1.usd_usr_id = usr_id AND row1id1.usd_usf_id = 1 LEFT JOIN adm_user_data row2id2 ON row2id2.usd_usr_id = usr_id AND row2id2.usd_usf_id = 2 LEFT JOIN adm_user_data row3id3 ON row3id3.usd_usr_id = usr_id AND row3id3.usd_usf_id = 3 LEFT JOIN adm_user_data row4id8 ON row4id8.usd_usr_id = usr_id AND row4id8.usd_usf_id = 8 LEFT JOIN adm_user_data row5id12 ON row5id12.usd_usr_id = usr_id AND row5id12.usd_usf_id = 12 
WHERE rol_id IN (12) 
AND rol_cat_id = cat_id AND cat_org_id = 1 AND mem_rol_id = rol_id AND mem_begin <= NOW() AND mem_end > NOW() AND mem_usr_id = usr_id AND usr_valid = 1 ORDER BY mem_leader DESC , row1id1.usd_value ASC';

$db_erg = mysql_query( $sql );
if ( ! $db_erg )
{
  die('Ungültige Abfrage: ' . mysql_error());
}

echo '<table border="1" cellpadding="5">';
echo "<th>Vor- und Nachname</th>";
echo "<th>Anschrift</th>";
echo "<th>Handy</th>";

while ($zeile = mysql_fetch_array( $db_erg, MYSQL_ASSOC))
{
  echo "<tr>";
  echo "<td>". '<a href="mailto:' .$zeile ['mail'] . '">' . $zeile ['vorname'] . " ". $zeile ['name']."</a>" . "</td>";
  echo "<td>". $zeile ['adresse'] . "</td>";
  echo "<td>". $zeile ['tele'] . "</td>";
  
  
  echo "</tr>";
}
echo "</table>";

mysql_free_result( $db_erg );


mysql_close($db_link );

?>