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:afif@sur.ogs-id.com
>
>
>
> --
> 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
beckman@purplecow.com http://www.purplecow.com/
---------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
