Hampshire Squash Rackets Association
Online League Management System 2025/2026
League Rules
Racketball Section
Playing Record for  of  [Full Player Statistics]  [Main]
 [Main]
 
Untitled Document
Array
(
    [0] => Array
        (
            [file] => /home/leagueorganiser/public_html/players.php
            [line] => 145
            [function] => mysqli_handler_query
            [args] => Array
                (
                    [0] => mysqli Object
                        (
                            [affected_rows] => -1
                            [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
                            [client_version] => 50012
                            [connect_errno] => 0
                            [connect_error] => 
                            [errno] => 1064
                            [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 'and P.SportID=2 order by P.PlayerDateAdded limit 1' at line 1
                            [error_list] => Array
                                (
                                    [0] => Array
                                        (
                                            [errno] => 1064
                                            [sqlstate] => 42000
                                            [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 'and P.SportID=2 order by P.PlayerDateAdded limit 1' at line 1
                                        )
                                )
                            [field_count] => 59
                            [host_info] => Localhost via UNIX socket
                            [info] => 
                            [insert_id] => 0
                            [server_info] => 5.7.44
                            [server_version] => 50744
                            [stat] => Uptime: 25207772  Threads: 5  Questions: 1860668626  Slow queries: 0  Opens: 5405887  Flush tables: 1  Open tables: 2000  Queries per second avg: 73.813
                            [sqlstate] => 00000
                            [protocol_version] => 10
                            [thread_id] => 72719672
                            [warning_count] => 0
                        )
                    [1] => select * from Players P where P.PlayerPortalID= and P.SportID=2 order by P.PlayerDateAdded limit 1
                )
        )
)
MySQL Query select * from Players P where P.PlayerPortalID= and P.SportID=2 order by P.PlayerDateAdded limit 1 failed
Called from /home/leagueorganiser/public_html/players.php - Line 145 on Database dbm
0: 
Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/leagueorganiser/public_html/players.php on line 146
Array
(
    [0] => Array
        (
            [file] => /home/leagueorganiser/public_html/players.php
            [line] => 150
            [function] => mysqli_handler_query
            [args] => Array
                (
                    [0] => mysqli Object
                        (
                            [affected_rows] => -1
                            [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
                            [client_version] => 50012
                            [connect_errno] => 0
                            [connect_error] => 
                            [errno] => 1064
                            [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 '' at line 1
                            [error_list] => Array
                                (
                                    [0] => Array
                                        (
                                            [errno] => 1064
                                            [sqlstate] => 42000
                                            [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 '' at line 1
                                        )
                                )
                            [field_count] => 59
                            [host_info] => Localhost via UNIX socket
                            [info] => 
                            [insert_id] => 0
                            [server_info] => 5.7.44
                            [server_version] => 50744
                            [stat] => Uptime: 25207772  Threads: 5  Questions: 1860668628  Slow queries: 0  Opens: 5405887  Flush tables: 1  Open tables: 2000  Queries per second avg: 73.813
                            [sqlstate] => 00000
                            [protocol_version] => 10
                            [thread_id] => 72719672
                            [warning_count] => 0
                        )
                    [1] => select * from PlayerPortals PP where PP.PlayerPortalID=
                )
        )
)
MySQL Query select * from PlayerPortals PP where PP.PlayerPortalID= failed
Called from /home/leagueorganiser/public_html/players.php - Line 150 on Database dbm
0: 
Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/leagueorganiser/public_html/players.php on line 151
   
    | Current Club Ranking | 0 (0) | ESR Number | ***** | 
  
    | SL Points | 
 | 
   
    | Played | 0 | Won | 0 | Lost | 0 | 
   
    |  |  | Games For | 0 | Games Against | 0 | 
   
    |  |  | Points For | 0 | PointsAgainst | 0 | 
	
	| Day | Date | Time | Competition | Div | String | Home Team | AwayTeam | Opponent | Result | Points For | Points Against | 
Player has no ES number in this section, stats will not be accurate
225 psq Select * from Strings S where S.PlayerID=
		and S.StringDatePlayed>='2025-09-22'
		and S.StringDatePlayed<='2026-03-29'
		ORDER by S.StringDatePlayed asc, S.StringTimePlayed asc, S.StringID asc
Array
(
    [0] => Array
        (
            [file] => /home/leagueorganiser/public_html/players.php
            [line] => 286
            [function] => mysqli_handler_query
            [args] => Array
                (
                    [0] => mysqli Object
                        (
                            [affected_rows] => -1
                            [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
                            [client_version] => 50012
                            [connect_errno] => 0
                            [connect_error] => 
                            [errno] => 1064
                            [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 'and S.StringDatePlayed>='2025-09-22'
		and S.StringDatePlayed<='2026-03-29'
		' at line 2
                            [error_list] => Array
                                (
                                    [0] => Array
                                        (
                                            [errno] => 1064
                                            [sqlstate] => 42000
                                            [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 'and S.StringDatePlayed>='2025-09-22'
		and S.StringDatePlayed<='2026-03-29'
		' at line 2
                                        )
                                )
                            [field_count] => 59
                            [host_info] => Localhost via UNIX socket
                            [info] => 
                            [insert_id] => 0
                            [server_info] => 5.7.44
                            [server_version] => 50744
                            [stat] => Uptime: 25207772  Threads: 5  Questions: 1860668630  Slow queries: 0  Opens: 5405887  Flush tables: 1  Open tables: 2000  Queries per second avg: 73.813
                            [sqlstate] => 00000
                            [protocol_version] => 10
                            [thread_id] => 72719672
                            [warning_count] => 0
                        )
                    [1] => Select * from Strings S where S.PlayerID=
		and S.StringDatePlayed>='2025-09-22'
		and S.StringDatePlayed<='2026-03-29'
		ORDER by S.StringDatePlayed asc, S.StringTimePlayed asc, S.StringID asc
                )
        )
)
MySQL Query Select * from Strings S where S.PlayerID=
		and S.StringDatePlayed>='2025-09-22'
		and S.StringDatePlayed<='2026-03-29'
		ORDER by S.StringDatePlayed asc, S.StringTimePlayed asc, S.StringID asc failed
Called from /home/leagueorganiser/public_html/players.php - Line 286 on Database dbm
0: 
Warning:  mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/leagueorganiser/public_html/players.php on line 290