id | license | imei | numberofequests | testenable | license_enable | distributor | dateofissue
"); mysql_select_db($dbname); //Query that is being run $query= "SELECT id,license,imei,numberofrequests,testenable,license_enable,distributor,dateofissue FROM privatesms WHERE imei IS NOT NULL"; //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) ) { 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 '
'; } ?>