\n\n
Pure And Simple
records
\n\n
News Music Links Info myspace
"; // selection indicator. if ($menu == 'artist') { $sqlstring = "SELECT artistname FROM artists WHERE artistid = $id"; $resultset = sqlsearch($sqlstring); $line = mysql_fetch_array($resultset); echo "
{$line[artistname]}
"; } else { echo "
{$menu}
"; } // select menus. ----------------------------------------------------------------------------------- switch ($menu) { case "news": // recordsgallery $sqlstring ='SELECT * FROM artists, records WHERE artists.artistid=records.artistid ORDER BY recordid DESC LIMIT 5'; $resultset = sqlsearch($sqlstring); echo "
Recent Records.
\n"; echo "
\n"; while ($line = mysql_fetch_array($resultset)) { echo "
\n \"{$line[recordphoto]}\"
{$line[artistname]}
{$line[recordname]}
"; echo "
\n"; } echo "
\n"; // news. $sqlstring = 'SELECT * FROM news ORDER BY messageid DESC'; $resultset = sqlsearch($sqlstring); while ($line = mysql_fetch_array($resultset)) { echo "
{$line[messagedatetime]}, {$line[messageheader]}
\n
{$line[message]} \n
\n\n"; } break; // ----------------------------------------------------------------------------------- case "music": $sqlstring ='SELECT * FROM artists'; $resultset = sqlsearch($sqlstring); echo "
Artists.
\n"; echo "
\n"; echo "
\n"; while ($line = mysql_fetch_array($resultset)) { echo "{$line[artistname]} / "; } echo "
\n"; echo "
\n"; // recordsgallery $sqlstring ='SELECT * FROM artists, records WHERE artists.artistid=records.artistid'; $resultset = sqlsearch($sqlstring); echo "
Records.
\n"; echo "
\n"; while ($line = mysql_fetch_array($resultset)) { echo "
\n \"{$line[recordphoto]}\"
{$line[artistname]}
{$line[recordname]}
"; echo "
\n"; } echo "
\n"; break; // ----------------------------------------------------------------------------------- case "links": // venues. $sqlstring = "SELECT linkurl, linkname FROM links WHERE linktype = 1 ORDER BY linkname"; $resultset = sqlsearch($sqlstring); echo "
Venues.
\n"; echo "
\n"; while ($line = mysql_fetch_array($resultset)) { echo "{$line[linkname]} / \n"; } echo "
\n"; // hardcore publishers. $sqlstring = "SELECT linkurl, linkname FROM links WHERE linktype = 2 ORDER BY linkname"; $resultset = sqlsearch($sqlstring); echo "
Hardcore Publishers.
\n"; echo "
\n"; while ($line = mysql_fetch_array($resultset)) { echo "{$line[linkname]} / \n"; } echo "
\n"; // music publishers. $sqlstring = "SELECT linkurl, linkname FROM links WHERE linktype = 4 ORDER BY linkname"; $resultset = sqlsearch($sqlstring); echo "
Music Publishers.
\n"; echo "
\n"; while ($line = mysql_fetch_array($resultset)) { echo "{$line[linkname]} / \n"; } echo "
\n"; // scene. $sqlstring = "SELECT linkurl, linkname FROM links WHERE linktype = 5 ORDER BY linkname"; $resultset = sqlsearch($sqlstring); echo "
Scene.
\n"; echo "
\n"; while ($line = mysql_fetch_array($resultset)) { echo "{$line[linkname]} / \n"; } echo "
\n"; // metal publishers. $sqlstring = "SELECT linkurl, linkname FROM links WHERE linktype = 7 ORDER BY linkname"; $resultset = sqlsearch($sqlstring); echo "
Metal Publishers.
\n"; echo "
\n"; while ($line = mysql_fetch_array($resultset)) { echo "{$line[linkname]} / \n"; } echo "
\n"; // metal scene. $sqlstring = "SELECT linkurl, linkname FROM links WHERE linktype = 9 ORDER BY linkname"; $resultset = sqlsearch($sqlstring); echo "
Metal Scene.
\n"; echo "
\n"; while ($line = mysql_fetch_array($resultset)) { echo "{$line[linkname]} / \n"; } echo "
\n"; break; // ----------------------------------------------------------------------------------- case "info": $sqlstring = 'SELECT * FROM info ORDER BY infoid'; $resultset = sqlsearch($sqlstring); while ($line = mysql_fetch_array($resultset)) { echo "
Contact.
\n
{$line[contact]}
\n
Frequently Asked Questions.
\n
{$line[faq]}
\n
Privacy.
\n
{$line[privacy]}
\n"; } break; // ----------------------------------------------------------------------------------- case "artist": $sqlstring = "SELECT * FROM artists WHERE artistid = $id"; $resultset = sqlsearch($sqlstring); while ($line = mysql_fetch_array($resultset)) { echo "
Biography.
\n
\"{$line[artistphoto]}\" {$line[artisttext]}
\n"; } // $sqlstring = "SELECT * FROM records WHERE artistid = $id"; $resultset = sqlsearch($sqlstring); echo "
Records.
\n"; while ($line = mysql_fetch_array($resultset)) { echo "
{$line[recordname]}
\"{$line[recordphoto]}\"
{$line[recordtext]}
\n"; } break; } // close switch. echo "
© 2006 Pure And Simple Records
\n\n"; echo " \n"; // close containercontent. ?>