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

Search

Select as many options as you wish from the form below then click the submit button to perform a custom search.


Alcon
Bausch+Lomb
CooperVision
Johnson & Johnson Vision


Daily
Weekly
Monthly


Standard
Toric
Multifocal
Cosmetic

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
(
[sidebar] => 1
)

[_POST] => Array
(
)

[_COOKIE] => Array
(
)

[_FILES] => Array
(
)

[_SERVER] => Array
(
[USER] => cid006
[HOME] => /home/cid006
[SCRIPT_NAME] => /store/index.php
[REQUEST_URI] => /store/contact-lenses/?sidebar=1
[QUERY_STRING] => sidebar=1
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/1.1
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_QUERY_STRING] => sidebar=1
[REDIRECT_URL] => /store/contact-lenses/
[REMOTE_PORT] => 47046
[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] => 18.97.14.90
[SERVER_PORT] => 443
[SERVER_ADDR] => 172.19.0.50
[SERVER_NAME] => www.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_CONNECTION] => Keep-Alive
[HTTP_HOST] => www.eyeglassuniverse.com
[HTTP_ACCEPT_ENCODING] => br,gzip
[HTTP_IF_MODIFIED_SINCE] => Tue, 21 May 2024 18:55:44 GMT
[HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/)
[proxy-nokeepalive] => 1
[SSL_TLS_SNI] => www.eyeglassuniverse.com
[HTTPS] => on
[SCRIPT_URI] => https://www.eyeglassuniverse.com/store/contact-lenses/
[SCRIPT_URL] => /store/contact-lenses/
[UNIQUE_ID] => Z1u-QNEKAFzhBagOqoOQpgAAAAc
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] => www.eyeglassuniverse.com
[REDIRECT_HTTPS] => on
[REDIRECT_SCRIPT_URI] => https://www.eyeglassuniverse.com/store/contact-lenses/
[REDIRECT_SCRIPT_URL] => /store/contact-lenses/
[REDIRECT_UNIQUE_ID] => Z1u-QNEKAFzhBagOqoOQpgAAAAc
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /store/index.php
[REQUEST_TIME_FLOAT] => 1734065728.8198
[REQUEST_TIME] => 1734065728
[argv] => Array
(
[0] => sidebar=1
)

[argc] => 1
)

[_REQUEST] => Array
(
[sidebar] => 1
)

[_ENV] => Array
(
)

[GLOBALS] => Array
(
[_GET] => Array
(
[sidebar] => 1
)

[_POST] => Array
(
)

[_COOKIE] => Array
(
)

[_FILES] => Array
(
)

[_SERVER] => Array
(
[USER] => cid006
[HOME] => /home/cid006
[SCRIPT_NAME] => /store/index.php
[REQUEST_URI] => /store/contact-lenses/?sidebar=1
[QUERY_STRING] => sidebar=1
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/1.1
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_QUERY_STRING] => sidebar=1
[REDIRECT_URL] => /store/contact-lenses/
[REMOTE_PORT] => 47046
[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] => 18.97.14.90
[SERVER_PORT] => 443
[SERVER_ADDR] => 172.19.0.50
[SERVER_NAME] => www.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_CONNECTION] => Keep-Alive
[HTTP_HOST] => www.eyeglassuniverse.com
[HTTP_ACCEPT_ENCODING] => br,gzip
[HTTP_IF_MODIFIED_SINCE] => Tue, 21 May 2024 18:55:44 GMT
[HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/)
[proxy-nokeepalive] => 1
[SSL_TLS_SNI] => www.eyeglassuniverse.com
[HTTPS] => on
[SCRIPT_URI] => https://www.eyeglassuniverse.com/store/contact-lenses/
[SCRIPT_URL] => /store/contact-lenses/
[UNIQUE_ID] => Z1u-QNEKAFzhBagOqoOQpgAAAAc
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] => www.eyeglassuniverse.com
[REDIRECT_HTTPS] => on
[REDIRECT_SCRIPT_URI] => https://www.eyeglassuniverse.com/store/contact-lenses/
[REDIRECT_SCRIPT_URL] => /store/contact-lenses/
[REDIRECT_UNIQUE_ID] => Z1u-QNEKAFzhBagOqoOQpgAAAAc
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /store/index.php
[REQUEST_TIME_FLOAT] => 1734065728.8198
[REQUEST_TIME] => 1734065728
[argv] => Array
(
[0] => sidebar=1
)

[argc] => 1
)

[_REQUEST] => Array
(
[sidebar] => 1
)

[_ENV] => Array
(
)

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

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

[productName] => ?sidebar=1
[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] => 1
[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] => 26042383
[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 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 = "084ee4697ab47df44e57c0a9e3b830e8" 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] =>
[i] => 0
[manufacturerID] =>
[manufacturerName] =>
[contactsBaseCurve] =>
[w] =>
[pass] =>
[perPage] => 24
[startingRecord] => 0
)

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

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

