# to # # # include "../mike/0_mike_random_functions.php"; $mike_title="AU - Americans United for Separation of Church and State - Phoenix Chapter"; include "../mike/mike_au_head_html.php"; # # this includes the logo and title # ie: AU Greater Phoenix Chapter # include "../mike/mike_au_titles.php"; # # this includes the top navagation bar # include "../mike/mike_au_main_top_line.php"; $random_number=time(); $random_number2=date('i'); $random_number2+=$random_number; gen_random_image('../mike/0_images_random', $random_number, $random_number2, '../mike/mike.css' ); # # jan 12, 2013 - Mike changed this from # having the videos and movies # hardcoded on the web page into # storing them on a SQL table # # # include some constants use for lenth of data in the form # include '../mike/0_mike_data_sizes.php'; # # include some function # include '../mike/0_mike_functions.php'; # # include the messages that I will print # that way they can be changed without # editing the programs # include '../mike/0_mike_messages.php'; $query=""; $video_list=""; # # connect to the sql database # mike_connect_sql(); # # add this email address to our sql table # $query="select video_text, video_url from mike_au_videos where delete_flag != 'y' order by sort_order_1, sort_order_2, video_text "; # # select the data # $rc = @mysql_query($query); # # execute the query # $get_trustee_files = @mysql_query($query); # # get the number of times that email address is in our files # $hits=0; while($row = mysql_fetch_assoc($get_trustee_files)){ $stinking_time="TIME"; $stinking_time2="TIME"; # # count records read # $hits++; # # get the sql data # #$id=$row['id']; $video_text=$row['video_text']; $video_url=$row['video_url']; #echo "text='$video_text'
"; #echo "url='$video_url'
"; $video_list.="
  • "; $video_list.=''; $video_list.=$video_text; $video_list.=''; } if ($video_list == "" ) { #$video_list='There are not any videos or movies'; $video_list=$mike_message_086; } else { $video_list=""; } # we are all done # close our sql connection # @mike_disconnect_sql(); ?>