Added the read details of a mash in soundcloud to the DB.

kevinmcdonagh · Sep 5, 2010 · 18009c5 · 18009c5
1 parent 6cdbdd3
commit 18009c5
Show file tree

Hide file tree

Showing 2 changed files with 3 additions and 3 deletions.
diff --git a/code/mashbox1.php b/code/mashbox1.php
@@ -78,10 +78,10 @@
                 <tbody>
 					<?php
 						$dbh = new PDO('sqlite:mashbox2.sqlite');
-						foreach($dbh->query('SELECT * FROM tracks') as $row){
+						foreach($dbh->query('SELECT * FROM mashes') as $row){
 							echo ("<tr>\n");
-							echo ("<td><span><strong>" . $row['title'] . "</strong> by " . $row['artist'] . "</span></td>\n");
-							echo ("<td><span>". $row['addedby1'] . "</span> <b>&amp;</b> <span>". $row['addedby2'] . "</span></td>\n");		                        
+							echo ("<td><span><strong>" . $row['name'] . "</strong> by " . $row['artist'] . "</span></td>\n");
+							echo ("<td><span>". $row['original_artist'] . "</span> <b>&amp;</b> <span>". $row['random_mash_artist'] . "</span></td>\n");		                        
 							echo ("<tr>\n");
 					  	}
 						$dbh = null;

diff --git a/code/mashbox2.sqlite b/code/mashbox2.sqlite