CONTACT LENSES



Acuvue Logo
Air Optix Logo
Biofinity
Biotrue Logo
Clariti Logo
Dailies Logo
ExtremeH2O Logo
Freshlook Logo
Proclear Logo
PureVision Logo
Soflens Logo
All Brands

An error occurred in script '/home/cid006/public_html/scripts/store/processSearch-contact-lenses.php' on line 46:
mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given
Array
(
[0] => Array
(
[function] => my_error_handler
[args] => Array
(
[0] => 2
[1] => mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given
[2] => /home/cid006/public_html/scripts/store/processSearch-contact-lenses.php
[3] => 46
[4] => Array
(
[_GET] => Array
(
[contactsBrand] => Proclear
)

[_POST] => Array
(
)

[_COOKIE] => Array
(
[PHPSESSID] => 17b9421c3870d38ee80593b87cbc57d1
)

[_FILES] => Array
(
)

[_SERVER] => Array
(
[USER] => cid006
[HOME] => /home/cid006
[SCRIPT_NAME] => /store/index.php
[REQUEST_URI] => /store/contact-lenses/?contactsBrand=Proclear
[QUERY_STRING] => contactsBrand=Proclear
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/1.1
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_QUERY_STRING] => contactsBrand=Proclear
[REDIRECT_URL] => /store/contact-lenses/
[REMOTE_PORT] => 43971
[SCRIPT_FILENAME] => /home/cid006/public_html/store/index.php
[SERVER_ADMIN] => webmaster@eyeglassuniverse.com
[CONTEXT_DOCUMENT_ROOT] => /home/cid006/public_html
[CONTEXT_PREFIX] =>
[REQUEST_SCHEME] => https
[DOCUMENT_ROOT] => /home/cid006/public_html
[REMOTE_ADDR] => 3.144.93.14
[SERVER_PORT] => 443
[SERVER_ADDR] => 172.19.0.50
[SERVER_NAME] => eyeglassuniverse.com
[SERVER_SOFTWARE] => Apache
[SERVER_SIGNATURE] =>
[PATH] => /usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
[HTTP_X_HTTPS] => 1
[HTTP_HOST] => eyeglassuniverse.com
[HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate
[HTTP_COOKIE] => PHPSESSID=17b9421c3870d38ee80593b87cbc57d1
[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[HTTP_ACCEPT] => */*
[proxy-nokeepalive] => 1
[SSL_TLS_SNI] => eyeglassuniverse.com
[HTTPS] => on
[SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses/
[SCRIPT_URL] => /store/contact-lenses/
[UNIQUE_ID] => Zz74P_o_w-rUU_VFfQPgLAAAABc
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] => eyeglassuniverse.com
[REDIRECT_HTTPS] => on
[REDIRECT_SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses/
[REDIRECT_SCRIPT_URL] => /store/contact-lenses/
[REDIRECT_UNIQUE_ID] => Zz74P_o_w-rUU_VFfQPgLAAAABc
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /store/index.php
[REQUEST_TIME_FLOAT] => 1732180031.0375
[REQUEST_TIME] => 1732180031
[argv] => Array
(
[0] => contactsBrand=Proclear
)

[argc] => 1
)

[_REQUEST] => Array
(
[contactsBrand] => Proclear
)

[_ENV] => Array
(
)

[GLOBALS] => Array
(
[_GET] => Array
(
[contactsBrand] => Proclear
)

[_POST] => Array
(
)

[_COOKIE] => Array
(
[PHPSESSID] => 17b9421c3870d38ee80593b87cbc57d1
)

[_FILES] => Array
(
)

[_SERVER] => Array
(
[USER] => cid006
[HOME] => /home/cid006
[SCRIPT_NAME] => /store/index.php
[REQUEST_URI] => /store/contact-lenses/?contactsBrand=Proclear
[QUERY_STRING] => contactsBrand=Proclear
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/1.1
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_QUERY_STRING] => contactsBrand=Proclear
[REDIRECT_URL] => /store/contact-lenses/
[REMOTE_PORT] => 43971
[SCRIPT_FILENAME] => /home/cid006/public_html/store/index.php
[SERVER_ADMIN] => webmaster@eyeglassuniverse.com
[CONTEXT_DOCUMENT_ROOT] => /home/cid006/public_html
[CONTEXT_PREFIX] =>
[REQUEST_SCHEME] => https
[DOCUMENT_ROOT] => /home/cid006/public_html
[REMOTE_ADDR] => 3.144.93.14
[SERVER_PORT] => 443
[SERVER_ADDR] => 172.19.0.50
[SERVER_NAME] => eyeglassuniverse.com
[SERVER_SOFTWARE] => Apache
[SERVER_SIGNATURE] =>
[PATH] => /usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
[HTTP_X_HTTPS] => 1
[HTTP_HOST] => eyeglassuniverse.com
[HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate
[HTTP_COOKIE] => PHPSESSID=17b9421c3870d38ee80593b87cbc57d1
[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[HTTP_ACCEPT] => */*
[proxy-nokeepalive] => 1
[SSL_TLS_SNI] => eyeglassuniverse.com
[HTTPS] => on
[SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses/
[SCRIPT_URL] => /store/contact-lenses/
[UNIQUE_ID] => Zz74P_o_w-rUU_VFfQPgLAAAABc
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] => eyeglassuniverse.com
[REDIRECT_HTTPS] => on
[REDIRECT_SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses/
[REDIRECT_SCRIPT_URL] => /store/contact-lenses/
[REDIRECT_UNIQUE_ID] => Zz74P_o_w-rUU_VFfQPgLAAAABc
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /store/index.php
[REQUEST_TIME_FLOAT] => 1732180031.0375
[REQUEST_TIME] => 1732180031
[argv] => Array
(
[0] => contactsBrand=Proclear
)

[argc] => 1
)

[_REQUEST] => Array
(
[contactsBrand] => Proclear
)

[_ENV] => Array
(
)

[GLOBALS] => Array
*RECURSION*
[pageID] => 100
[productURLData] => Array
(
[0] =>
[1] => store
[2] => contact-lenses
[3] => ?contactsBrand=Proclear
)

[productType] => contact-lenses
[validTypes] => Array
(
[0] => eyeglasses
[1] => contact-lenses
[2] => safety-glasses
[3] => reglazing
[4] => brands
[5] => test
[6] => reglazingTest
)

[productName] => ?contactsBrand=Proclear
[display] =>
[testStatus] => 1
[testMessage] => System is in TEST mode.
[_SESSION] => Array
(
)

[dbc] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1055
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[error_list] => Array
(
[0] => Array
(
[errno] => 1055
[sqlstate] => 42000
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)

)

[field_count] => 4
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 8.0.35
[server_version] => 80035
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 24504668
[warning_count] => 0
)

[pageid] => 1
[q] => SELECT DISTINCT c.contactsID, m.manufacturerName, c.contactsBrandPrimary, c.contactsBrandSecondary, c.contactsPackSize, c.contactsImage, c.contactsMSRP FROM product_contacts AS c INNER JOIN manufacturers_contacts AS m ON c.contactsManufacturer = m.manufacturerID WHERE contactsBrandPrimary LIKE '%Proclear%' GROUP BY c.contactsBrandSecondary ORDER BY contactsMSRP
[r] =>
[metadataTitle] => Quality and Value in online prescription eyeglasses | EyeglassUniverse
[metadataKeywords] => eyeglasses, glasses, prescription eyeglasses, prescription glasses, buy glasses online, buy eyeglasses online, buy prescription glasses online, buy prescription eyeglasses online, eyeglasses online, glasses online, sunglasses, contact lenses
[metadataDescription] => Shop our huge selection of fashion eyeglass frames, Sunglasses, Contact Lenses, Prescription glasses for men and women, and Workplace Safety Eyewear.
[metadataRobots] => INDEX, FOLLOW
[pageHeadline] =>
[pageSubtitle] =>
[pageContent] =>
[minicartQuery] => SELECT id, user_session_id, quantity, dataJSON FROM carts WHERE user_session_id = "17b9421c3870d38ee80593b87cbc57d1" ORDER BY date_created
[minicartRequest] => mysqli_result Object
(
[current_field] => 0
[field_count] => 4
[lengths] =>
[num_rows] => 0
[type] => 0
)

[minicartRows] => 0
[minicartSubtotal] => 0
[minicartOutput] =>



Subtotal




$0.00







[dataJSON] =>
[quantity] =>
[cartID] =>
[userID] =>
[w] => WHERE contactsBrandPrimary LIKE '%Proclear%'
[pass] => &contactsBrand=Proclear
[brand] => %Proclear%
[perPage] => 24
[startingRecord] => 0
)

[pageID] => 100
[productURLData] => Array
(
[0] =>
[1] => store
[2] => contact-lenses
[3] => ?contactsBrand=Proclear
)

[productType] => contact-lenses
[validTypes] => Array
(
[0] => eyeglasses
[1] => contact-lenses
[2] => safety-glasses
[3] => reglazing
[4] => brands
[5] => test
[6] => reglazingTest
)

[productName] => ?contactsBrand=Proclear
[display] =>
[testStatus] => 1
[testMessage] => System is in TEST mode.
[_SESSION] => Array
(
)

[dbc] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1055
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[error_list] => Array
(
[0] => Array
(
[errno] => 1055
[sqlstate] => 42000
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)

)

[field_count] => 4
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 8.0.35
[server_version] => 80035
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 24504668
[warning_count] => 0
)

[pageid] => 1
[q] => SELECT DISTINCT c.contactsID, m.manufacturerName, c.contactsBrandPrimary, c.contactsBrandSecondary, c.contactsPackSize, c.contactsImage, c.contactsMSRP FROM product_contacts AS c INNER JOIN manufacturers_contacts AS m ON c.contactsManufacturer = m.manufacturerID WHERE contactsBrandPrimary LIKE '%Proclear%' GROUP BY c.contactsBrandSecondary ORDER BY contactsMSRP
[r] =>
[metadataTitle] => Quality and Value in online prescription eyeglasses | EyeglassUniverse
[metadataKeywords] => eyeglasses, glasses, prescription eyeglasses, prescription glasses, buy glasses online, buy eyeglasses online, buy prescription glasses online, buy prescription eyeglasses online, eyeglasses online, glasses online, sunglasses, contact lenses
[metadataDescription] => Shop our huge selection of fashion eyeglass frames, Sunglasses, Contact Lenses, Prescription glasses for men and women, and Workplace Safety Eyewear.
[metadataRobots] => INDEX, FOLLOW
[pageHeadline] =>
[pageSubtitle] =>
[pageContent] =>
[minicartQuery] => SELECT id, user_session_id, quantity, dataJSON FROM carts WHERE user_session_id = "17b9421c3870d38ee80593b87cbc57d1" ORDER BY date_created
[minicartRequest] => mysqli_result Object
(
[current_field] => 0
[field_count] => 4
[lengths] =>
[num_rows] => 0
[type] => 0
)

[minicartRows] => 0
[minicartSubtotal] => 0
[minicartOutput] =>



Subtotal




$0.00







[dataJSON] =>
[quantity] =>
[cartID] =>
[userID] =>
[w] => WHERE contactsBrandPrimary LIKE '%Proclear%'
[pass] => &contactsBrand=Proclear
[brand] => %Proclear%
[perPage] => 24
[startingRecord] => 0
)

)

)

