2 $handle = sqlite_open("boxee_catalog.db") or die("Could not open database");
4 $query = "select * from audio_files";
6 $result = sqlite_query($handle, $query) or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));
9 if (sqlite_num_rows($result) > 0) {
10 // get each row as an array
12 echo "<table cellpadding=10 border=1>";
13 while($row = sqlite_fetch_array($result)) {
15 echo "<td>".$row[0]."</td>";
16 echo "<td>".$row[1]."</td>";
17 echo "<td>".$row[2]."</td>";
24 // close database file
25 sqlite_close($handle);