A few suggestions.

$show["Time"] doesn't exist; replace the 5 lines after your "while" with
this:

       $sms_time=$show["sms_time"];
       $smsc=$show["smsc"];
       $org_sms=$show["org_sms"];
       $dest_sms=$show["dest_sms"];
       $msg_content=$show["msg_content"];


Also, so save you some formatting headaches, change your $s_sms to this:

$s_sms="SELECT from_unixtime(unix_timestamp(sms_time)) as 
sms_time,smsc,org_sms,dest_sms,msg_content FROM dlr WHERE smsc=('Receive SMS')";

This will format your sms_time from the DB as year-month-day hour:minute:second

select from_unixtime(unix_timestamp(now()));
+--------------------------------------+
| from_unixtime(unix_timestamp(now())) |
+--------------------------------------+
| 2002-11-17 00:11:57                  |
+--------------------------------------+

Peter

On Sun, 17 Nov 2002, Afif wrote:

> 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:[EMAIL PROTECTED]
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

---------------------------------------------------------------------------
Peter Beckman            Systems Engineer, Fairfax Cable Access Corporation
[EMAIL PROTECTED]                             http://www.purplecow.com/
---------------------------------------------------------------------------


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

Reply via email to