View Open Teams (L)


Return to Home Page.		Help.

An error occurred in script '/home/claudebu/public_html/view_open_teams.php' on line 153:
Undefined variable: open_id
Date/Time: 5-21-2012 06:47:38

Array
(
    [GLOBALS] => Array
 *RECURSION*
    [_ENV] => Array
        (
            [DOCUMENT_ROOT] => /home/claudebu/public_html
            [GATEWAY_INTERFACE] => CGI/1.1
            [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
            [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
            [HTTP_ACCEPT_ENCODING] => gzip
            [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
            [HTTP_CACHE_CONTROL] => no-cache
            [HTTP_CONNECTION] => close
            [HTTP_COOKIE] => PHPSESSID=eb654635a39028b26aa4ec7a1d56c9ce
            [HTTP_HOST] => www.midkentgolfclub.co.uk
            [HTTP_PRAGMA] => no-cache
            [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
            [HTTP_X_CC_ID] => ccc01-01
            [PATH] => /bin:/usr/bin
            [QUERY_STRING] => 
            [REDIRECT_STATUS] => 200
            [REMOTE_ADDR] => 38.107.179.208
            [REMOTE_PORT] => 38378
            [REQUEST_METHOD] => GET
            [REQUEST_URI] => /view_open_teams.php
            [SCRIPT_FILENAME] => /home/claudebu/public_html/view_open_teams.php
            [SCRIPT_NAME] => /view_open_teams.php
            [SERVER_ADDR] => 188.64.188.21
            [SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
            [SERVER_NAME] => www.midkentgolfclub.co.uk
            [SERVER_PORT] => 80
            [SERVER_PROTOCOL] => HTTP/1.1
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [UNIQUE_ID] => T7nW@rxAvBUAAD7aPY0AAAAH
        )

    [HTTP_ENV_VARS] => Array
        (
            [DOCUMENT_ROOT] => /home/claudebu/public_html
            [GATEWAY_INTERFACE] => CGI/1.1
            [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
            [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
            [HTTP_ACCEPT_ENCODING] => gzip
            [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
            [HTTP_CACHE_CONTROL] => no-cache
            [HTTP_CONNECTION] => close
            [HTTP_COOKIE] => PHPSESSID=eb654635a39028b26aa4ec7a1d56c9ce
            [HTTP_HOST] => www.midkentgolfclub.co.uk
            [HTTP_PRAGMA] => no-cache
            [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
            [HTTP_X_CC_ID] => ccc01-01
            [PATH] => /bin:/usr/bin
            [QUERY_STRING] => 
            [REDIRECT_STATUS] => 200
            [REMOTE_ADDR] => 38.107.179.208
            [REMOTE_PORT] => 38378
            [REQUEST_METHOD] => GET
            [REQUEST_URI] => /view_open_teams.php
            [SCRIPT_FILENAME] => /home/claudebu/public_html/view_open_teams.php
            [SCRIPT_NAME] => /view_open_teams.php
            [SERVER_ADDR] => 188.64.188.21
            [SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
            [SERVER_NAME] => www.midkentgolfclub.co.uk
            [SERVER_PORT] => 80
            [SERVER_PROTOCOL] => HTTP/1.1
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [UNIQUE_ID] => T7nW@rxAvBUAAD7aPY0AAAAH
        )

    [_POST] => Array
        (
        )

    [HTTP_POST_VARS] => Array
        (
        )

    [_GET] => Array
        (
        )

    [HTTP_GET_VARS] => Array
        (
        )

    [_COOKIE] => Array
        (
            [PHPSESSID] => eb654635a39028b26aa4ec7a1d56c9ce
        )

    [HTTP_COOKIE_VARS] => Array
        (
            [PHPSESSID] => eb654635a39028b26aa4ec7a1d56c9ce
        )

    [_SERVER] => Array
        (
            [DOCUMENT_ROOT] => /home/claudebu/public_html
            [GATEWAY_INTERFACE] => CGI/1.1
            [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
            [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
            [HTTP_ACCEPT_ENCODING] => gzip
            [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
            [HTTP_CACHE_CONTROL] => no-cache
            [HTTP_CONNECTION] => close
            [HTTP_COOKIE] => PHPSESSID=eb654635a39028b26aa4ec7a1d56c9ce
            [HTTP_HOST] => www.midkentgolfclub.co.uk
            [HTTP_PRAGMA] => no-cache
            [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
            [HTTP_X_CC_ID] => ccc01-01
            [PATH] => /bin:/usr/bin
            [QUERY_STRING] => 
            [REDIRECT_STATUS] => 200
            [REMOTE_ADDR] => 38.107.179.208
            [REMOTE_PORT] => 38378
            [REQUEST_METHOD] => GET
            [REQUEST_URI] => /view_open_teams.php
            [SCRIPT_FILENAME] => /home/claudebu/public_html/view_open_teams.php
            [SCRIPT_NAME] => /view_open_teams.php
            [SERVER_ADDR] => 188.64.188.21
            [SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
            [SERVER_NAME] => www.midkentgolfclub.co.uk
            [SERVER_PORT] => 80
            [SERVER_PROTOCOL] => HTTP/1.1
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [UNIQUE_ID] => T7nW@rxAvBUAAD7aPY0AAAAH
            [PHP_SELF] => /view_open_teams.php
            [REQUEST_TIME] => 1337579258
            [argv] => Array
                (
                )

            [argc] => 0
        )

    [HTTP_SERVER_VARS] => Array
        (
            [DOCUMENT_ROOT] => /home/claudebu/public_html
            [GATEWAY_INTERFACE] => CGI/1.1
            [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
            [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
            [HTTP_ACCEPT_ENCODING] => gzip
            [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
            [HTTP_CACHE_CONTROL] => no-cache
            [HTTP_CONNECTION] => close
            [HTTP_COOKIE] => PHPSESSID=eb654635a39028b26aa4ec7a1d56c9ce
            [HTTP_HOST] => www.midkentgolfclub.co.uk
            [HTTP_PRAGMA] => no-cache
            [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
            [HTTP_X_CC_ID] => ccc01-01
            [PATH] => /bin:/usr/bin
            [QUERY_STRING] => 
            [REDIRECT_STATUS] => 200
            [REMOTE_ADDR] => 38.107.179.208
            [REMOTE_PORT] => 38378
            [REQUEST_METHOD] => GET
            [REQUEST_URI] => /view_open_teams.php
            [SCRIPT_FILENAME] => /home/claudebu/public_html/view_open_teams.php
            [SCRIPT_NAME] => /view_open_teams.php
            [SERVER_ADDR] => 188.64.188.21
            [SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
            [SERVER_NAME] => www.midkentgolfclub.co.uk
            [SERVER_PORT] => 80
            [SERVER_PROTOCOL] => HTTP/1.1
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [UNIQUE_ID] => T7nW@rxAvBUAAD7aPY0AAAAH
            [PHP_SELF] => /view_open_teams.php
            [REQUEST_TIME] => 1337579258
            [argv] => Array
                (
                )

            [argc] => 0
        )

    [_FILES] => Array
        (
        )

    [HTTP_POST_FILES] => Array
        (
        )

    [_REQUEST] => Array
        (
            [PHPSESSID] => eb654635a39028b26aa4ec7a1d56c9ce
        )

    [page_title] => View Open Teams (L)
    [raw_comments] => Parameterised to accept a year in the URL.Code  Replaces view_visiting_teams. Font size reduced and sort order variable.
    [mod_comments] => Parameterised to accept a year in the URL.Code  Replaces view_visiting_teams. Font size reduced and sort order variable.
    [referer] => HTTP_REFERER not set.
    [dev] => 
    [db] => claudebu_Vets
    [live] => 
    [email] => tcbuttle@btinternet.com
    [dbc] => Resource id #5
    [module_name] => view_open_teams.php
    [HTTP_SESSION_VARS] => Array
        (
        )

    [_SESSION] => Array
        (
        )

    [fname] => 
    [css_path] => 
    [css_print_path] => 
    [writer] => 
    [admin] => 0
    [a] => td-even
    [b] => td-odd
    [c] =>  style="color:rgb(119,136,153,"
    [tbclass] => td-even
    [_vets] => Array
        (
            [0] => Array
                (
                    [vet_id] => 
                    [surname] => 
                    [initials] => 
                    [handicap] => 
                    [active] => 
                    [year_paid] => 
                    [forename] => 
                    [comment] => 
                    [telephone_no] => 
                    [guest] => 
                )

        )

    [vets] => Array
        (
            [0] => Array
                (
                    [vet_id] => 
                    [surname] => 
                    [initials] => 
                    [forename] => 
                    [handicap] => 
                    [active] => 
                    [year_paid] => 
                )

        )

    [open_teams] => Array
        (
            [0] => Array
                (
                    [vets_open_team_id] => 
                    [vets_open_team_name] => 
                    [vets_open_id] => 
                    [contact_id] => 
                    [host_id] => 
                    [tee] => 
                    [tee_off_time] => 
                    [points_scored] => 
                    [test_tot] => 
                )

        )

    [current_yyyy] => 2012
    [this_year] => 2012
    [next_year] => 2013
    [last_year] => 2011
    [current_mm] => 5
    [current_dd] => 21
    [current_day_name] => Monday
    [current_month_name] => May
    [now_unix] => 1337554800
    [increment_version] => Y
    [team_ct] => 0
    [link1] => /view_open_teams.php?sort=team_name
    [link2] => /view_open_teams.php?sort=tee
    [link3] => /view_open_teams.php?sort=pts
    [sort] => team_name
    [table1] => vets_open
    [table2] => vets_open_player
    [table3] => vets_open_team
    [table4] => team_player_link
    [caption_year] => 2012
    [no_table_for_this_year] => 
    [sql] => SELECT * FROM vets_open_team
    [result] => Resource id #9
    [order_by] => vets_open_team_name ASC
    [div4w] => 1200
    [div4h] => 500
    [div4l] => 0
    [div4t] => 0
    [div5h] => 200
    [div5w] => 200
    [div5t] => 0
    [div5l] => 1250
    [div6h] => 200
    [div6l] => 1250
    [div6w] => 200
    [div6t] => 300
    [open_year] => 2012
    [query] => SELECT vets_open_id, DATE_FORMAT(vets_open_date,'%Y') AS od_yyyy FROM vets_open 
	WHERE (DATE_FORMAT(vets_open_date,'%Y')= 2012)
    [row] => 
)

An error occurred in script '/home/claudebu/public_html/view_open_teams.php' on line 154:
Query: SELECT contact_id, vets_open_team_name, vets_open_team_id, host_id, tee, TIME_FORMAT(tee_off_time, '%l:%i')AS short_tot, points_scored FROM vets_open_team WHERE (vets_open_id = ) ORDER BY vets_open_team_name ASC
MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY vets_open_team_name ASC' at line 2
Date/Time: 5-21-2012 06:47:38

Array
(
    [GLOBALS] => Array
 *RECURSION*
    [_ENV] => Array
        (
            [DOCUMENT_ROOT] => /home/claudebu/public_html
            [GATEWAY_INTERFACE] => CGI/1.1
            [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
            [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
            [HTTP_ACCEPT_ENCODING] => gzip
            [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
            [HTTP_CACHE_CONTROL] => no-cache
            [HTTP_CONNECTION] => close
            [HTTP_COOKIE] => PHPSESSID=eb654635a39028b26aa4ec7a1d56c9ce
            [HTTP_HOST] => www.midkentgolfclub.co.uk
            [HTTP_PRAGMA] => no-cache
            [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
            [HTTP_X_CC_ID] => ccc01-01
            [PATH] => /bin:/usr/bin
            [QUERY_STRING] => 
            [REDIRECT_STATUS] => 200
            [REMOTE_ADDR] => 38.107.179.208
            [REMOTE_PORT] => 38378
            [REQUEST_METHOD] => GET
            [REQUEST_URI] => /view_open_teams.php
            [SCRIPT_FILENAME] => /home/claudebu/public_html/view_open_teams.php
            [SCRIPT_NAME] => /view_open_teams.php
            [SERVER_ADDR] => 188.64.188.21
            [SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
            [SERVER_NAME] => www.midkentgolfclub.co.uk
            [SERVER_PORT] => 80
            [SERVER_PROTOCOL] => HTTP/1.1
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [UNIQUE_ID] => T7nW@rxAvBUAAD7aPY0AAAAH
        )

    [HTTP_ENV_VARS] => Array
        (
            [DOCUMENT_ROOT] => /home/claudebu/public_html
            [GATEWAY_INTERFACE] => CGI/1.1
            [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
            [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
            [HTTP_ACCEPT_ENCODING] => gzip
            [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
            [HTTP_CACHE_CONTROL] => no-cache
            [HTTP_CONNECTION] => close
            [HTTP_COOKIE] => PHPSESSID=eb654635a39028b26aa4ec7a1d56c9ce
            [HTTP_HOST] => www.midkentgolfclub.co.uk
            [HTTP_PRAGMA] => no-cache
            [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
            [HTTP_X_CC_ID] => ccc01-01
            [PATH] => /bin:/usr/bin
            [QUERY_STRING] => 
            [REDIRECT_STATUS] => 200
            [REMOTE_ADDR] => 38.107.179.208
            [REMOTE_PORT] => 38378
            [REQUEST_METHOD] => GET
            [REQUEST_URI] => /view_open_teams.php
            [SCRIPT_FILENAME] => /home/claudebu/public_html/view_open_teams.php
            [SCRIPT_NAME] => /view_open_teams.php
            [SERVER_ADDR] => 188.64.188.21
            [SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
            [SERVER_NAME] => www.midkentgolfclub.co.uk
            [SERVER_PORT] => 80
            [SERVER_PROTOCOL] => HTTP/1.1
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [UNIQUE_ID] => T7nW@rxAvBUAAD7aPY0AAAAH
        )

    [_POST] => Array
        (
        )

    [HTTP_POST_VARS] => Array
        (
        )

    [_GET] => Array
        (
        )

    [HTTP_GET_VARS] => Array
        (
        )

    [_COOKIE] => Array
        (
            [PHPSESSID] => eb654635a39028b26aa4ec7a1d56c9ce
        )

    [HTTP_COOKIE_VARS] => Array
        (
            [PHPSESSID] => eb654635a39028b26aa4ec7a1d56c9ce
        )

    [_SERVER] => Array
        (
            [DOCUMENT_ROOT] => /home/claudebu/public_html
            [GATEWAY_INTERFACE] => CGI/1.1
            [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
            [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
            [HTTP_ACCEPT_ENCODING] => gzip
            [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
            [HTTP_CACHE_CONTROL] => no-cache
            [HTTP_CONNECTION] => close
            [HTTP_COOKIE] => PHPSESSID=eb654635a39028b26aa4ec7a1d56c9ce
            [HTTP_HOST] => www.midkentgolfclub.co.uk
            [HTTP_PRAGMA] => no-cache
            [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
            [HTTP_X_CC_ID] => ccc01-01
            [PATH] => /bin:/usr/bin
            [QUERY_STRING] => 
            [REDIRECT_STATUS] => 200
            [REMOTE_ADDR] => 38.107.179.208
            [REMOTE_PORT] => 38378
            [REQUEST_METHOD] => GET
            [REQUEST_URI] => /view_open_teams.php
            [SCRIPT_FILENAME] => /home/claudebu/public_html/view_open_teams.php
            [SCRIPT_NAME] => /view_open_teams.php
            [SERVER_ADDR] => 188.64.188.21
            [SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
            [SERVER_NAME] => www.midkentgolfclub.co.uk
            [SERVER_PORT] => 80
            [SERVER_PROTOCOL] => HTTP/1.1
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [UNIQUE_ID] => T7nW@rxAvBUAAD7aPY0AAAAH
            [PHP_SELF] => /view_open_teams.php
            [REQUEST_TIME] => 1337579258
            [argv] => Array
                (
                )

            [argc] => 0
        )

    [HTTP_SERVER_VARS] => Array
        (
            [DOCUMENT_ROOT] => /home/claudebu/public_html
            [GATEWAY_INTERFACE] => CGI/1.1
            [HTTP_ACCEPT] => text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
            [HTTP_ACCEPT_CHARSET] => ISO-8859-1,utf-8;q=0.7,*;q=0.7
            [HTTP_ACCEPT_ENCODING] => gzip
            [HTTP_ACCEPT_LANGUAGE] => en-us,en;q=0.5
            [HTTP_CACHE_CONTROL] => no-cache
            [HTTP_CONNECTION] => close
            [HTTP_COOKIE] => PHPSESSID=eb654635a39028b26aa4ec7a1d56c9ce
            [HTTP_HOST] => www.midkentgolfclub.co.uk
            [HTTP_PRAGMA] => no-cache
            [HTTP_USER_AGENT] => CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
            [HTTP_X_CC_ID] => ccc01-01
            [PATH] => /bin:/usr/bin
            [QUERY_STRING] => 
            [REDIRECT_STATUS] => 200
            [REMOTE_ADDR] => 38.107.179.208
            [REMOTE_PORT] => 38378
            [REQUEST_METHOD] => GET
            [REQUEST_URI] => /view_open_teams.php
            [SCRIPT_FILENAME] => /home/claudebu/public_html/view_open_teams.php
            [SCRIPT_NAME] => /view_open_teams.php
            [SERVER_ADDR] => 188.64.188.21
            [SERVER_ADMIN] => webmaster@midkentgolfclub.co.uk
            [SERVER_NAME] => www.midkentgolfclub.co.uk
            [SERVER_PORT] => 80
            [SERVER_PROTOCOL] => HTTP/1.1
            [SERVER_SIGNATURE] => 
            [SERVER_SOFTWARE] => Apache
            [UNIQUE_ID] => T7nW@rxAvBUAAD7aPY0AAAAH
            [PHP_SELF] => /view_open_teams.php
            [REQUEST_TIME] => 1337579258
            [argv] => Array
                (
                )

            [argc] => 0
        )

    [_FILES] => Array
        (
        )

    [HTTP_POST_FILES] => Array
        (
        )

    [_REQUEST] => Array
        (
            [PHPSESSID] => eb654635a39028b26aa4ec7a1d56c9ce
        )

    [page_title] => View Open Teams (L)
    [raw_comments] => Parameterised to accept a year in the URL.Code  Replaces view_visiting_teams. Font size reduced and sort order variable.
    [mod_comments] => Parameterised to accept a year in the URL.Code  Replaces view_visiting_teams. Font size reduced and sort order variable.
    [referer] => HTTP_REFERER not set.
    [dev] => 
    [db] => claudebu_Vets
    [live] => 
    [email] => tcbuttle@btinternet.com
    [dbc] => Resource id #5
    [module_name] => view_open_teams.php
    [HTTP_SESSION_VARS] => Array
        (
        )

    [_SESSION] => Array
        (
        )

    [fname] => 
    [css_path] => 
    [css_print_path] => 
    [writer] => 
    [admin] => 0
    [a] => td-even
    [b] => td-odd
    [c] =>  style="color:rgb(119,136,153,"
    [tbclass] => td-even
    [_vets] => Array
        (
            [0] => Array
                (
                    [vet_id] => 
                    [surname] => 
                    [initials] => 
                    [handicap] => 
                    [active] => 
                    [year_paid] => 
                    [forename] => 
                    [comment] => 
                    [telephone_no] => 
                    [guest] => 
                )

        )

    [vets] => Array
        (
            [0] => Array
                (
                    [vet_id] => 
                    [surname] => 
                    [initials] => 
                    [forename] => 
                    [handicap] => 
                    [active] => 
                    [year_paid] => 
                )

        )

    [open_teams] => Array
        (
            [0] => Array
                (
                    [vets_open_team_id] => 
                    [vets_open_team_name] => 
                    [vets_open_id] => 
                    [contact_id] => 
                    [host_id] => 
                    [tee] => 
                    [tee_off_time] => 
                    [points_scored] => 
                    [test_tot] => 
                )

        )

    [current_yyyy] => 2012
    [this_year] => 2012
    [next_year] => 2013
    [last_year] => 2011
    [current_mm] => 5
    [current_dd] => 21
    [current_day_name] => Monday
    [current_month_name] => May
    [now_unix] => 1337554800
    [increment_version] => Y
    [team_ct] => 0
    [link1] => /view_open_teams.php?sort=team_name
    [link2] => /view_open_teams.php?sort=tee
    [link3] => /view_open_teams.php?sort=pts
    [sort] => team_name
    [table1] => vets_open
    [table2] => vets_open_player
    [table3] => vets_open_team
    [table4] => team_player_link
    [caption_year] => 2012
    [no_table_for_this_year] => 
    [sql] => SELECT * FROM vets_open_team
    [result] => Resource id #9
    [order_by] => vets_open_team_name ASC
    [div4w] => 1200
    [div4h] => 500
    [div4l] => 0
    [div4t] => 0
    [div5h] => 200
    [div5w] => 200
    [div5t] => 0
    [div5l] => 1250
    [div6h] => 200
    [div6l] => 1250
    [div6w] => 200
    [div6t] => 300
    [open_year] => 2012
    [query] => SELECT vets_open_id, DATE_FORMAT(vets_open_date,'%Y') AS od_yyyy FROM vets_open 
	WHERE (DATE_FORMAT(vets_open_date,'%Y')= 2012)
    [row] => 
    [query1] => SELECT contact_id, vets_open_team_name, vets_open_team_id, host_id, tee, 
	TIME_FORMAT(tee_off_time, '%l:%i')AS short_tot, points_scored FROM vets_open_team WHERE (vets_open_id = ) ORDER BY vets_open_team_name ASC
    [result1] => 
)

Could not run query on line 117: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY vets_open_team_name ASC' at line 2

Details of all competing teams in the 2012 Veterans Open
Team	Contact	Players			Host	Tee	TOT	Pts