| id |
license |
imei |
numberofequests |
testenable |
license_enable |
distributor |
dateofissue |
name |
msisdn |
email |
");
mysql_select_db($dbname);
//Query that is being run
$query= "SELECT id,license,imei,numberofrequests,testenable,license_enable,distributor,dateofissue,name,msisdn,email FROM mobileback WHERE imei <> \"\" AND distributor='LLService'";
//this will try to spit out the previous sql query
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
//this is a line break before the spit output
while ($line = mysql_fetch_row($result) )
{
if($line[0] <> 0)
{
echo '';
echo '| '.$line[0].' | ';
echo ''.$line[1].' | ';
echo ''.$line[2].' | ';
echo ''.$line[3].' | ';
echo ''.$line[4].' | ';
echo ''.$line[5].' | ';
echo ''.$line[6].' | ';
echo ''.$line[7].' | ';
echo ''.$line[8].' | ';
echo ''.$line[9].' | ';
echo ''.$line[10].' | ';
echo '
';
}
}
?>