Question

此时此刻,我把管理者一边拖到现场,允许现场管理人进入飞行编号,数据库将删除所有飞行人员的姓名。然而,在我取得结果时,正视着这样的一点:

<编码> The following people are on this Airlines. 以下人员乘坐这架飞机:Joe Blaggs。 The following people are on thisjet Gareth Roberts 以下人员乘坐这架飞机:Joe Blaggs。 The following people are on thisjet Gareth Roberts 以下人员乘坐这架飞机:Joe Blaggs。 The following people are on thisjet Gareth Roberts 以下人员乘坐这架飞机:Joe Blaggs。 The following people are on thisjet Gareth Roberts The following people are on thisjet Joe Blaggs

你们有这样的想法:显然由于政治部的原因而构成姓名:

我怎么能这样说:

2021号航班上的乘客是:

Name one
Name two
Name three

在此,我欢迎任何建议!

    <? 
     include("logon/include/session.php");
                $loggedinuser = $session->username;
    $passengerNo = $_POST[ enteredPassNo ];
       $theflightno = $_POST[ enteredflightNo ];
            $query1 = mysql_query("SELECT p.surname, p.forename,   p.passNo FROM PASSENGER p WHERE p.passNo =  $passengerNo ");
while($row = mysql_fetch_array($query1))
{
    echo "Welcome to the site"  . " " . $row[ forename ] ." ";
        }
        echo mysql_error();
$query2 = mysql_query("SELECT    p.surname, p.forename, p.passNo, p.flightNo FROM PASSENGER p, FLIGHT_INFO f WHERE     p.flightNo =  $theflightno ");
while($row = mysql_fetch_array($query2))
{
    echo "以下人员正在这一飞行中。" . "</ br> ";
    echo $row[ forename ] ." " . $row[ surname ];
    echo "</ br>";
        echo mysql_error();
        }
    echo mysql_error();
       ?>

It s query2 that is more the focus, query1 is being used for a few tests really! And just to clarify, the values stored in $passengerNo and $theflightNo are being correctly assigned after being posted from the form.

许多感谢,

送文函

www.un.org/spanish/ecosoc EDIT:关于格式的大型建议,但它仍在印刷之中:

以下人员正在这一飞行中。

Gareth Roberts
Joe Bloggs
Gareth Roberts
Joe Bloggs
Gareth Roberts
Joe Bloggs

而不是印刷,

以下人员正在这一飞行中。:-

Gareth Roberts
Joe Bloggs

仅一次:

Answer 1

将以下部分改为:

$query2 = mysql_query("SELECT CONCAT(p.surname, p.forename) as name, p.passNo, 
         p.flightNo FROM PASSENGER p WHERE p.flightNo =  $theflightno  
         GROUP BY name");
echo "Passengers on flight number {$theflightno} are:" . "<br /> <ul>";
while($row = mysql_fetch_array($query2)) {
  echo "<li>" . $row[ name ] . "</li>";
  echo "</ br>";
}
echo "</ul>";

EDIT

我所做的基本编辑是:

Added a CONCAT function, so that names will be returned as a single string(for repeated values of surnames/fornames).
Changing the query, to include a GROUP BY clause. So that repeated names(forname+surname) will appear only once.

Answer 2

echo "The following people are on flight " . $row[ flightNo ] . "</ br> ";    
echo "<ul>";
while($row = mysql_fetch_array($query2))

{

echo "<li>" . $row[ forename ] ." " . $row[ surname ] . "</li>";

    }
 echo "</ul>";

Answer 3

您也正在起草案文。 So

echo "Passenger s on flight number 2021 are:";
echo  </ br> ;
echo  <ul> ;
while($row = mysql_fetch_array($query2))
{
  echo  <li> ;
  echo $row[ forename ] ." " . $row[ surname ];
  echo  </li> ;
}
echo  </ul> ;

EDIT

友情链接