Need Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dear All,
I  would  like  to  represent  data  from  table dlr, but I could have
nothing with this script

$s_sms="SELECT sms_time,smsc,org_sms,dest_sms,msg_content FROM dlr WHERE smsc=('Receive SMS')";
$result = mysql_query($s_sms);
if (!$result) error_message(sql_error());

//Header of Table

         echo "<html>";
         echo "<title>Hasil</title>";
         echo "<body><br>";
         echo "<table align=center width=95% border=1>";
         echo "<tr>";
         echo "<td width=23%>Time</td>";
         echo "<td width=8%>Action</td>";
         echo "<td width=11%>From</td>";
         echo "<td width=13%>Destination</td>";
         echo "<td width=45%>Message</td>";
         echo "</tr>";

//detail of row

   while ($show = mysql_fetch_array($result)) {
      $sms_time=$show["Time"];
      $smsc=$show["Action"];
      $org_sms=$show["From"];
      $dest_sms=$show["Destination"];
      $msg_content=$show["Message"];

      Make Best Result of timestamp;
      $sms_time = substr($show["Time"],0,4).'-'.
      substr($show["Time"],4,2).'-'.
      substr($show["Time"],6,2).'-'.
      substr($show["Time"],8,2).':'.
      substr($show["Time"],10,2).':'.
      substr($show["Time"],12,2);

      echo "<tr>";
      echo "<td>$sms_time </td>";
      echo "<td>$smsc </td>";
      echo "<td>$org_sms </td>";
      echo "<td>$dest_sms </td>";
      echo "<td>$msg_content </td>";
      echo "</tr>";
   }
echo "</table>";
echo "</body>";
echo "</html>";

DO I miss some thing with above script ??
pls help me
Highly appreciate for yr help

-- 
Warm regards,
Afif
mailto:afif@sur.ogs-id.com



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux