Đang Thực Hiện

149635 Php/Sql error 1064 to correct

Cre Loaded shop to be launched soon.

Website has been tested on php 4.5 + mysql [url removed, login to view] on a shared server

The website is now being moved to a dedicated server with php 5 and latest mysql. and 2 pages calling the same function are broken because of php/mysql upgrade.

error showing is:

1064 - 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.products_id in(53)' at line 1

select count(p.products_id) as total and p.products_id in(53)

and:

1064 - 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.products_id in(52,46,53)' at line 1

select count(p.products_id) as total and p.products_id in(52,46,53)

shouldnt be too much of a problem to solve...

Kỹ năng: Bất kì công việc gì, MySQL, PHP, SQL

Xem thêm: php manual, p sql, solve php error, php sql, php solve, mysql and sql, php sql syntax error, 1064 php, function check php, mysql sql function, server upgrade php, sql select select, sql syntax error, php mysql 1064, sql select, mysql sql syntax, sql problem, sql syntax, upgrade cre, error 1064, mysql error 1064, shop sql, mysql latest version, sql error 1064 mysql, mysql shop php

Về Bên Thuê:
( 2 nhận xét ) singapore, Singapore

Mã Dự Án: #1895814

Đã trao cho:

nathanr

details in the pmb, free to start whenever you are. Can gaurentee a perfect fix + I'll be around for support on IM/Email after the project finishes :)

$25 USD trong 0 ngày
(0 Đánh Giá)
0.0