Wie kürzen?

[phpMorpheus2]

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

  $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 !

[onemorenerd]

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).

[H2O]

Wenn die Reihenfolge keine Rolle spielt z.B. etwa so:

$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";