[productName] => ?sidebar=1
[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] => 1
[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] => 26042383
[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 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 = "084ee4697ab47df44e57c0a9e3b830e8" 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] =>
[i] => 0
[manufacturerID] =>
[manufacturerName] =>
[contactsBaseCurve] =>
[w] =>
[pass] =>
[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
(
[sidebar] => 1
)

[_POST] => Array
(
)

[_COOKIE] => Array
(
)

[_FILES] => Array
(
)

[_SERVER] => Array
(
[USER] => cid006
[HOME] => /home/cid006
[SCRIPT_NAME] => /store/index.php
[REQUEST_URI] => /store/contact-lenses/?sidebar=1
[QUERY_STRING] => sidebar=1
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/1.1
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_QUERY_STRING] => sidebar=1
[REDIRECT_URL] => /store/contact-lenses/
[REMOTE_PORT] => 47046
[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] => 18.97.14.90
[SERVER_PORT] => 443
[SERVER_ADDR] => 172.19.0.50
[SERVER_NAME] => www.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_CONNECTION] => Keep-Alive
[HTTP_HOST] => www.eyeglassuniverse.com
[HTTP_ACCEPT_ENCODING] => br,gzip
[HTTP_IF_MODIFIED_SINCE] => Tue, 21 May 2024 18:55:44 GMT
[HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/)
[proxy-nokeepalive] => 1
[SSL_TLS_SNI] => www.eyeglassuniverse.com
[HTTPS] => on
[SCRIPT_URI] => https://www.eyeglassuniverse.com/store/contact-lenses/
[SCRIPT_URL] => /store/contact-lenses/
[UNIQUE_ID] => Z1u-QNEKAFzhBagOqoOQpgAAAAc
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] => www.eyeglassuniverse.com
[REDIRECT_HTTPS] => on
[REDIRECT_SCRIPT_URI] => https://www.eyeglassuniverse.com/store/contact-lenses/
[REDIRECT_SCRIPT_URL] => /store/contact-lenses/
[REDIRECT_UNIQUE_ID] => Z1u-QNEKAFzhBagOqoOQpgAAAAc
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /store/index.php
[REQUEST_TIME_FLOAT] => 1734065728.8198
[REQUEST_TIME] => 1734065728
[argv] => Array
(
[0] => sidebar=1
)

[argc] => 1
)

[_REQUEST] => Array
(
[sidebar] => 1
)

[_ENV] => Array
(
)

[GLOBALS] => Array
(
[_GET] => Array
(
[sidebar] => 1
)

[_POST] => Array
(
)

[_COOKIE] => Array
(
)

[_FILES] => Array
(
)

[_SERVER] => Array
(
[USER] => cid006
[HOME] => /home/cid006
[SCRIPT_NAME] => /store/index.php
[REQUEST_URI] => /store/contact-lenses/?sidebar=1
[QUERY_STRING] => sidebar=1
[REQUEST_METHOD] => GET
[SERVER_PROTOCOL] => HTTP/1.1
[GATEWAY_INTERFACE] => CGI/1.1
[REDIRECT_QUERY_STRING] => sidebar=1
[REDIRECT_URL] => /store/contact-lenses/
[REMOTE_PORT] => 47046
[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] => 18.97.14.90
[SERVER_PORT] => 443
[SERVER_ADDR] => 172.19.0.50
[SERVER_NAME] => www.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_CONNECTION] => Keep-Alive
[HTTP_HOST] => www.eyeglassuniverse.com
[HTTP_ACCEPT_ENCODING] => br,gzip
[HTTP_IF_MODIFIED_SINCE] => Tue, 21 May 2024 18:55:44 GMT
[HTTP_ACCEPT_LANGUAGE] => en-US,en;q=0.5
[HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[HTTP_USER_AGENT] => CCBot/2.0 (https://commoncrawl.org/faq/)
[proxy-nokeepalive] => 1
[SSL_TLS_SNI] => www.eyeglassuniverse.com
[HTTPS] => on
[SCRIPT_URI] => https://www.eyeglassuniverse.com/store/contact-lenses/
[SCRIPT_URL] => /store/contact-lenses/
[UNIQUE_ID] => Z1u-QNEKAFzhBagOqoOQpgAAAAc
[REDIRECT_STATUS] => 200
[REDIRECT_SSL_TLS_SNI] => www.eyeglassuniverse.com
[REDIRECT_HTTPS] => on
[REDIRECT_SCRIPT_URI] => https://www.eyeglassuniverse.com/store/contact-lenses/
[REDIRECT_SCRIPT_URL] => /store/contact-lenses/
[REDIRECT_UNIQUE_ID] => Z1u-QNEKAFzhBagOqoOQpgAAAAc
[FCGI_ROLE] => RESPONDER
[PHP_SELF] => /store/index.php
[REQUEST_TIME_FLOAT] => 1734065728.8198
[REQUEST_TIME] => 1734065728
[argv] => Array
(
[0] => sidebar=1
)

[argc] => 1
)

[_REQUEST] => Array
(
[sidebar] => 1
)

[_ENV] => Array
(
)

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

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

[productName] => ?sidebar=1
[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] => 1
[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] => 26042383
[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 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 = "084ee4697ab47df44e57c0a9e3b830e8" 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] =>
[i] => 0
[manufacturerID] =>
[manufacturerName] =>
[contactsBaseCurve] =>
[w] =>
[pass] =>
[perPage] => 24
[startingRecord] => 0
[totalRows] =>
[pages] => 0
)

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

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

[productName] => ?sidebar=1
[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] => 1
[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] => 26042383
[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 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 = "084ee4697ab47df44e57c0a9e3b830e8" 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] =>
[i] => 0
[manufacturerID] =>
[manufacturerName] =>
[contactsBaseCurve] =>
[w] =>
[pass] =>
[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