SELECT a.* FROM `my_table` AS a RIGHT JOIN `my_table` AS b ON a.id=-1;

 

limit 0,1

 "Select Blank Id, field1, field2, field3 from my_table"

 $aflds = array("Id"=>0,"field1"=>"","field2"=>0,"field3"=>"");

 $aflds["Id"]=0;

$aflds["field1"]="";

$aflds["field2"]=0;

$aflds["field3"]="";

 

   $client = new SoapClient("http://localhost/SOAPtest/WebShop.wsdl",

    array(

      "trace"      => 1,

      "exceptions" => 0));

 

    $parm["OrderId"] = "163469";

    $result = $client->GetOneOrder($parm);

    print "<br><b>Запрос:</b><br>".htmlspecialchars($client->__getLastRequest()) ."\n";

    print "<br><b>Ответ:</b><br>".htmlspecialchars($client->__getLastResponse())."\n";

    print "<br><b>Ошибка:</b><br>SOAP Fault: (faultcode: {$result->faultcode}, faultstring: {$result->faultstring})<br>";

        function GetOneOrder($parms)

        {

            $this->connectDB();

            if (!isset($parms->OrderId))

            {

                 throw new SoapFault("Client","OrderId not set");

            }

 

            $query = "SELECT  Shop_User.ID as Client_Id, Shop_User.Name as Client_Name,

                        Shop_Order.Id as Order_No, shop_order.postdate as Order_PostDate

                        FROM Shop_User, Shop_Order

                        WHERE Shop_Order.ID = " . $parms->OrderId;

 

            $result = mysql_query($query);

 

             If (mysql_errno()>0)

            {

                throw new SoapFault("Server","Query failed : " . mysql_error());

            }

 

            $line = mysql_fetch_array($result, MYSQL_ASSOC);

            $Orrder = new StdClass;

            $Orrder->Client_Id = $line["Client_Id"];

            $Orrder->Client_Name = $line["Client_Name"];

            $Orrder->Order_No = $line["Order_No"];

            $Orrder->Order_PostDate = $line["Order_PostDate"];

            $retVal->retrn = $Orrder;

            return($retVal);

    }

 

 

 <?xml version="1.0" encoding="UTF-8"?>

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"

                  xmlns:ns1="http://localhost/SOAPtest"

                  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

      <SOAP-ENV:Body>

            <ns1:GetOneOrderResponse xsi:type="ns1:Orrder">

                  <ns1:Client_Id>12345</ns1:Client_Id>

                  <ns1:Client_Name>Aa AAAA</ns1:Client_Name>

                  <ns1:Order_No>163469</ns1:Order_No>

                  <ns1:Order_PostDate>2008-06-04</ns1:Order_PostDate>

            </ns1:GetOneOrderResponse>

      </SOAP-ENV:Body>

</SOAP-ENV:Envelope>