$handle = sqlite_open("boxee_catalog.db") or die("Could not open database"); $query = "select * from audio_files"; $result = sqlite_query($handle, $query) or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle))); // if rows exist if (sqlite_num_rows($result) > 0) { // get each row as an array // print values echo "
".$row[0]." | "; echo "".$row[1]." | "; echo "".$row[2]." | "; echo "