Wie kürzen?

Einklappen
X
 
  • Filter
  • Zeit
  • Anzeigen
Alles löschen
neue Beiträge

  • Wie kürzen?

    Hallo,
    wie kann man diesen Code kürzen?
    Bin ja noch ziemlich neu dabei

    PHP-Code:
      $sql mysql_query('SELECT
                        userinquiry.userinquiryfromuserid,
                        userinquiry.userinquirytouserid,
                        userinquiry.userinquirypurpose,
                        userinquiry.userinquirydate,
                        user.username,
                        user.userid
                                            FROM userinquiry, user
                                            WHERE userinquiry.userinquirytouserid = '
    .$_SESSION["session_id"].'
                        AND userinquiry.userinquiryfromuserid = user.userid'
    );
    echo 
    '<TABLE width=100%>';
    echo 
    '<TR><TD>Absender</TD><TD>Betreff</TD><TD>Datum</TD><TD>Annehmen?</TD></TR>';
    while(
    $row mysql_fetch_object($sql))
      { 
        echo 
    '<TR><TD>'.$row->username.'</TD>';
        echo 
    '<TD>'.$row->userinquirypurpose.'</TD>';
        echo 
    '<TD>'.$row->userinquirydate.'</TD>';
        echo 
    '<TD>'.$row->userinquirypurpose.'</TD></TR>';
      }

      
    $sql2 mysql_query('SELECT
                        userinquiry.userinquiryfromuserid,
                        userinquiry.userinquirytouserid,
                        userinquiry.userinquirypurpose,
                        userinquiry.userinquirydate,
                        user.username,
                        user.userid
                                            FROM userinquiry, user
                                            WHERE userinquiry.userinquiryfromuserid = '
    .$_SESSION["session_id"].'
                        AND userinquiry.userinquirytouserid = user.userid'
    );

    while(
    $row mysql_fetch_object($sql2))
      { 
        echo 
    '<TR><TD>'.$row->username.'</TD>';
        echo 
    '<TD>'.$row->userinquirypurpose.'</TD>';
        echo 
    '<TD>'.$row->userinquirydate.'</TD>';
        echo 
    '<TD>Wartend...</TD></TR>';
      }
    echo 
    '</TABLE>'
    Danke !

  • #2
    Re: Wie kürzen?

    Die beiden Queries unterscheiden sich nur in der WHERE-Klausel. Das kannst du zusammenfassen zu WHERE (a AND b) OR (c AND d).

    Kommentar


    • #3
      Wenn die Reihenfolge keine Rolle spielt z.B. etwa so:
      PHP-Code:
      $sql "
          SELECT
              i.userinquiryfromuserid From,
              i.userinquirypurpose Purpose,
              i.userinquirydate Date,
              u.username Name
          FROM 
              userinquiry i
          INNER JOIN
              user u ON
                      i.userinquiryfromuserid = u.userid
                  OR
                      i.userinquirytouserid = u.userid
          WHERE 
              i.userinquirytouserid = " 
      $_SESSION["session_id"] . 
          OR
              i.userinquiryfromuserid = " 
      $_SESSION["session_id"];
      $res mysql_query($sql) || die(mysql_error());

      echo 
      "<table width='100%>'";
      echo 
      "<tr><th>Absender</th><th>Betreff</th><th>Datum</th><th>Annehmen?</th></tr>";
      while (
      $row mysql_fetch_object($sql)){ 
              echo 
      "<tr>
                      <td>
      $row->Name</td>
                      <td>
      $row->Purpose</td>
                      <td>
      $row->Date</td>\n
                      <td>"
      ;
              if (
      $row->From == $_SESSION["session_id"]){
                      echo 
      $row->Purpose;
              }
              else{
                      echo 
      'Wartend...';
          }
          echo 
      "</td>
                </tr>\n"
      ;
      echo 
      "</table>\n"
      Gruss
      H2O

      Kommentar

      Lädt...
      X