[1] => Array
(
[file] => /home/cid006/public_html/scripts/store/processSearch-contact-lenses.php
[line] => 46
[function] => mysqli_num_rows
[args] => Array
(
[0] =>
)

)

[2] => Array
(
[file] => /home/cid006/public_html/store/index.php
[line] => 72
[args] => Array
(
[0] => /home/cid006/public_html/scripts/store/processSearch-contact-lenses.php
)

[function] => require
)

)

An error occurred in script '/home/cid006/public_html/scripts/store/processSearch-contact-lenses.php' on line 61:
mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given
Array
(
[0] => Array
(
[function] => my_error_handler
[args] => Array
(
[0] => 2
[1] => mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given
[2] => /home/cid006/public_html/scripts/store/processSearch-contact-lenses.php
[3] => 61
[4] => Array
(
[_GET] => Array
(
[contactsBrand] => Proclear
)

[_POST] => Array
(
)

[_COOKIE] => Array
(
[PHPSESSID] => 17b9421c3870d38ee80593b87cbc57d1
)

[_FILES] => Array
(
)

[_SERVER] => Array
(
[USER] => cid006
[HOME] => /home/cid006
[SCRIPT_NAME] => /store/index.php
[REQUEST_URI] => /store/contact-lenses/?contactsBrand=Proclear
[QUERY_STRING] => contactsBrand=Proclear
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/1.1
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_QUERY_STRING] => contactsBrand=Proclear
[REDIRECT_URL] => /store/contact-lenses/
[REMOTE_PORT] => 43971
[SCRIPT_FILENAME] => /home/cid006/public_html/store/index.php
[SERVER_ADMIN] => webmaster@eyeglassuniverse.com
[CONTEXT_DOCUMENT_ROOT] => /home/cid006/public_html
[CONTEXT_PREFIX] =>
[REQUEST_SCHEME] => https
[DOCUMENT_ROOT] => /home/cid006/public_html
[REMOTE_ADDR] => 3.144.93.14
[SERVER_PORT] => 443
[SERVER_ADDR] => 172.19.0.50
[SERVER_NAME] => eyeglassuniverse.com
[SERVER_SOFTWARE] => Apache
[SERVER_SIGNATURE] =>
[PATH] => /usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
[HTTP_X_HTTPS] => 1
[HTTP_HOST] => eyeglassuniverse.com
[HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate
[HTTP_COOKIE] => PHPSESSID=17b9421c3870d38ee80593b87cbc57d1
[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[HTTP_ACCEPT] => */*
[proxy-nokeepalive] => 1
[SSL_TLS_SNI] => eyeglassuniverse.com
[HTTPS] => on
[SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses/
[SCRIPT_URL] => /store/contact-lenses/
[UNIQUE_ID] => Zz74P_o_w-rUU_VFfQPgLAAAABc
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] => eyeglassuniverse.com
[REDIRECT_HTTPS] => on
[REDIRECT_SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses/
[REDIRECT_SCRIPT_URL] => /store/contact-lenses/
[REDIRECT_UNIQUE_ID] => Zz74P_o_w-rUU_VFfQPgLAAAABc
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /store/index.php
[REQUEST_TIME_FLOAT] => 1732180031.0375
[REQUEST_TIME] => 1732180031
[argv] => Array
(
[0] => contactsBrand=Proclear
)

[argc] => 1
)

[_REQUEST] => Array
(
[contactsBrand] => Proclear
)

[_ENV] => Array
(
)

[GLOBALS] => Array
(
[_GET] => Array
(
[contactsBrand] => Proclear
)

[_POST] => Array
(
)

[_COOKIE] => Array
(
[PHPSESSID] => 17b9421c3870d38ee80593b87cbc57d1
)

[_FILES] => Array
(
)

[_SERVER] => Array
(
[USER] => cid006
[HOME] => /home/cid006
[SCRIPT_NAME] => /store/index.php
[REQUEST_URI] => /store/contact-lenses/?contactsBrand=Proclear
[QUERY_STRING] => contactsBrand=Proclear
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/1.1
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_QUERY_STRING] => contactsBrand=Proclear
[REDIRECT_URL] => /store/contact-lenses/
[REMOTE_PORT] => 43971
[SCRIPT_FILENAME] => /home/cid006/public_html/store/index.php
[SERVER_ADMIN] => webmaster@eyeglassuniverse.com
[CONTEXT_DOCUMENT_ROOT] => /home/cid006/public_html
[CONTEXT_PREFIX] =>
[REQUEST_SCHEME] => https
[DOCUMENT_ROOT] => /home/cid006/public_html
[REMOTE_ADDR] => 3.144.93.14
[SERVER_PORT] => 443
[SERVER_ADDR] => 172.19.0.50
[SERVER_NAME] => eyeglassuniverse.com
[SERVER_SOFTWARE] => Apache
[SERVER_SIGNATURE] =>
[PATH] => /usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin
[HTTP_X_HTTPS] => 1
[HTTP_HOST] => eyeglassuniverse.com
[HTTP_ACCEPT_ENCODING] => gzip, br, zstd, deflate
[HTTP_COOKIE] => PHPSESSID=17b9421c3870d38ee80593b87cbc57d1
[HTTP_USER_AGENT] => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
[HTTP_ACCEPT] => */*
[proxy-nokeepalive] => 1
[SSL_TLS_SNI] => eyeglassuniverse.com
[HTTPS] => on
[SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses/
[SCRIPT_URL] => /store/contact-lenses/
[UNIQUE_ID] => Zz74P_o_w-rUU_VFfQPgLAAAABc
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] => eyeglassuniverse.com
[REDIRECT_HTTPS] => on
[REDIRECT_SCRIPT_URI] => https://eyeglassuniverse.com/store/contact-lenses/
[REDIRECT_SCRIPT_URL] => /store/contact-lenses/
[REDIRECT_UNIQUE_ID] => Zz74P_o_w-rUU_VFfQPgLAAAABc
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /store/index.php
[REQUEST_TIME_FLOAT] => 1732180031.0375
[REQUEST_TIME] => 1732180031
[argv] => Array
(
[0] => contactsBrand=Proclear
)

[argc] => 1
)

[_REQUEST] => Array
(
[contactsBrand] => Proclear
)

[_ENV] => Array
(
)

[GLOBALS] => Array
*RECURSION*
[pageID] => 100
[productURLData] => Array
(
[0] =>
[1] => store
[2] => contact-lenses
[3] => ?contactsBrand=Proclear
)

[productType] => contact-lenses
[validTypes] => Array
(
[0] => eyeglasses
[1] => contact-lenses
[2] => safety-glasses
[3] => reglazing
[4] => brands
[5] => test
[6] => reglazingTest
)

[productName] => ?contactsBrand=Proclear
[display] =>
[testStatus] => 1
[testMessage] => System is in TEST mode.
[_SESSION] => Array
(
)

[dbc] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1055
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[error_list] => Array
(
[0] => Array
(
[errno] => 1055
[sqlstate] => 42000
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)

)

[field_count] => 4
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 8.0.35
[server_version] => 80035
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 24504668
[warning_count] => 0
)

[pageid] => 1
[q] => SELECT DISTINCT c.contactsID, m.manufacturerName, c.contactsBrandPrimary, c.contactsBrandSecondary, c.contactsPackSize, c.contactsImage, c.contactsMSRP FROM product_contacts AS c INNER JOIN manufacturers_contacts AS m ON c.contactsManufacturer = m.manufacturerID WHERE contactsBrandPrimary LIKE '%Proclear%' GROUP BY c.contactsBrandSecondary ORDER BY contactsMSRP LIMIT 0, 24
[r] =>
[metadataTitle] => Quality and Value in online prescription eyeglasses | EyeglassUniverse
[metadataKeywords] => eyeglasses, glasses, prescription eyeglasses, prescription glasses, buy glasses online, buy eyeglasses online, buy prescription glasses online, buy prescription eyeglasses online, eyeglasses online, glasses online, sunglasses, contact lenses
[metadataDescription] => Shop our huge selection of fashion eyeglass frames, Sunglasses, Contact Lenses, Prescription glasses for men and women, and Workplace Safety Eyewear.
[metadataRobots] => INDEX, FOLLOW
[pageHeadline] =>
[pageSubtitle] =>
[pageContent] =>
[minicartQuery] => SELECT id, user_session_id, quantity, dataJSON FROM carts WHERE user_session_id = "17b9421c3870d38ee80593b87cbc57d1" ORDER BY date_created
[minicartRequest] => mysqli_result Object
(
[current_field] => 0
[field_count] => 4
[lengths] =>
[num_rows] => 0
[type] => 0
)

[minicartRows] => 0
[minicartSubtotal] => 0
[minicartOutput] =>



Subtotal




$0.00







[dataJSON] =>
[quantity] =>
[cartID] =>
[userID] =>
[w] => WHERE contactsBrandPrimary LIKE '%Proclear%'
[pass] => &contactsBrand=Proclear
[brand] => %Proclear%
[perPage] => 24
[startingRecord] => 0
[totalRows] =>
[pages] => 0
)

[pageID] => 100
[productURLData] => Array
(
[0] =>
[1] => store
[2] => contact-lenses
[3] => ?contactsBrand=Proclear
)

[productType] => contact-lenses
[validTypes] => Array
(
[0] => eyeglasses
[1] => contact-lenses
[2] => safety-glasses
[3] => reglazing
[4] => brands
[5] => test
[6] => reglazingTest
)

[productName] => ?contactsBrand=Proclear
[display] =>
[testStatus] => 1
[testMessage] => System is in TEST mode.
[_SESSION] => Array
(
)

[dbc] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1055
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[error_list] => Array
(
[0] => Array
(
[errno] => 1055
[sqlstate] => 42000
[error] => Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'cid006_live.c.contactsID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)

)

[field_count] => 4
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 8.0.35
[server_version] => 80035
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 24504668
[warning_count] => 0
)

[pageid] => 1
[q] => SELECT DISTINCT c.contactsID, m.manufacturerName, c.contactsBrandPrimary, c.contactsBrandSecondary, c.contactsPackSize, c.contactsImage, c.contactsMSRP FROM product_contacts AS c INNER JOIN manufacturers_contacts AS m ON c.contactsManufacturer = m.manufacturerID WHERE contactsBrandPrimary LIKE '%Proclear%' GROUP BY c.contactsBrandSecondary ORDER BY contactsMSRP LIMIT 0, 24
[r] =>
[metadataTitle] => Quality and Value in online prescription eyeglasses | EyeglassUniverse
[metadataKeywords] => eyeglasses, glasses, prescription eyeglasses, prescription glasses, buy glasses online, buy eyeglasses online, buy prescription glasses online, buy prescription eyeglasses online, eyeglasses online, glasses online, sunglasses, contact lenses
[metadataDescription] => Shop our huge selection of fashion eyeglass frames, Sunglasses, Contact Lenses, Prescription glasses for men and women, and Workplace Safety Eyewear.
[metadataRobots] => INDEX, FOLLOW
[pageHeadline] =>
[pageSubtitle] =>
[pageContent] =>
[minicartQuery] => SELECT id, user_session_id, quantity, dataJSON FROM carts WHERE user_session_id = "17b9421c3870d38ee80593b87cbc57d1" ORDER BY date_created
[minicartRequest] => mysqli_result Object
(
[current_field] => 0
[field_count] => 4
[lengths] =>
[num_rows] => 0
[type] => 0
)

[minicartRows] => 0
[minicartSubtotal] => 0
[minicartOutput] =>



Subtotal




$0.00







[dataJSON] =>
[quantity] =>
[cartID] =>
[userID] =>
[w] => WHERE contactsBrandPrimary LIKE '%Proclear%'
[pass] => &contactsBrand=Proclear
[brand] => %Proclear%
[perPage] => 24
[startingRecord] => 0
[totalRows] =>
[pages] => 0
)

)

)

[1] => Array
(
[file] => /home/cid006/public_html/scripts/store/processSearch-contact-lenses.php
[line] => 61
[function] => mysqli_fetch_array
[args] => Array
(
[0] =>
[1] => 2
)

)

[2] => Array
(
[file] => /home/cid006/public_html/store/index.php
[line] => 72
[args] => Array
(
[0] => /home/cid006/public_html/scripts/store/processSearch-contact-lenses.php
)

[function] => require
)

)





Eyeglass Universe
Midwest Optical Associates, Inc.
8114 Paul Manors Drive, Suite 500
West Chester, OH, 45069-0219
Phone: (888) 989-3931
Text: (513) 338-4895
Fax: (855) 398-3937
Midwest Optical Associates, Inc. BBB Business Review