$category = $_GET['cat']; if ($category == "") { $query="SELECT * FROM t_showreel_tracks, t_showreel_clients WHERE t_showreel_tracks.track_client = t_showreel_clients.client_id AND t_showreel_tracks.track_visible = '1' ORDER BY track_order, track_client, track_title"; } else { $query="SELECT * FROM t_showreel_tracks, t_showreel_clients WHERE track_cat='".$category."' AND t_showreel_tracks.track_client = t_showreel_clients.client_id AND t_showreel_tracks.track_visible = '1' ORDER BY track_order, track_client, track_title"; } // if ($category == "") { // $query="SELECT * FROM t_showreel_tracks ORDER BY track_client"; // } else { // $query="SELECT * FROM t_showreel_tracks WHERE track_cat='".$category."' ORDER BY track_client"; // } //this function no longer used I believe - replaced by javascript one function make_mp3player($fname) { $foo=""; return $foo; } ?>
![]() |
![]() |
Showreel
$host="mysql02.iomart.com";
$username="leeudc122";
$password="spare699";
$database="leeudc122";
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Whoops-a-daisy - unable to select database. I blame Giles. Giles blames the boogie.");
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
//adding this to start fixing the client conundrum
$clientflag=0;
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"track_id");
$filename=mysql_result($result,$i,"track_filename");
$title=mysql_result($result,$i,"track_title");
$blurb=addslashes(mysql_result($result,$i,"track_blurb"));
$audio=mysql_result($result,$i,"track_audio");
$cat=mysql_result($result,$i,"track_cat");
$client=mysql_result($result,$i,"track_client");
$visible=mysql_result($result,$i,"track_visible");
$track_order=mysql_result($result,$i,"track_order");
$clientname=" - ";
$clientname.=mysql_result($result,$i,"client_name");
if ($clientname == " - other") {
$clientname = null;
}
//$player=make_mp3player($filename);
if ($audio == '1') {
echo "
< click on a link to play a demo |
web site by othermachines |