Can anybody help?
I have a MySQL database "rates" with a table "voipuk" but I am having problems viewing all the data? I can see the headings but not the date??
I have provided you below with my actual .php file and a link to access th information from the internet.
http://www.rbcserver.net/getrates.php
Any ideas?
<html><head><title>Get Rates</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css">
<!--
body,td,th {
font-size: 12px;
color: #000000;
font-family: Arial, Helvetica, sans-serif;
}
body {
background-color: #FFFFFF;
margin-left: 1px;
}
-->
</style></head>
<body>
<?php
$conn = @mysql_connect( "localhost", "rcox", "joshua" )
or die( "Could not connect" );
$rs = @mysql_select_db( "rates", $conn )
or die( "Could not select database" );
$sql = "select * from voipuk";
$rs = mysql_query( $sql, $conn )
or die( "Could not execute query" );
$list = "<table border=\"1\" cellpadding=\"3\">";
$list .= "<tr><th>Destination</th>";
$list .= "<th>Fixed</th>";
$list .= "<th>Mobile</th>";
while( $row = mysql_fetch_array( $rs ) )
{
$list .= "<tr>";
$list .= "<td>".$row["destination"]."</td>";
$list .= "<td>".$row["fixed"]."</td>";
$list .= "<td>".$row["mobile"]."</td>";
$list .= "</tr>";
}
$list .= "</table>";
echo( $list );
?> </body></html>
