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 '
'; } } ?>