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
