Accounting Day ' . date('Y') . ' Program and Speakers

'.$pagedb['info2'].' '; if ($pagedb['pvar'] == 1){ $content .= ''; $dbname = mysql_connect ("localhost", "account_adfinal", "test123") or die ('I cannot connect to the database because: ' . mysql_error()); $dbname = "account_adfinal"; mysql_select_db ($dbname); $result = mysql_query('SELECT `Time` , `Track1` , `Track2` , `Track3` , `Track4` , `Track5` , `Track6` FROM `st_location` WHERE `sort` = 1') or die(mysql_error()); $row = mysql_fetch_array( $result ); $width = '126'; if ($row['Track4'] != '0'){ $t4 = '1'; $width = '95'; } if ($row['Track5'] != '0'){ $t5 = '1'; $width = '76'; } function gettrackinfo($tinfo) { if ($tinfo == '0'){ $rcontent = 'bgcolor="#EAEAEA" style="border-top:2px solid #FFFFFF;border-right:2px solid #FFFFFF;"> '; return $rcontent;} elseif ($tinfo == 'same'){ $rcontent = 'bgcolor="#EAEAEA" style="border-top: solid #EAEAEA 2px; border-right:2px solid #FFFFFF;"> '; return $rcontent;} elseif (is_numeric($tinfo)){ $query = 'SELECT `speaker` , `topic` FROM `speaktopic` WHERE `id` = ' . $tinfo; $result = mysql_query($query) or die(mysql_error()); $strow = mysql_fetch_array( $result ); if($strow['topic']>1){ $query = 'SELECT `id`, `ttrack` , `ttitle` FROM `topics` WHERE `id` = ' . $strow['topic']; $result = mysql_query($query) or die(mysql_error()); $trow = mysql_fetch_array( $result ); }else{$error=1;} if($trow['id']>1){ $query = 'SELECT sname , scred FROM speaktopic RIGHT JOIN speakers ON speaktopic . speaker = speakers . id WHERE speaktopic . topic = ' . $trow['id']; $result = mysql_query($query) or die(mysql_error()); }else{$error=1;} if($error!=1){ $rcontent = 'bgcolor="#EAEAEA" style="border-top:2px solid #FFFFFF;border-right:2px solid #FFFFFF;">'. $trow['ttitle'] .' ('. $trow['ttrack'] .')'; while ($srow = mysql_fetch_array( $result )){ $rcontent .= '
' . $srow['sname'] . ' ' . $srow['scred']; } } return $rcontent; } else{ $rcontent = 'bgcolor="#EAEAEA" style="border-top:2px solid #FFFFFF;border-right:2px solid #FFFFFF;"> '.$tinfo; return $rcontent; } } $result = mysql_query('SELECT `Time` , `Track1` , `Track2` , `Track3` , `Track4` , `Track5` , `Track6` FROM `st_location` WHERE `Time` != \'0\' ORDER BY `sort` ASC') or die(mysql_error()); while($row = mysql_fetch_array( $result )) { //If Full Column (Lunch) if ($row['Track1'] == 'full') { $content .= '

'; $content .= $row['Time']; if ($t5 == '1'){ $content .= '